DBA Data[Home] [Help]

APPS.PO_PDOI_HEADER_PROCESS_PVT dependencies on PO_VENDORS

Line 979: -- The following columns are being obsoleted from PO_VENDORS level.

975:
976: -- information defaulted from vendor
977:
978: --
979: -- The following columns are being obsoleted from PO_VENDORS level.
980: --l_vendor_fob_tbl PO_TBL_VARCHAR30;
981: --l_vendor_freight_carrier_tbl PO_TBL_VARCHAR30;
982: --l_vendor_freight_term_tbl PO_TBL_VARCHAR30;
983: --l_vendor_ship_to_loc_id_tbl PO_TBL_NUMBER;

Line 1939: FROM po_vendors

1935: INSERT INTO po_session_gt(key, num1, num2)
1936: SELECT p_key,
1937: p_index_tbl(i),
1938: vendor_id
1939: FROM po_vendors
1940: WHERE x_vendor_id_tbl(i) IS NULL
1941: AND (p_vendor_name_tbl(i) IS NOT NULL OR p_vendor_num_tbl(i) IS NOT NULL)
1942: AND (vendor_name = p_vendor_name_tbl(i) OR
1943: segment1 = p_vendor_num_tbl(i));

Line 2617: -- The following columns are being obsoleted from PO_VENDORS level

2613:
2614: -- Initialize OUT parameters
2615:
2616: --
2617: -- The following columns are being obsoleted from PO_VENDORS level
2618: --x_fob_tbl := PO_TBL_VARCHAR30();
2619: --x_freight_carrier_tbl := PO_TBL_VARCHAR30();
2620: --x_freight_term_tbl := PO_TBL_VARCHAR30();
2621: --x_ship_to_loc_id_tbl := PO_TBL_NUMBER();

Line 2637: FROM po_vendors

2633: SELECT p_key,
2634: p_index_tbl(i),
2635: invoice_currency_code,
2636: terms_id
2637: FROM po_vendors
2638: WHERE vendor_id = p_vendor_id_tbl(i);
2639:
2640: d_position := 10;
2641: