View: MRPFV_SR_BOD_ASSIGNMENTS

Product:	MRP - Master Scheduling/MRP
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MRPFV_SR_BOD_ASSIGNMENTS

View Text

SELECT LO.MEANING
, DECODE(SR.SOURCING_RULE_TYPE
, 1
, SO.SOURCING_RULE_NAME
, NULL)
, DECODE(SR.SOURCING_RULE_TYPE
, 2
, SO.SOURCING_RULE_NAME
, NULL)
, DECODE(SR.ASSIGNMENT_TYPE
, 1
, NULL
, 4
, PA.ORGANIZATION_CODE
, NULL)
, DECODE(SR.ASSIGNMENT_TYPE
, 1
, NULL
, 4
, AL.NAME
, NULL)
, CU.CUSTOMER_NAME
, AD.ADDRESS1
, '_KF:_EX:NULL'
, '_KF:_EX:NULL'
, '_DF:MRP:MRP_SR_ASSIGNMENTS:SR'
, SR.ASSIGNMENT_ID
, SR.ASSIGNMENT_SET_ID
, DECODE(SR.SOURCING_RULE_TYPE
, 1
, SR.SOURCING_RULE_ID
, NULL)
, DECODE(SR.SOURCING_RULE_TYPE
, 2
, SR.SOURCING_RULE_ID
, NULL)
, SR.ORGANIZATION_ID
, SR.CUSTOMER_ID
, SR.SHIP_TO_SITE_ID
, SR.CATEGORY_ID
, SR.CATEGORY_SET_ID
, SR.INVENTORY_ITEM_ID
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
, SR.CREATION_DATE
, SR.CREATED_BY
FROM RA_ADDRESSES AD
, RA_SITE_USES_ALL SI
, RA_CUSTOMERS CU
, MFG_LOOKUPS LO
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MRP_SOURCING_RULES SO
, MRP_SR_ASSIGNMENTS SR
WHERE SR.ASSIGNMENT_TYPE IN (1
, 4)
AND SR.SOURCING_RULE_ID = SO.SOURCING_RULE_ID
AND SR.ORGANIZATION_ID = PA.ORGANIZATION_ID(+)
AND SR.ORGANIZATION_ID = AL.ORGANIZATION_ID(+)
AND LO.LOOKUP_TYPE = 'MRP_ASSIGNMENT_TYPE'
AND LO.LOOKUP_CODE = SR.ASSIGNMENT_TYPE
AND SR.CUSTOMER_ID = CU.CUSTOMER_ID(+)
AND SR.SHIP_TO_SITE_ID = SI.SITE_USE_ID(+)
AND SI.ADDRESS_ID = AD.ADDRESS_ID(+) UNION SELECT LO.MEANING
, DECODE(SR.SOURCING_RULE_TYPE
, 1
, SO.SOURCING_RULE_NAME
, NULL)
, DECODE(SR.SOURCING_RULE_TYPE
, 2
, SO.SOURCING_RULE_NAME
, NULL)
, DECODE(SR.ASSIGNMENT_TYPE
, 2
, NULL
, 5
, PA.ORGANIZATION_CODE
, NULL)
, DECODE(SR.ASSIGNMENT_TYPE
, 2
, NULL
, 5
, AL.NAME
, NULL)
, CU.CUSTOMER_NAME
, AD.ADDRESS1
, '_KF:_EX:NULL'
, '_KF:INV:MCAT:CA'
, '_DF:MRP:MRP_SR_ASSIGNMENTS:SR'
, SR.ASSIGNMENT_ID
, SR.ASSIGNMENT_SET_ID
, DECODE(SR.SOURCING_RULE_TYPE
, 1
, SR.SOURCING_RULE_ID
, NULL)
, DECODE(SR.SOURCING_RULE_TYPE
, 2
, SR.SOURCING_RULE_ID
, NULL)
, SR.ORGANIZATION_ID
, SR.CUSTOMER_ID
, SR.SHIP_TO_SITE_ID
, SR.CATEGORY_ID
, SR.CATEGORY_SET_ID
, SR.INVENTORY_ITEM_ID
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
, SR.CREATION_DATE
, SR.CREATED_BY
FROM RA_CUSTOMERS CU
, RA_ADDRESSES AD
, RA_SITE_USES_ALL SI
, MFG_LOOKUPS LO
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_CATEGORY_SETS CAT
, MTL_CATEGORIES CA
, MRP_SOURCING_RULES SO
, MRP_SR_ASSIGNMENTS SR
WHERE SR.ASSIGNMENT_TYPE IN (2
, 5)
AND SR.SOURCING_RULE_ID = SO.SOURCING_RULE_ID
AND SR.CATEGORY_ID = CA.CATEGORY_ID
AND SR.CATEGORY_SET_ID = CAT.CATEGORY_SET_ID
AND SR.ORGANIZATION_ID = PA.ORGANIZATION_ID(+)
AND SR.ORGANIZATION_ID = AL.ORGANIZATION_ID(+)
AND LO.LOOKUP_TYPE = 'MRP_ASSIGNMENT_TYPE'
AND LO.LOOKUP_CODE = SR.ASSIGNMENT_TYPE
AND SR.CUSTOMER_ID = CU.CUSTOMER_ID(+)
AND SR.SHIP_TO_SITE_ID = SI.SITE_USE_ID(+)
AND SI.ADDRESS_ID = AD.ADDRESS_ID(+) UNION SELECT LO.MEANING
, DECODE(SR.SOURCING_RULE_TYPE
, 1
, SO.SOURCING_RULE_NAME
, NULL)
, DECODE(SR.SOURCING_RULE_TYPE
, 2
, SO.SOURCING_RULE_NAME
, NULL)
, DECODE(SR.ASSIGNMENT_TYPE
, 3
, NULL
, 6
, PA.ORGANIZATION_CODE
, NULL)
, DECODE(SR.ASSIGNMENT_TYPE
, 3
, NULL
, 6
, AL.NAME
, NULL)
, CU.CUSTOMER_NAME
, AD.ADDRESS1
, '_KF:INV:MSTK:SY'
, '_KF:_EX:NULL'
, '_DF:MRP:MRP_SR_ASSIGNMENTS:SR'
, SR.ASSIGNMENT_ID
, SR.ASSIGNMENT_SET_ID
, DECODE(SR.SOURCING_RULE_TYPE
, 1
, SR.SOURCING_RULE_ID
, NULL)
, DECODE(SR.SOURCING_RULE_TYPE
, 2
, SR.SOURCING_RULE_ID
, NULL)
, SR.ORGANIZATION_ID
, SR.CUSTOMER_ID
, SR.SHIP_TO_SITE_ID
, SR.CATEGORY_ID
, SR.CATEGORY_SET_ID
, SR.INVENTORY_ITEM_ID
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
, SR.CREATION_DATE
, SR.CREATED_BY
FROM RA_CUSTOMERS CU
, RA_ADDRESSES AD
, RA_SITE_USES_ALL SI
, MFG_LOOKUPS LO
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SY
, MRP_SOURCING_RULES SO
, MRP_SR_ASSIGNMENTS SR
WHERE SR.ASSIGNMENT_TYPE IN (3
, 6)
AND SR.SOURCING_RULE_ID = SO.SOURCING_RULE_ID
AND SR.ORGANIZATION_ID = SY.ORGANIZATION_ID(+)
AND SR.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID(+)
AND SR.ORGANIZATION_ID = PA.ORGANIZATION_ID(+)
AND SR.ORGANIZATION_ID = AL.ORGANIZATION_ID(+)
AND LO.LOOKUP_TYPE = 'MRP_ASSIGNMENT_TYPE'
AND LO.LOOKUP_CODE = SR.ASSIGNMENT_TYPE
AND SR.CUSTOMER_ID = CU.CUSTOMER_ID(+)
AND SR.SHIP_TO_SITE_ID = SI.SITE_USE_ID(+)
AND SI.ADDRESS_ID = AD.ADDRESS_ID(+) WITH READ ONLY

Columns