[Home] [Help]
View: POS_SUPPLIER_ITEM_CAPACITY_V
View Text
SELECT SIC.CAPACITY_ID
, SIC.ASL_ID
, SIC.USING_ORGANIZATION_ID
, SIC.FROM_DATE
, SIC.TO_DATE
, SIC.CAPACITY_PER_DAY
, ASL.VENDOR_ID
, ASL.VENDOR_SITE_ID
, ASL.ITEM_ID
FROM PO_SUPPLIER_ITEM_CAPACITY SIC
, PO_APPROVED_SUPPLIER_LIST ASL
WHERE SIC.USING_ORGANIZATION_ID = -1
AND SIC.ASL_ID = ASL.ASL_ID
AND NVL(SIC.TO_DATE
, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE)
Columns
Name |
CAPACITY_ID |
ASL_ID |
USING_ORGANIZATION_ID |
FROM_DATE |
TO_DATE |
CAPACITY_PER_DAY |
VENDOR_ID |
VENDOR_SITE_ID |
ITEM_ID |