DBA Data[Home] [Help]

APPS.PO_PDOI_HEADER_PROCESS_PVT dependencies on PO_VENDORS

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

1444:
1445: -- information defaulted from vendor
1446:
1447: --
1448: -- The following columns are being obsoleted from PO_VENDORS level.
1449: --l_vendor_fob_tbl PO_TBL_VARCHAR30;
1450: --l_vendor_freight_carrier_tbl PO_TBL_VARCHAR30;
1451: --l_vendor_freight_term_tbl PO_TBL_VARCHAR30;
1452: --l_vendor_ship_to_loc_id_tbl PO_TBL_NUMBER;

Line 2448: FROM po_vendors

2444: INSERT INTO po_session_gt(key, num1, num2)
2445: SELECT p_key,
2446: p_index_tbl(i),
2447: vendor_id
2448: FROM po_vendors
2449: WHERE x_vendor_id_tbl(i) IS NULL
2450: AND (p_vendor_name_tbl(i) IS NOT NULL OR p_vendor_num_tbl(i) IS NOT NULL)
2451: AND (vendor_name = p_vendor_name_tbl(i) OR
2452: segment1 = p_vendor_num_tbl(i));

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

3122:
3123: -- Initialize OUT parameters
3124:
3125: --
3126: -- The following columns are being obsoleted from PO_VENDORS level
3127: --x_fob_tbl := PO_TBL_VARCHAR30();
3128: --x_freight_carrier_tbl := PO_TBL_VARCHAR30();
3129: --x_freight_term_tbl := PO_TBL_VARCHAR30();
3130: --x_ship_to_loc_id_tbl := PO_TBL_NUMBER();

Line 3146: FROM po_vendors

3142: SELECT p_key,
3143: p_index_tbl(i),
3144: invoice_currency_code,
3145: terms_id
3146: FROM po_vendors
3147: WHERE vendor_id = p_vendor_id_tbl(i);
3148:
3149: d_position := 10;
3150: