APPS.PO_CHARGES_GRP dependencies on RCV_SHIPMENT_HEADERS

Line 92: FROM rcv_shipment_headers rsh,

88: AND nvl(pll.lcm_flag, 'N') = 'N'
89: UNION
90: -- import ASN
91: SELECT rsh.shipment_header_id
92: FROM rcv_shipment_headers rsh,
93: rcv_headers_interface rhi,
94: rcv_parameters rp
95: WHERE rhi.group_id = DECODE(p_group_id, 0, rhi.group_id, p_group_id)
96: AND rsh.shipment_num = rhi.shipment_num

Line 124: l_rsh_id RCV_SHIPMENT_HEADERS.shipment_header_id%type;

120: l_header_rec PO_ADVANCED_PRICE_PVT.Header_Rec_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;

Line 126: l_currency_code RCV_SHIPMENT_HEADERS.currency_code%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:
130: l_return_status VARCHAR2(1);

Line 166: FROM rcv_shipment_headers

162: conversion_rate_type,
163: organization_id,
164: expected_receipt_date
165: INTO l_header_rec
166: FROM rcv_shipment_headers
167: WHERE shipment_header_id = l_rsh_id;
168:
169: IF (g_asn_debug = 'Y') THEN
170: asn_debug.put_line('Populating l_line_rec');