VIEW: APPS.CSD_POST_RO_GROUP_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'