View: RLM_SCHEDULE_LINE_CUM_V

Product:	RLM - Release Management
Description:
Implementation/DBA Data:	APPS.RLM_SCHEDULE_LINE_CUM_V

View Text

SELECT D.START_DATE_TIME CUM_START_DATE
, B.CUM_KEY_ID
, C.SCHEDULE_REFERENCE_NUM
, A.ITEM_DETAIL_SUBTYPE
, A.DATE_TYPE_CODE
, A.START_DATE_TIME
, A.END_DATE_TIME
, A.QTY_TYPE_CODE
, A.ITEM_DETAIL_QUANTITY
, A.UOM_CODE
, A.SHIP_FROM_ORG_ID
, A.SHIP_TO_ORG_ID
, A.CUSTOMER_ITEM_ID
FROM RLM_SCHEDULE_LINES A
, RLM_CUST_ITEM_CUM_KEYS B
, RLM_SCHEDULE_HEADERS C
, RLM_SCHEDULE_LINES D
WHERE ( TRUNC(C.SCHED_GENERATION_DATE) >= TRUNC(B.CUM_START_DATE) OR B.CUM_START_DATE IS NULL)
AND A.CUSTOMER_ITEM_ID = B.CUSTOMER_ITEM_ID
AND A.SHIP_FROM_ORG_ID = NVL(B.SHIP_FROM_ORG_ID
, A.SHIP_FROM_ORG_ID)
AND A.SHIP_TO_ADDRESS_ID = NVL(B.SHIP_TO_ADDRESS_ID
, A.SHIP_TO_ADDRESS_ID)
AND NVL(A.BILL_TO_ADDRESS_ID
, 0) = NVL(B.BILL_TO_ADDRESS_ID
, NVL(A.BILL_TO_ADDRESS_ID
, 0))
AND NVL(A.INTRMD_SHIP_TO_ID
, 0) = NVL(B.INTRMD_SHIP_TO_ID
, NVL(A.INTRMD_SHIP_TO_ID
, 0))
AND NVL(A.CUST_PO_NUMBER
, 0) = NVL(B.PURCHASE_ORDER_NUMBER
, NVL(A.CUST_PO_NUMBER
, 0))
AND NVL(A.INDUSTRY_ATTRIBUTE1
, 0) = NVL(B.CUST_RECORD_YEAR
, NVL(A.INDUSTRY_ATTRIBUTE1
, 0))
AND C.HEADER_ID = A.HEADER_ID
AND A.ITEM_DETAIL_TYPE = '3'
AND D.HEADER_ID = A.HEADER_ID
AND D.SCHEDULE_ITEM_NUM = A.SCHEDULE_ITEM_NUM
AND D.ITEM_DETAIL_TYPE = '4'
AND D.ITEM_DETAIL_SUBTYPE = 'CUM'
AND ( TRUNC(D.START_DATE_TIME) = TRUNC(B.CUM_START_DATE) OR B.CUM_START_DATE IS NULL)
AND NVL(D.CUST_PO_NUMBER
, 0) = NVL(B.PURCHASE_ORDER_NUMBER
, NVL(D.CUST_PO_NUMBER
, 0))
AND A. ITEM_DETAIL_QUANTITY = ( SELECT MAX(A1.ITEM_DETAIL_QUANTITY)
FROM RLM_SCHEDULE_LINES A1
, RLM_CUST_ITEM_CUM_KEYS B1
, RLM_SCHEDULE_HEADERS C1
, RLM_SCHEDULE_LINES D1
WHERE ( TRUNC(C1.SCHED_GENERATION_DATE) >= TRUNC(B1.CUM_START_DATE) OR B1.CUM_START_DATE IS NULL)
AND A1.CUSTOMER_ITEM_ID = B1.CUSTOMER_ITEM_ID
AND A1.SHIP_FROM_ORG_ID = NVL(B1.SHIP_FROM_ORG_ID
, A1.SHIP_FROM_ORG_ID)
AND A1.SHIP_TO_ADDRESS_ID = NVL(B1.SHIP_TO_ADDRESS_ID
, A1.SHIP_TO_ADDRESS_ID)
AND NVL(A1.BILL_TO_ADDRESS_ID
, 0) = NVL(B1.BILL_TO_ADDRESS_ID
, NVL(A1.BILL_TO_ADDRESS_ID
, 0))
AND NVL(A1.INTRMD_SHIP_TO_ID
, 0) = NVL(B1.INTRMD_SHIP_TO_ID
, NVL(A1.INTRMD_SHIP_TO_ID
, 0))
AND NVL(A1.CUST_PO_NUMBER
, 0) = NVL(B1.PURCHASE_ORDER_NUMBER
, NVL(A1.CUST_PO_NUMBER
, 0))
AND NVL(A1.INDUSTRY_ATTRIBUTE1
, 0) = NVL(B1.CUST_RECORD_YEAR
, NVL(A1.INDUSTRY_ATTRIBUTE1
, 0))
AND C1.HEADER_ID = A1.HEADER_ID
AND A1.ITEM_DETAIL_TYPE = '3'
AND D1.HEADER_ID = A1.HEADER_ID
AND D1.SCHEDULE_ITEM_NUM = A1.SCHEDULE_ITEM_NUM
AND D1.ITEM_DETAIL_TYPE = '4'
AND D1.ITEM_DETAIL_SUBTYPE = 'CUM'
AND ( TRUNC(D1.START_DATE_TIME) = TRUNC(B1.CUM_START_DATE) OR B1.CUM_START_DATE IS NULL)
AND NVL(D1.CUST_PO_NUMBER
, 0) = NVL(B.PURCHASE_ORDER_NUMBER
, NVL(D1.CUST_PO_NUMBER
, 0))
AND B1.CUM_KEY_ID = B.CUM_KEY_ID
AND A1.ITEM_DETAIL_SUBTYPE = A.ITEM_DETAIL_SUBTYPE )

Columns