VIEW: APPS.PO_AUTOSOURCE_RULES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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