eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_AUTO_DM_CREATION_PKG dependencies on PO_VENDOR_SITES

Line 195: l_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;

191: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
192: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
193: l_batch_control_flag ap_system_parameters.batch_control_flag%TYPE;
194: l_gl_date_from_rect_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
195: l_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
196: l_accts_pay_ccid po_vendor_sites.accts_pay_code_combination_id%TYPE;
197:
198: --4552701, added the fields below
199: l_payment_method_code varchar2(30);

Line 196: l_accts_pay_ccid po_vendor_sites.accts_pay_code_combination_id%TYPE;

192: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
193: l_batch_control_flag ap_system_parameters.batch_control_flag%TYPE;
194: l_gl_date_from_rect_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
195: l_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
196: l_accts_pay_ccid po_vendor_sites.accts_pay_code_combination_id%TYPE;
197:
198: --4552701, added the fields below
199: l_payment_method_code varchar2(30);
200: l_exclusive_payment_flag varchar2(1);

Line 224: l_payment_priority po_vendor_sites.payment_priority%TYPE;

220:
221: --4874927
222: l_payment_reason_comments varchar2(240);
223:
224: l_payment_priority po_vendor_sites.payment_priority%TYPE;
225: l_terms_date_basis po_vendor_sites.terms_date_basis%TYPE;
226: l_vendor_income_tax_region po_vendor_sites.state%TYPE;
227: l_type_1099 po_vendors.type_1099%TYPE;
228: l_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;

Line 225: l_terms_date_basis po_vendor_sites.terms_date_basis%TYPE;

221: --4874927
222: l_payment_reason_comments varchar2(240);
223:
224: l_payment_priority po_vendor_sites.payment_priority%TYPE;
225: l_terms_date_basis po_vendor_sites.terms_date_basis%TYPE;
226: l_vendor_income_tax_region po_vendor_sites.state%TYPE;
227: l_type_1099 po_vendors.type_1099%TYPE;
228: l_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;
229: l_awt_group_id po_vendor_sites.awt_group_id%TYPE;

Line 226: l_vendor_income_tax_region po_vendor_sites.state%TYPE;

222: l_payment_reason_comments varchar2(240);
223:
224: l_payment_priority po_vendor_sites.payment_priority%TYPE;
225: l_terms_date_basis po_vendor_sites.terms_date_basis%TYPE;
226: l_vendor_income_tax_region po_vendor_sites.state%TYPE;
227: l_type_1099 po_vendors.type_1099%TYPE;
228: l_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;
229: l_awt_group_id po_vendor_sites.awt_group_id%TYPE;
230: l_excl_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;

Line 228: l_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;

224: l_payment_priority po_vendor_sites.payment_priority%TYPE;
225: l_terms_date_basis po_vendor_sites.terms_date_basis%TYPE;
226: l_vendor_income_tax_region po_vendor_sites.state%TYPE;
227: l_type_1099 po_vendors.type_1099%TYPE;
228: l_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;
229: l_awt_group_id po_vendor_sites.awt_group_id%TYPE;
230: l_excl_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;
231: l_payment_currency po_vendor_sites.payment_currency_code%TYPE;
232:

Line 229: l_awt_group_id po_vendor_sites.awt_group_id%TYPE;

225: l_terms_date_basis po_vendor_sites.terms_date_basis%TYPE;
226: l_vendor_income_tax_region po_vendor_sites.state%TYPE;
227: l_type_1099 po_vendors.type_1099%TYPE;
228: l_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;
229: l_awt_group_id po_vendor_sites.awt_group_id%TYPE;
230: l_excl_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;
231: l_payment_currency po_vendor_sites.payment_currency_code%TYPE;
232:
233: l_inv_payment_curr po_vendor_sites.payment_currency_code%TYPE;

Line 230: l_excl_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;

226: l_vendor_income_tax_region po_vendor_sites.state%TYPE;
227: l_type_1099 po_vendors.type_1099%TYPE;
228: l_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;
229: l_awt_group_id po_vendor_sites.awt_group_id%TYPE;
230: l_excl_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;
231: l_payment_currency po_vendor_sites.payment_currency_code%TYPE;
232:
233: l_inv_payment_curr po_vendor_sites.payment_currency_code%TYPE;
234: l_batch_id ap_batches.batch_id%TYPE;

