FND Design Data [Home] [Help]

View: PO_SOURCE_VENDORS_V

Product: PO - Purchasing
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.PO_SOURCE_VENDORS_V
View Text

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)

Columns

Name
ITEM_ID
VENDOR
RANK
QUANTITY
QUANTITY_CANCELLED
PRICE_OVERRIDE
RATE
SPLIT
ORGANIZATION_ID
ASSIGNMENT_SET_ID
PO_CREATION_DATE
USE_SR_FLAG
ORG_ID