View: MRPBV_SR_BOD_ASSIGNMENTS

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

View Text

SELECT LO.MEANING
, 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 MFG_LOOKUPS LO
, MRP_SR_ASSIGNMENTS SR
WHERE LO.LOOKUP_TYPE = 'MRP_ASSIGNMENT_TYPE'
AND LO.LOOKUP_CODE = SR.ASSIGNMENT_TYPE WITH READ ONLY

Columns