[Home] [Help]
1903: l_ship_ln_group_rec.freight_code ,
1904: l_ship_ln_group_rec.freight_terms ,
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
1932: l_ship_ln_group_rec.freight_code ,
1933: l_ship_ln_group_rec.freight_terms ,
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
1960: l_ship_ln_group_rec.freight_code ,
1961: l_ship_ln_group_rec.freight_terms ,
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
1975: IF p_ship_ln_group_tbl(i).src_type_code = 'PO'
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;
1985: SELECT
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;