DBA Data[Home] [Help]

APPS.AP_APXVDMVD_PKG dependencies on PO_LOOKUP_CODES

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

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

Line 277: po_lookup_codes pc1,

273: x_bank_charge_bearer
274: FROM ap_lookup_codes lc1,
275: ap_lookup_codes lc2,
276: ap_lookup_codes lc3,
277: po_lookup_codes pc1,
278: po_lookup_codes pc2,
279: po_lookup_codes pc3,
280: hr_locations_all hl1,
281: hr_locations_all hl2,

Line 278: po_lookup_codes pc2,

274: FROM ap_lookup_codes lc1,
275: ap_lookup_codes lc2,
276: ap_lookup_codes lc3,
277: po_lookup_codes pc1,
278: po_lookup_codes pc2,
279: po_lookup_codes pc3,
280: hr_locations_all hl1,
281: hr_locations_all hl2,
282: ap_terms_tl tm,

Line 279: po_lookup_codes pc3,

275: ap_lookup_codes lc2,
276: ap_lookup_codes lc3,
277: po_lookup_codes pc1,
278: po_lookup_codes pc2,
279: po_lookup_codes pc3,
280: hr_locations_all hl1,
281: hr_locations_all hl2,
282: ap_terms_tl tm,
283: org_freight_tl ofr,

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

335: WHERE nvl(org_id,-99) = nvl(x_org_id,-99);
336: --
337: IF l_po_setup > 0 THEN
338: --
339: debug_info := 'Select from rcv_parameters, po_lookup_codes, po_system_parameters';
340:
341: SELECT rp.enforce_ship_to_location_code,
342: rp.receiving_routing_id,
343: rp.qty_rcv_tolerance,

Line 372: po_lookup_codes pc1,

368: x_receipt_required_flag,
369: x_inspection_required_flag,
370: x_po_create_dm_flag
371: FROM rcv_parameters rp,
372: po_lookup_codes pc1,
373: po_lookup_codes pc2,
374: po_lookup_codes pc3,
375: po_system_parameters po
376: WHERE rp.organization_id = x_inventory_organization_id

Line 373: po_lookup_codes pc2,

369: x_inspection_required_flag,
370: x_po_create_dm_flag
371: FROM rcv_parameters rp,
372: po_lookup_codes pc1,
373: po_lookup_codes pc2,
374: po_lookup_codes pc3,
375: po_system_parameters po
376: WHERE rp.organization_id = x_inventory_organization_id
377: AND pc1.lookup_type(+) = 'RECEIVING CONTROL LEVEL'

Line 374: po_lookup_codes pc3,

370: x_po_create_dm_flag
371: FROM rcv_parameters rp,
372: po_lookup_codes pc1,
373: po_lookup_codes pc2,
374: po_lookup_codes pc3,
375: po_system_parameters po
376: WHERE rp.organization_id = x_inventory_organization_id
377: AND pc1.lookup_type(+) = 'RECEIVING CONTROL LEVEL'
378: AND pc1.lookup_code(+) = rp.enforce_ship_to_location_code

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

565:
566: --
567: --
568: debug_info
569: := 'Select from ap_lookup_codes, po_lookup_codes, hr_locations, ....';
570: SELECT aps.supplier_numbering_method,
571: aps.supplier_num_type,
572: aps.terms_id, -- terms_id
573: tm.name, -- terms_name

Line 610: po_lookup_codes pc3,

606: -- x_bank_charge_bearer
607: x_fin_match_option --bug6075649
608: FROM ap_lookup_codes lc2,
609: ap_lookup_codes lc3,
610: po_lookup_codes pc3,
611: ap_terms tm,
612: ap_product_setup aps
613: WHERE lc2.lookup_type(+) = 'PAY DATE BASIS'
614: AND lc2.lookup_code(+) = aps.pay_date_basis_lookup_code