APPS.INL_CHARGE_PVT dependencies on RCV_SHIPMENT_LINES

Line 1909: rcv_shipment_lines rsl

1905: l_ship_ln_group_rec.expected_receipt_date ,
1906: l_ship_ln_tbl(l - ln_index + 1).supplier_item_num
1907: FROM rcv_transactions rtr,
1908: rcv_shipment_headers rsh,
1909: rcv_shipment_lines rsl
1910: WHERE rsh.shipment_header_id = rtr.shipment_header_id
1911: AND rsl.shipment_line_id = rtr.shipment_line_id
1912: AND rtr.lcm_shipment_line_id = p_ship_ln_tbl(l).ship_line_id
1913: AND rtr.po_line_location_id = p_ship_ln_tbl(l).ship_line_source_id;

Line 1938: rcv_shipment_lines rsl

1934: l_ship_ln_group_rec.expected_receipt_date ,
1935: l_ship_ln_tbl(l - ln_index + 1).supplier_item_num
1936: FROM rcv_transactions rtr,
1937: rcv_shipment_headers rsh,
1938: rcv_shipment_lines rsl
1939: WHERE rsh.shipment_header_id = rtr.shipment_header_id
1940: AND rsl.shipment_line_id = rtr.shipment_line_id
1941: AND rtr.lcm_shipment_line_id = p_ship_ln_tbl(l).ship_line_id
1942: AND rtr.shipment_line_id = p_ship_ln_tbl(l).ship_line_source_id;

Line 1966: rcv_shipment_lines rsl

1962: l_ship_ln_group_rec.expected_receipt_date ,
1963: l_ship_ln_tbl(l - ln_index + 1).supplier_item_num
1964: FROM rcv_transactions rtr,
1965: rcv_shipment_headers rsh,
1966: rcv_shipment_lines rsl
1967: WHERE rsh.shipment_header_id = rtr.shipment_header_id
1968: AND rsl.shipment_line_id = rtr.shipment_line_id
1969: AND rtr.lcm_shipment_line_id = p_ship_ln_tbl(l).ship_line_id;
1970: END IF;

Line 1980: rcv_shipment_lines rsl

1976: THEN
1977: SELECT rsl.vendor_item_num
1978: INTO l_ship_ln_tbl(l - ln_index + 1).supplier_item_num
1979: FROM rcv_transactions rtr,
1980: rcv_shipment_lines rsl
1981: WHERE rsl.shipment_line_id = rtr.shipment_line_id
1982: AND rtr.lcm_shipment_line_id = p_ship_ln_tbl(l).ship_line_id
1983: AND rtr.po_line_location_id = p_ship_ln_tbl(l).ship_line_source_id;
1984: ELSE

Line 1990: rcv_shipment_lines rsl

1986: rsl.vendor_item_num
1987: INTO
1988: l_ship_ln_tbl(l - ln_index + 1).supplier_item_num
1989: FROM rcv_transactions rtr,
1990: rcv_shipment_lines rsl
1991: WHERE rsl.shipment_line_id = rtr.shipment_line_id
1992: AND rtr.lcm_shipment_line_id = p_ship_ln_tbl(l).ship_line_id;
1993: END IF;
1994: END IF;