VIEW: APPS.PO_SOURCE_VENDORS_V

Source

View Text - Preformatted

SELECT PAR.ITEM_ID , POV.VENDOR_NAME , PAV.VENDOR_RANK , PLL.QUANTITY , PLL.QUANTITY_CANCELLED , PLL.PRICE_OVERRIDE , POH.RATE , PAV.SPLIT , TO_NUMBER(NULL) , TO_NUMBER(NULL) , POH.CREATION_DATE , 'N' , POL.ORG_ID FROM PO_AUTOSOURCE_RULES PAR , PO_LINES POL , PO_AUTOSOURCE_VENDORS PAV , PO_HEADERS_ALL POH , PO_LINE_LOCATIONS_ALL PLL , PO_VENDORS POV WHERE PAR.ITEM_ID = POL.ITEM_ID AND POH.PO_HEADER_ID = POL.PO_HEADER_ID AND POL.PO_LINE_ID = PLL.PO_LINE_ID AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED') AND POV.VENDOR_ID = POH.VENDOR_ID AND PAV.VENDOR_ID = POV.VENDOR_ID AND SYSDATE BETWEEN PAR.START_DATE AND PAR.END_DATE AND PAR.AUTOSOURCE_RULE_ID = PAV.AUTOSOURCE_RULE_ID UNION SELECT SR.INVENTORY_ITEM_ID , POV.VENDOR_NAME , SR.RANK , PLL.QUANTITY , PLL.QUANTITY_CANCELLED , PLL.PRICE_OVERRIDE , POH.RATE , SR.ALLOCATION_PERCENT , SR.ORGANIZATION_ID , SR.ASSIGNMENT_SET_ID , POH.CREATION_DATE , 'Y' , POL.ORG_ID FROM PO_VENDORS POV , PO_LINES POL , PO_LINE_LOCATIONS_ALL PLL , PO_HEADERS_ALL POH , MRP_SOURCES_V SR WHERE SR.INVENTORY_ITEM_ID = POL.ITEM_ID AND POH.PO_HEADER_ID = POL.PO_HEADER_ID AND POL.PO_LINE_ID = PLL.PO_LINE_ID AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED') AND PLL.SHIP_TO_ORGANIZATION_ID = SR.ORGANIZATION_ID AND POV.VENDOR_ID = POH.VENDOR_ID AND SR.VENDOR_ID = POH.VENDOR_ID AND NVL(SR.VENDOR_SITE_ID, -1) = NVL(POH.VENDOR_SITE_ID, -1) AND SYSDATE BETWEEN NVL(SR.EFFECTIVE_DATE, SYSDATE-1) AND NVL(SR.DISABLE_DATE, SYSDATE+1)

View Text - HTML Formatted

SELECT PAR.ITEM_ID
, POV.VENDOR_NAME
, PAV.VENDOR_RANK
, PLL.QUANTITY
, PLL.QUANTITY_CANCELLED
, PLL.PRICE_OVERRIDE
, POH.RATE
, PAV.SPLIT
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, POH.CREATION_DATE
, 'N'
, POL.ORG_ID
FROM PO_AUTOSOURCE_RULES PAR
, PO_LINES POL
, PO_AUTOSOURCE_VENDORS PAV
, PO_HEADERS_ALL POH
, PO_LINE_LOCATIONS_ALL PLL
, PO_VENDORS POV
WHERE PAR.ITEM_ID = POL.ITEM_ID
AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND POL.PO_LINE_ID = PLL.PO_LINE_ID
AND PLL.SHIPMENT_TYPE IN ('STANDARD'
, 'BLANKET'
, 'SCHEDULED')
AND POV.VENDOR_ID = POH.VENDOR_ID
AND PAV.VENDOR_ID = POV.VENDOR_ID
AND SYSDATE BETWEEN PAR.START_DATE
AND PAR.END_DATE
AND PAR.AUTOSOURCE_RULE_ID = PAV.AUTOSOURCE_RULE_ID UNION SELECT SR.INVENTORY_ITEM_ID
, POV.VENDOR_NAME
, SR.RANK
, PLL.QUANTITY
, PLL.QUANTITY_CANCELLED
, PLL.PRICE_OVERRIDE
, POH.RATE
, SR.ALLOCATION_PERCENT
, SR.ORGANIZATION_ID
, SR.ASSIGNMENT_SET_ID
, POH.CREATION_DATE
, 'Y'
, POL.ORG_ID
FROM PO_VENDORS POV
, PO_LINES POL
, PO_LINE_LOCATIONS_ALL PLL
, PO_HEADERS_ALL POH
, MRP_SOURCES_V SR
WHERE SR.INVENTORY_ITEM_ID = POL.ITEM_ID
AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND POL.PO_LINE_ID = PLL.PO_LINE_ID
AND PLL.SHIPMENT_TYPE IN ('STANDARD'
, 'BLANKET'
, 'SCHEDULED')
AND PLL.SHIP_TO_ORGANIZATION_ID = SR.ORGANIZATION_ID
AND POV.VENDOR_ID = POH.VENDOR_ID
AND SR.VENDOR_ID = POH.VENDOR_ID
AND NVL(SR.VENDOR_SITE_ID
, -1) = NVL(POH.VENDOR_SITE_ID
, -1)
AND SYSDATE BETWEEN NVL(SR.EFFECTIVE_DATE
, SYSDATE-1)
AND NVL(SR.DISABLE_DATE
, SYSDATE+1)