DBA Data[Home] [Help]

APPS.CSP_PICK_UTILS dependencies on RCV_SHIPMENT_LINES

Line 2500: rcv_shipment_lines rsl,

2496: rsl.unit_of_measure,
2497: MAX(mmt.transaction_date) received_date
2498: FROM po_Requisition_lines_all prl,
2499: oe_order_lines_all oola,
2500: rcv_shipment_lines rsl,
2501: (SELECT transaction_date,
2502: transaction_source_id
2503: FROM mtl_material_transactions
2504: WHERE transaction_source_type_id IN (3, 7)

Line 2751: rcv_shipment_lines rsl,

2747: CURSOR ship_code_cur(v_line_id NUMBER) IS
2748: SELECT fl.meaning
2749: FROM po_Requisition_lines_all prl,
2750: oe_order_lines_all oola,
2751: rcv_shipment_lines rsl,
2752: FND_LOOKUP_VALUES fl
2753: WHERE prl.requisition_line_id = rsl.requisition_line_id
2754: AND oola.source_document_line_id = prl.requisition_line_id
2755: AND oola.source_document_type_id = 10