APPS.PO_CHARGES_GRP dependencies on RCV_SHIPMENT_LINES

Line 125: l_rsl_id RCV_SHIPMENT_LINES.shipment_line_id%type;

121: l_line_rec_table PO_ADVANCED_PRICE_PVT.Line_Tbl_Type;
122: l_freight_charge_tbl PO_ADVANCED_PRICE_PVT.Freight_Charges_Rec_Tbl_Type;
123: l_qp_cost_table PO_ADVANCED_PRICE_PVT.Qp_Price_Result_Rec_Tbl_Type;
124: l_rsh_id RCV_SHIPMENT_HEADERS.shipment_header_id%type;
125: l_rsl_id RCV_SHIPMENT_LINES.shipment_line_id%type;
126: l_currency_code RCV_SHIPMENT_HEADERS.currency_code%type;
127:
128: l_line_quantities DBMS_SQL.number_table;
129:

Line 197: FROM rcv_shipment_lines rsl,

193: rsl.source_document_code,
194: pla.unit_price,
195: decode(rsl.quantity_received, 0, rsl.quantity_shipped, rsl.quantity_received)
196: BULK COLLECT INTO l_line_rec_table
197: FROM rcv_shipment_lines rsl,
198: po_lines_all pla,
199: po_headers_all pha,
200: po_line_locations_all plla
201: WHERE rsl.po_line_id = pla.po_line_id

Line 765: FROM rcv_shipment_lines

761: FROM dual;
762:
763: SELECT shipment_header_id
764: INTO l_fte_actual_charges(1).shipment_header_id
765: FROM rcv_shipment_lines
766: WHERE shipment_line_id = l_fte_actual_charges(1).shipment_line_id;
767:
768: IF l_fte_actual_charges(1).shipment_header_id IS NULL THEN
769: RAISE l_invalid_shipment;