View: PO_AUTOSOURCE_RULES_V

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PO_AUTOSOURCE_RULES_V

View Text

SELECT SR.SOURCING_RULE_ID
, SR.SOURCING_RULE_NAME
, SR.INVENTORY_ITEM_ID
, MSI.DESCRIPTION
, SR.EFFECTIVE_DATE
, SR.DISABLE_DATE
, SR.RANK
, SR.VENDOR_ID
, PV.VENDOR_NAME
, SR.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, SR.ALLOCATION_PERCENT
, SR.ASSIGNMENT_SET_ID
, SR.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, 'Y'
FROM MRP_ITEM_SOURCING_LEVELS_V SR
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, MTL_SYSTEM_ITEMS MSI
, MTL_PARAMETERS MP
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE SR.VENDOR_ID = PV.VENDOR_ID
AND SR.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID(+)
AND SR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND FSP.INVENTORY_ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND SR.ORGANIZATION_ID = MP.ORGANIZATION_ID(+)
AND SYSDATE BETWEEN NVL(SR.EFFECTIVE_DATE
, SYSDATE)
AND NVL(SR.DISABLE_DATE
, SYSDATE)
AND PO_ASL_SV.CHECK_ASL_ACTION('2_SOURCING'
, SR.VENDOR_ID
, SR.VENDOR_SITE_ID
, SR.INVENTORY_ITEM_ID
, -1
, SR.ORGANIZATION_ID) <>0

Columns