INV_ABC_ASSIGNMENT

Details

Schema: FUSION
Object owner: INV
Object type: VIEW

Columns

Name
ASGN_ABC_ASSIGNMENT_ID ASGN_CREATED_BY ASGN_CREATION_DATE ASGN_INVENTORY_ITEM_ID ASGN_JOB_DEFINITION_NAME ASGN_JOB_DEFINITION_PACKAGE ASGN_LAST_UPDATE_DATE ASGN_LAST_UPDATE_LOGIN ASGN_LAST_UPDATED_BY ASGN_OBJECT_VERSION_NUMBER ORGANIZATION_ID ASGN_REQUEST_ID AGC_ABC_CLASS_ID AGC_ABC_GROUP_CLASS_ID AGC_CREATED_BY AGC_CREATION_DATE AGC_ITEM_SEQ_NUMBER AGC_JOB_DEFINITION_NAME AGC_JOB_DEFINITION_PACKAGE AGC_LAST_UPDATE_DATE AGC_LAST_UPDATE_LOGIN AGC_LAST_UPDATED_BY AGC_OBJECT_VERSION_NUMBER AGC_PERCENT_OF_ITEMS AGC_PERCENT_OF_VALUE AGC_REQUEST_ID AGC_SEQUENCE_NUMBER AG_ASSIGNMENT_GROUP_ID AG_ASSIGNMENT_GROUP_NAME AG_COMPILE_ID AG_CREATED_BY AG_CREATION_DATE AG_ITEM_SCOPE_TYPE AG_JOB_DEFINITION_NAME AG_JOB_DEFINITION_PACKAGE AG_LAST_UPDATE_DATE AG_LAST_UPDATE_LOGIN AG_LAST_UPDATED_BY AG_OBJECT_VERSION_NUMBER AG_ORGANIZATION_ID AG_REQUEST_ID AG_SECONDARY_INVENTORY

Name

ASGN_ABC_ASSIGNMENT_ID

ASGN_CREATED_BY

ASGN_CREATION_DATE

ASGN_INVENTORY_ITEM_ID

ASGN_JOB_DEFINITION_NAME

ASGN_JOB_DEFINITION_PACKAGE

ASGN_LAST_UPDATE_DATE

ASGN_LAST_UPDATE_LOGIN

ASGN_LAST_UPDATED_BY

ASGN_OBJECT_VERSION_NUMBER

ORGANIZATION_ID

ASGN_REQUEST_ID

AGC_ABC_CLASS_ID

AGC_ABC_GROUP_CLASS_ID

AGC_CREATED_BY

AGC_CREATION_DATE

AGC_ITEM_SEQ_NUMBER

AGC_JOB_DEFINITION_NAME

AGC_JOB_DEFINITION_PACKAGE

AGC_LAST_UPDATE_DATE

AGC_LAST_UPDATE_LOGIN

AGC_LAST_UPDATED_BY

AGC_OBJECT_VERSION_NUMBER

AGC_PERCENT_OF_ITEMS

AGC_PERCENT_OF_VALUE

AGC_REQUEST_ID

AGC_SEQUENCE_NUMBER

AG_ASSIGNMENT_GROUP_ID

AG_ASSIGNMENT_GROUP_NAME

AG_COMPILE_ID

AG_CREATED_BY

AG_CREATION_DATE

AG_ITEM_SCOPE_TYPE

AG_JOB_DEFINITION_NAME

AG_JOB_DEFINITION_PACKAGE

AG_LAST_UPDATE_DATE

AG_LAST_UPDATE_LOGIN

AG_LAST_UPDATED_BY

AG_OBJECT_VERSION_NUMBER

AG_ORGANIZATION_ID

AG_REQUEST_ID

AG_SECONDARY_INVENTORY

Query

SQL_Statement
SELECT ASGN.ABC_ASSIGNMENT_ID ASGN_ABC_ASSIGNMENT_ID, ASGN.CREATED_BY ASGN_CREATED_BY, ASGN.CREATION_DATE ASGN_CREATION_DATE, ASGN.INVENTORY_ITEM_ID ASGN_INVENTORY_ITEM_ID, ASGN.JOB_DEFINITION_NAME ASGN_JOB_DEFINITION_NAME, ASGN.JOB_DEFINITION_PACKAGE ASGN_JOB_DEFINITION_PACKAGE, ASGN.LAST_UPDATE_DATE ASGN_LAST_UPDATE_DATE, ASGN.LAST_UPDATE_LOGIN ASGN_LAST_UPDATE_LOGIN, ASGN.LAST_UPDATED_BY ASGN_LAST_UPDATED_BY, ASGN.OBJECT_VERSION_NUMBER ASGN_OBJECT_VERSION_NUMBER, ASGN.ORGANIZATION_ID ORGANIZATION_ID, ASGN.REQUEST_ID ASGN_REQUEST_ID, AGC.ABC_CLASS_ID AGC_ABC_CLASS_ID, AGC.ABC_GROUP_CLASS_ID AGC_ABC_GROUP_CLASS_ID, AGC.CREATED_BY AGC_CREATED_BY, AGC.CREATION_DATE AGC_CREATION_DATE, AGC.ITEM_SEQ_NUMBER AGC_ITEM_SEQ_NUMBER, AGC.JOB_DEFINITION_NAME AGC_JOB_DEFINITION_NAME, AGC.JOB_DEFINITION_PACKAGE AGC_JOB_DEFINITION_PACKAGE, AGC.LAST_UPDATE_DATE AGC_LAST_UPDATE_DATE, AGC.LAST_UPDATE_LOGIN AGC_LAST_UPDATE_LOGIN, AGC.LAST_UPDATED_BY AGC_LAST_UPDATED_BY, AGC.OBJECT_VERSION_NUMBER AGC_OBJECT_VERSION_NUMBER, AGC.PERCENT_OF_ITEMS AGC_PERCENT_OF_ITEMS, AGC.PERCENT_OF_VALUE AGC_PERCENT_OF_VALUE, AGC.REQUEST_ID AGC_REQUEST_ID, AGC.SEQUENCE_NUMBER AGC_SEQUENCE_NUMBER, AG.ASSIGNMENT_GROUP_ID AG_ASSIGNMENT_GROUP_ID, AG.ASSIGNMENT_GROUP_NAME AG_ASSIGNMENT_GROUP_NAME, AG.COMPILE_ID AG_COMPILE_ID, AG.CREATED_BY AG_CREATED_BY, AG.CREATION_DATE AG_CREATION_DATE, AG.ITEM_SCOPE_TYPE AG_ITEM_SCOPE_TYPE, AG.JOB_DEFINITION_NAME AG_JOB_DEFINITION_NAME, AG.JOB_DEFINITION_PACKAGE AG_JOB_DEFINITION_PACKAGE, AG.LAST_UPDATE_DATE AG_LAST_UPDATE_DATE, AG.LAST_UPDATE_LOGIN AG_LAST_UPDATE_LOGIN, AG.LAST_UPDATED_BY AG_LAST_UPDATED_BY, AG.OBJECT_VERSION_NUMBER AG_OBJECT_VERSION_NUMBER, AG.ORGANIZATION_ID AG_ORGANIZATION_ID, AG.REQUEST_ID AG_REQUEST_ID, AG.SECONDARY_INVENTORY AG_SECONDARY_INVENTORY FROM INV_ABC_ASSIGNMENTS ASGN, INV_ABC_ASSGN_GROUP_CLASSES AGC, INV_ABC_ASSIGNMENT_GROUPS AG WHERE AG.ASSIGNMENT_GROUP_ID = ASGN.ASSIGNMENT_GROUP_ID(+) AND AG.ASSIGNMENT_GROUP_ID = AGC.ASSIGNMENT_GROUP_ID(+) AND AGC.ASSIGNMENT_GROUP_ID = ASGN.ASSIGNMENT_GROUP_ID(+) AND AGC.ABC_CLASS_ID = ASGN.ABC_CLASS_ID(+)

SQL_Statement

SELECT

ASGN.ABC_ASSIGNMENT_ID ASGN_ABC_ASSIGNMENT_ID, ASGN.CREATED_BY ASGN_CREATED_BY, ASGN.CREATION_DATE ASGN_CREATION_DATE, ASGN.INVENTORY_ITEM_ID ASGN_INVENTORY_ITEM_ID, ASGN.JOB_DEFINITION_NAME ASGN_JOB_DEFINITION_NAME,

ASGN.JOB_DEFINITION_PACKAGE ASGN_JOB_DEFINITION_PACKAGE, ASGN.LAST_UPDATE_DATE ASGN_LAST_UPDATE_DATE,

ASGN.LAST_UPDATE_LOGIN ASGN_LAST_UPDATE_LOGIN, ASGN.LAST_UPDATED_BY ASGN_LAST_UPDATED_BY,

ASGN.OBJECT_VERSION_NUMBER ASGN_OBJECT_VERSION_NUMBER, ASGN.ORGANIZATION_ID ORGANIZATION_ID,

ASGN.REQUEST_ID ASGN_REQUEST_ID,

AGC.ABC_CLASS_ID AGC_ABC_CLASS_ID, AGC.ABC_GROUP_CLASS_ID AGC_ABC_GROUP_CLASS_ID, AGC.CREATED_BY AGC_CREATED_BY, AGC.CREATION_DATE AGC_CREATION_DATE, AGC.ITEM_SEQ_NUMBER AGC_ITEM_SEQ_NUMBER, AGC.JOB_DEFINITION_NAME AGC_JOB_DEFINITION_NAME, AGC.JOB_DEFINITION_PACKAGE AGC_JOB_DEFINITION_PACKAGE, AGC.LAST_UPDATE_DATE AGC_LAST_UPDATE_DATE, AGC.LAST_UPDATE_LOGIN AGC_LAST_UPDATE_LOGIN, AGC.LAST_UPDATED_BY AGC_LAST_UPDATED_BY, AGC.OBJECT_VERSION_NUMBER AGC_OBJECT_VERSION_NUMBER, AGC.PERCENT_OF_ITEMS AGC_PERCENT_OF_ITEMS, AGC.PERCENT_OF_VALUE AGC_PERCENT_OF_VALUE, AGC.REQUEST_ID AGC_REQUEST_ID, AGC.SEQUENCE_NUMBER AGC_SEQUENCE_NUMBER,

AG.ASSIGNMENT_GROUP_ID AG_ASSIGNMENT_GROUP_ID, AG.ASSIGNMENT_GROUP_NAME AG_ASSIGNMENT_GROUP_NAME,

AG.COMPILE_ID AG_COMPILE_ID, AG.CREATED_BY AG_CREATED_BY, AG.CREATION_DATE AG_CREATION_DATE,

AG.ITEM_SCOPE_TYPE AG_ITEM_SCOPE_TYPE, AG.JOB_DEFINITION_NAME AG_JOB_DEFINITION_NAME,

AG.JOB_DEFINITION_PACKAGE AG_JOB_DEFINITION_PACKAGE, AG.LAST_UPDATE_DATE AG_LAST_UPDATE_DATE, AG.LAST_UPDATE_LOGIN AG_LAST_UPDATE_LOGIN, AG.LAST_UPDATED_BY AG_LAST_UPDATED_BY, AG.OBJECT_VERSION_NUMBER AG_OBJECT_VERSION_NUMBER, AG.ORGANIZATION_ID AG_ORGANIZATION_ID, AG.REQUEST_ID AG_REQUEST_ID, AG.SECONDARY_INVENTORY AG_SECONDARY_INVENTORY

FROM

INV_ABC_ASSIGNMENTS ASGN,

INV_ABC_ASSGN_GROUP_CLASSES AGC,

INV_ABC_ASSIGNMENT_GROUPS AG

WHERE

AG.ASSIGNMENT_GROUP_ID = ASGN.ASSIGNMENT_GROUP_ID(+) AND

AG.ASSIGNMENT_GROUP_ID = AGC.ASSIGNMENT_GROUP_ID(+) AND

AGC.ASSIGNMENT_GROUP_ID = ASGN.ASSIGNMENT_GROUP_ID(+) AND

AGC.ABC_CLASS_ID = ASGN.ABC_CLASS_ID(+)