VIEW: APPS.MRPFV_SOURCING_RULES

Source

View Text - Preformatted

SELECT SO.SOURCING_RULE_NAME , PA.ORGANIZATION_CODE , AL.NAME , SO.DESCRIPTION , LO.MEANING , '_DF:MRP:MRP_SOURCING_RULES:so' , SO.SOURCING_RULE_ID , SO.ORGANIZATION_ID , SO.LAST_UPDATE_DATE , SO.LAST_UPDATED_BY , SO.CREATION_DATE , SO.CREATED_BY FROM MFG_LOOKUPS LO ,MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS AL ,MRP_SOURCING_RULES SO WHERE SO.SOURCING_RULE_TYPE = 1 AND SO.ORGANIZATION_ID = PA.ORGANIZATION_ID(+) AND SO.ORGANIZATION_ID = AL.ORGANIZATION_ID(+) AND SO.PLANNING_ACTIVE = LO.LOOKUP_CODE AND LO.LOOKUP_TYPE = 'SYS_YES_NO' AND '_SEC:SO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT SO.SOURCING_RULE_NAME
, PA.ORGANIZATION_CODE
, AL.NAME
, SO.DESCRIPTION
, LO.MEANING
, '_DF:MRP:MRP_SOURCING_RULES:SO'
, SO.SOURCING_RULE_ID
, SO.ORGANIZATION_ID
, SO.LAST_UPDATE_DATE
, SO.LAST_UPDATED_BY
, SO.CREATION_DATE
, SO.CREATED_BY
FROM MFG_LOOKUPS LO
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MRP_SOURCING_RULES SO
WHERE SO.SOURCING_RULE_TYPE = 1
AND SO.ORGANIZATION_ID = PA.ORGANIZATION_ID(+)
AND SO.ORGANIZATION_ID = AL.ORGANIZATION_ID(+)
AND SO.PLANNING_ACTIVE = LO.LOOKUP_CODE
AND LO.LOOKUP_TYPE = 'SYS_YES_NO'
AND '_SEC:SO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY