Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT DLH.DELIVERABLE_ID
, DLH.DELIVERABLE_NAME
, DLH.DESCRIPTION
, DLH.ACTUAL_AVAIL_FROM_DATE
, DLH.ACTUAL_AVAIL_TO_DATE
, DLH.USER_STATUS_ID
, DLH.USER_STATUS
, DLH.NON_INV_QUANTITY_ON_HAND
, DLH.NON_INV_QUANTITY_ON_ORDER
, DLH.NON_INV_QUANTITY_ON_RESERVE
, DLH.INVENTORY_ITEM_ID
, DLH.INVENTORY_ITEM_ORG_ID
, ITM.CONCATENATED_SEGMENTS ITEM_NUMBER
, ITM.DESCRIPTION ITEM_DESCRIPTION
, ITM.PRIMARY_UOM_CODE
, ITM.PRIMARY_UNIT_OF_MEASURE
, DLH.CHARGEBACK_UOM
, CMP.CAMPAIGN_ID
, CMP.CAMPAIGN_NAME
, CMP.SOURCE_CODE
, DLH.ATTRIBUTE_CATEGORY
, DLH.ATTRIBUTE1
, DLH.ATTRIBUTE2
, DLH.ATTRIBUTE3
, DLH.ATTRIBUTE4
, DLH.ATTRIBUTE5
, DLH.ATTRIBUTE6
, DLH.ATTRIBUTE7
, DLH.ATTRIBUTE8
, DLH.ATTRIBUTE9
, DLH.ATTRIBUTE10
, DLH.ATTRIBUTE11
, DLH.ATTRIBUTE12
, DLH.ATTRIBUTE13
, DLH.ATTRIBUTE14
, DLH.ATTRIBUTE15
FROM AMS_P_DELIVERABLES_V DLH
, MTL_SYSTEM_ITEMS_VL ITM
, AST_CAMPAIGNS_VL CMP
WHERE ITM.INVENTORY_ITEM_ID (+) = DLH.INVENTORY_ITEM_ID
AND DLH.ACTIVE_FLAG = 'Y'
AND (NVL(DLH.CAN_FULFILL_PHYSICAL_FLAG
, 'X') = 'Y' OR NVL(DLH.CAN_FULFILL_ELECTRONIC_FLAG
, 'X') = 'Y')
AND ITM.ORGANIZATION_ID (+) = DLH.INVENTORY_ITEM_ORG_ID
AND CMP.CMP_DELIVERABLE_ID (+) = DLH.DELIVERABLE_ID
AND TRUNC(SYSDATE) BETWEEN NVL(DLH.ACTUAL_AVAIL_FROM_DATE
, TRUNC(SYSDATE))
AND NVL(DLH.ACTUAL_AVAIL_TO_DATE
, TRUNC(SYSDATE))