View: CSD_PRE_RO_GROUP_V

Product:	CSD - Depot Repair
Description:	View based on which pre repair logistics are performed.
Implementation/DBA Data:	APPS.CSD_PRE_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
, RCV.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
, RCV_TRANSACTIONS RCV
, 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 RCV.OE_ORDER_LINE_ID(+) = OOL.LINE_ID
AND RCV.TRANSACTION_TYPE(+) = 'RECEIVE'
AND CPT.PROD_TXN_CODE = 'PRE'
AND FL.LOOKUP_TYPE = 'CSD_PRODUCT_ACTION_CODE'
AND FL.LOOKUP_CODE = CPT.ACTION_CODE

Columns