Line 231: l_payment_currency po_vendor_sites.payment_currency_code%TYPE;

227: l_type_1099 po_vendors.type_1099%TYPE;
228: l_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;
229: l_awt_group_id po_vendor_sites.awt_group_id%TYPE;
230: l_excl_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;
231: l_payment_currency po_vendor_sites.payment_currency_code%TYPE;
232:
233: l_inv_payment_curr po_vendor_sites.payment_currency_code%TYPE;
234: l_batch_id ap_batches.batch_id%TYPE;
235: l_rts_txn_date rcv_transactions.transaction_date%TYPE;

Line 233: l_inv_payment_curr po_vendor_sites.payment_currency_code%TYPE;

229: l_awt_group_id po_vendor_sites.awt_group_id%TYPE;
230: l_excl_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;
231: l_payment_currency po_vendor_sites.payment_currency_code%TYPE;
232:
233: l_inv_payment_curr po_vendor_sites.payment_currency_code%TYPE;
234: l_batch_id ap_batches.batch_id%TYPE;
235: l_rts_txn_date rcv_transactions.transaction_date%TYPE;
236: l_rcv_quantity_billed rcv_transactions.quantity_billed%TYPE;
237: l_invoice_id ap_invoices.invoice_id%TYPE;

Line 405: FROM po_vendor_sites

401: END IF;
402:
403: SELECT default_pay_site_id
404: INTO l_default_pay_site_id
405: FROM po_vendor_sites
406: WHERE vendor_site_id = l_vendor_site_id;
407:
408: if ( l_default_pay_site_id is not NULL ) then
409:

Line 413: from po_vendor_sites

409:
410: Begin
411: select 'Y'
412: into l_valid_pay_site_flag
413: from po_vendor_sites
414: where vendor_site_id = l_default_pay_site_id
415: and pay_site_flag = 'Y'
416: and nvl(inactive_date, sysdate +1) > sysdate;
417: Exception

Line 438: FROM po_vendor_sites

434: Begin
435:
436: SELECT 'Y'
437: INTO l_valid_pay_site_flag
438: FROM po_vendor_sites
439: WHERE vendor_site_id = l_vendor_site_id
440: AND pay_site_flag = 'Y'
441: AND nvl(inactive_date, sysdate +1) > sysdate;
442: Exception

Line 902: po_vendor_sites pvs

898: rcv_shipment_lines rsl,
899: po_headers ph,
900: po_line_locations pll,
901: po_lines pl,
902: po_vendor_sites pvs
903: WHERE rtxn.transaction_id = p_rcv_txn_id and
904: rtxn.shipment_line_id = rsl.shipment_line_id and
905: rsl.shipment_header_id = rsh.shipment_header_id and
906: rtxn.po_line_location_id = pll.line_location_id and

Line 985: FROM po_vendor_sites pvs

981:
982: --Commented below stmt for bug#9267199
983: /* SELECT NVL(pvs.default_pay_site_id,pvs.vendor_site_id)
984: INTO l_default_pay_site_id
985: FROM po_vendor_sites pvs
986: WHERE vendor_site_id = p_vendor_site_id; */
987:
988: SELECT
989: nvl(pvs.pay_group_lookup_code, pv.pay_group_lookup_code),

Line 1241: FROM po_vendor_sites

1237:
1238:
1239: SELECT default_pay_site_id
1240: INTO l_alter_pay_site_id
1241: FROM po_vendor_sites
1242: WHERE vendor_site_id = p_vendor_site_id;
1243:
1244: if ( l_alter_pay_site_id is not NULL ) then
1245:

Line 1249: from po_vendor_sites

1245:
1246: Begin
1247: select 'y'
1248: into l_valid_pay_site
1249: from po_vendor_sites
1250: where vendor_site_id = l_alter_pay_site_id
1251: and pay_site_flag = 'Y'
1252: and nvl(inactive_date, sysdate +1) > sysdate;
1253: Exception

Line 1276: FROM po_vendor_sites

1272: Begin
1273:
1274: SELECT 'y'
1275: INTO l_valid_pay_site
1276: FROM po_vendor_sites
1277: WHERE vendor_site_id = p_vendor_site_id
1278: AND pay_site_flag = 'Y'
1279: AND nvl(inactive_date, sysdate +1) > sysdate;
1280: Exception