VIEW: APPS.CSM_ORDER_LINES_V

Source

View Text - Preformatted

SELECT oel.LINE_ID ACCESS_ID , oel.LINE_ID , oel.HEADER_ID , oel.LINE_NUMBER , oel.ORG_ID , oel.TASK_ID , oel.SCHEDULE_ARRIVAL_DATE , oel.SHIPPING_METHOD_CODE , oel.ORDER_SOURCE_ID , oel.ACTUAL_SHIPMENT_DATE , oel.FULFILLMENT_DATE ,oel.flow_status_code ,(select sum(QUANTITY_RECEIVED) from rcv_shipment_lines where source_document_code='REQ' AND requisition_line_id=oel.source_document_line_id) as received_qty ,CSP_PICK_UTILS.get_order_status (oel.LINE_ID, oel.FLOW_STATUS_CODE) order_status ,oel.ordered_quantity ,oel.shipped_quantity ,oel.ship_from_org_id ,oel.subinventory ,oel.cancelled_quantity ,(select shipment_num from rcv_shipment_lines rl,rcv_shipment_headers rh where source_document_code='REQ' AND requisition_line_id=oel.source_document_line_id and rl.shipment_header_id=rh.shipment_header_id and rownum=1) SHIPMENT_NUM ,flv.meaning SHIP_METHOD_MEANING ,oel.inventory_item_id from csm_req_line_details_acc acc,csp_req_line_details rld,oe_order_lines_all oel ,fnd_lookup_values flv WHERE rld.REQ_LINE_DETAIL_ID=acc.REQ_LINE_DETAIL_ID and acc.user_id=asg_base.get_user_id and rld.sourcE_type='IO' and rld.source_id=oel.line_id and flv.lookup_type='SHIP_METHOD' and flv.lookup_code=oel.SHIPPING_METHOD_CODE and flv.language=asg_base.get_language

View Text - HTML Formatted

SELECT OEL.LINE_ID ACCESS_ID
, OEL.LINE_ID
, OEL.HEADER_ID
, OEL.LINE_NUMBER
, OEL.ORG_ID
, OEL.TASK_ID
, OEL.SCHEDULE_ARRIVAL_DATE
, OEL.SHIPPING_METHOD_CODE
, OEL.ORDER_SOURCE_ID
, OEL.ACTUAL_SHIPMENT_DATE
, OEL.FULFILLMENT_DATE
, OEL.FLOW_STATUS_CODE
, (SELECT SUM(QUANTITY_RECEIVED)
FROM RCV_SHIPMENT_LINES
WHERE SOURCE_DOCUMENT_CODE='REQ'
AND REQUISITION_LINE_ID=OEL.SOURCE_DOCUMENT_LINE_ID) AS RECEIVED_QTY
, CSP_PICK_UTILS.GET_ORDER_STATUS (OEL.LINE_ID
, OEL.FLOW_STATUS_CODE) ORDER_STATUS
, OEL.ORDERED_QUANTITY
, OEL.SHIPPED_QUANTITY
, OEL.SHIP_FROM_ORG_ID
, OEL.SUBINVENTORY
, OEL.CANCELLED_QUANTITY
, (SELECT SHIPMENT_NUM
FROM RCV_SHIPMENT_LINES RL
, RCV_SHIPMENT_HEADERS RH
WHERE SOURCE_DOCUMENT_CODE='REQ'
AND REQUISITION_LINE_ID=OEL.SOURCE_DOCUMENT_LINE_ID
AND RL.SHIPMENT_HEADER_ID=RH.SHIPMENT_HEADER_ID
AND ROWNUM=1) SHIPMENT_NUM
, FLV.MEANING SHIP_METHOD_MEANING
, OEL.INVENTORY_ITEM_ID
FROM CSM_REQ_LINE_DETAILS_ACC ACC
, CSP_REQ_LINE_DETAILS RLD
, OE_ORDER_LINES_ALL OEL
, FND_LOOKUP_VALUES FLV
WHERE RLD.REQ_LINE_DETAIL_ID=ACC.REQ_LINE_DETAIL_ID
AND ACC.USER_ID=ASG_BASE.GET_USER_ID
AND RLD.SOURCE_TYPE='IO'
AND RLD.SOURCE_ID=OEL.LINE_ID
AND FLV.LOOKUP_TYPE='SHIP_METHOD'
AND FLV.LOOKUP_CODE=OEL.SHIPPING_METHOD_CODE
AND FLV.LANGUAGE=ASG_BASE.GET_LANGUAGE