APPS.AP_APXVDMVD_PKG dependencies on PO_LOOKUP_CODES

Line 131: debug_info := 'Select from ap_lookup_codes, po_lookup_codes, hr_locations, ....';

127: dummy := fnd_installation.get_app_info('PO',l_po_status,l_industry,l_oracle_schema);
128: x_PO_inst_flag := l_po_status;
129: --
130: --
131: debug_info := 'Select from ap_lookup_codes, po_lookup_codes, hr_locations, ....';
132: --Bug :2809214 MOAC - Supplier Attribute Change Project
133: --Changed the source table from financial_options and system_options to
134: --ap_product_setup for some of columns. For list of columns please refer to bug.
135:

Line 281: po_lookup_codes pc1,

277: x_bank_charge_bearer
278: FROM ap_lookup_codes lc1,
279: ap_lookup_codes lc2,
280: ap_lookup_codes lc3,
281: po_lookup_codes pc1,
282: po_lookup_codes pc2,
283: po_lookup_codes pc3,
284: hr_locations_all hl1,
285: hr_locations_all hl2,

Line 282: po_lookup_codes pc2,

278: FROM ap_lookup_codes lc1,
279: ap_lookup_codes lc2,
280: ap_lookup_codes lc3,
281: po_lookup_codes pc1,
282: po_lookup_codes pc2,
283: po_lookup_codes pc3,
284: hr_locations_all hl1,
285: hr_locations_all hl2,
286: ap_terms_tl tm,

Line 283: po_lookup_codes pc3,

279: ap_lookup_codes lc2,
280: ap_lookup_codes lc3,
281: po_lookup_codes pc1,
282: po_lookup_codes pc2,
283: po_lookup_codes pc3,
284: hr_locations_all hl1,
285: hr_locations_all hl2,
286: ap_terms_tl tm,
287: org_freight_tl ofr,

Line 360: debug_info := 'Select from rcv_parameters, po_lookup_codes, po_system_parameters';

356: WHERE nvl(org_id,-99) = nvl(x_org_id,-99);
357: --
358: IF l_po_setup > 0 THEN
359: --
360: debug_info := 'Select from rcv_parameters, po_lookup_codes, po_system_parameters';
361:
362: SELECT rp.enforce_ship_to_location_code,
363: rp.receiving_routing_id,
364: rp.qty_rcv_tolerance,

Line 393: po_lookup_codes pc1,

389: x_receipt_required_flag,
390: x_inspection_required_flag,
391: x_po_create_dm_flag
392: FROM rcv_parameters rp,
393: po_lookup_codes pc1,
394: po_lookup_codes pc2,
395: po_lookup_codes pc3,
396: po_system_parameters po
397: WHERE rp.organization_id = x_inventory_organization_id

Line 394: po_lookup_codes pc2,

390: x_inspection_required_flag,
391: x_po_create_dm_flag
392: FROM rcv_parameters rp,
393: po_lookup_codes pc1,
394: po_lookup_codes pc2,
395: po_lookup_codes pc3,
396: po_system_parameters po
397: WHERE rp.organization_id = x_inventory_organization_id
398: AND pc1.lookup_type(+) = 'RECEIVING CONTROL LEVEL'

Line 395: po_lookup_codes pc3,

391: x_po_create_dm_flag
392: FROM rcv_parameters rp,
393: po_lookup_codes pc1,
394: po_lookup_codes pc2,
395: po_lookup_codes pc3,
396: po_system_parameters po
397: WHERE rp.organization_id = x_inventory_organization_id
398: AND pc1.lookup_type(+) = 'RECEIVING CONTROL LEVEL'
399: AND pc1.lookup_code(+) = rp.enforce_ship_to_location_code

Line 590: := 'Select from ap_lookup_codes, po_lookup_codes, hr_locations, ....';

586:
587: --
588: --
589: debug_info
590: := 'Select from ap_lookup_codes, po_lookup_codes, hr_locations, ....';
591: SELECT aps.supplier_numbering_method,
592: aps.supplier_num_type,
593: aps.terms_id, -- terms_id
594: tm.name, -- terms_name

Line 631: po_lookup_codes pc3,

627: -- x_bank_charge_bearer
628: x_fin_match_option --bug6075649
629: FROM ap_lookup_codes lc2,
630: ap_lookup_codes lc3,
631: po_lookup_codes pc3,
632: ap_terms tm,
633: ap_product_setup aps
634: WHERE lc2.lookup_type(+) = 'PAY DATE BASIS'
635: AND lc2.lookup_code(+) = aps.pay_date_basis_lookup_code