View: CSD_POST_RO_GROUP_V

Product:	CSD - Depot Repair
Description:	View based on which post repair logistics are performed.
Implementation/DBA Data:	APPS.CSD_POST_RO_GROUP_V

View Text

SELECT CPT.ROWID
, CROG.REPAIR_GROUP_ID
, CPT.PRODUCT_TRANSACTION_ID
, CPT.ACTION_TYPE
, FL.MEANING ACTION_CODE
, CPT.PROD_TXN_STATUS
, WDD.SUBINVENTORY
, CPT.CREATED_BY
, CPT.CREATION_DATE
, CPT.LAST_UPDATED_BY
, CPT.LAST_UPDATE_DATE
, CPT.LAST_UPDATE_LOGIN
, OOH.ORDER_NUMBER
, OOH.HEADER_ID
FROM CSD_REPAIR_ORDER_GROUPS CROG
, CSD_REPAIRS CR
, CSD_PRODUCT_TRANSACTIONS CPT
, CS_ESTIMATE_DETAILS CED
, OE_ORDER_HEADERS_ALL OOH
, OE_ORDER_LINES_ALL OOL
, WSH_DELIVERY_DETAILS WDD
, FND_LOOKUPS FL
WHERE CROG.REPAIR_GROUP_ID = CR.REPAIR_GROUP_ID
AND CR.REPAIR_LINE_ID = CPT.REPAIR_LINE_ID
AND CPT.ESTIMATE_DETAIL_ID = CED.ESTIMATE_DETAIL_ID
AND CED.ORDER_LINE_ID = OOL.LINE_ID(+)
AND OOL.HEADER_ID = OOH.HEADER_ID(+)
AND WDD.SOURCE_LINE_ID(+) = OOL.LINE_ID
AND CPT.PROD_TXN_CODE = 'POST'
AND FL.LOOKUP_CODE = CPT.ACTION_CODE
AND FL.LOOKUP_TYPE = 'CSD_PRODUCT_ACTION_CODE'

Columns