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 202: FROM rcv_shipment_lines rsl,

198: ROUND(decode(rsl.quantity_received, 0, rsl.quantity_shipped, rsl.quantity_received)*
199: po_uom_s.po_uom_convert(rsl.unit_of_measure,NVL(pla.unit_meas_lookup_code,plla.unit_meas_lookup_code),nvl(rsl.item_id,0)),9),
200: NULL --order_type added for pricing enhancement
201: BULK COLLECT INTO l_line_rec_table
202: FROM rcv_shipment_lines rsl,
203: po_lines_all pla,
204: po_headers_all pha,
205: po_line_locations_all plla
206: WHERE rsl.po_line_id = pla.po_line_id

Line 287: FROM rcv_shipment_lines

283: ** If yes, check then treat it as line level charge */
284: Begin
285: SELECT 'Y'
286: INTO l_line_level_charge
287: FROM rcv_shipment_lines
288: WHERE shipment_header_id = l_rsh_id
289: AND EXISTS (SELECT 1
290: FROM rcv_shipment_lines
291: WHERE shipment_header_id = l_rsh_id

Line 290: FROM rcv_shipment_lines

286: INTO l_line_level_charge
287: FROM rcv_shipment_lines
288: WHERE shipment_header_id = l_rsh_id
289: AND EXISTS (SELECT 1
290: FROM rcv_shipment_lines
291: WHERE shipment_header_id = l_rsh_id
292: AND shipment_line_id = shipment_header_id);
293:
294: Exception

Line 795: FROM rcv_shipment_lines

791: FROM dual;
792:
793: SELECT shipment_header_id
794: INTO l_fte_actual_charges(1).shipment_header_id
795: FROM rcv_shipment_lines
796: WHERE shipment_line_id = l_fte_actual_charges(1).shipment_line_id;
797:
798: IF l_fte_actual_charges(1).shipment_header_id IS NULL THEN
799: RAISE l_invalid_shipment;