DBA Data[Home] [Help]

APPS.CSP_PICK_UTILS dependencies on PO_REQUISITION_LINES_ALL

Line 2498: FROM po_Requisition_lines_all prl,

2494: SELECT rsl.shipment_line_status_code,
2495: SUM(rsl.quantity_received),
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

Line 2749: FROM po_Requisition_lines_all prl,

2745: WHERE source_line_id = v_line_id;
2746:
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