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 831: po_vendor_sites pvs

827: rcv_shipment_lines rsl,
828: po_headers ph,
829: po_line_locations pll,
830: po_lines pl,
831: po_vendor_sites pvs
832: WHERE rtxn.transaction_id = p_rcv_txn_id and
833: rtxn.shipment_line_id = rsl.shipment_line_id and
834: rsl.shipment_header_id = rsh.shipment_header_id and
835: rtxn.po_line_location_id = pll.line_location_id and

Line 913: FROM po_vendor_sites pvs

909: second SELECT instead of p_vendor_sit_id */
910:
911: SELECT NVL(pvs.default_pay_site_id,pvs.vendor_site_id)
912: INTO l_default_pay_site_id
913: FROM po_vendor_sites pvs
914: WHERE vendor_site_id = p_vendor_site_id;
915:
916: SELECT
917: nvl(pvs.pay_group_lookup_code, pv.pay_group_lookup_code),

Line 1168: FROM po_vendor_sites

1164:
1165:
1166: SELECT default_pay_site_id
1167: INTO l_alter_pay_site_id
1168: FROM po_vendor_sites
1169: WHERE vendor_site_id = p_vendor_site_id;
1170:
1171: if ( l_alter_pay_site_id is not NULL ) then
1172:

Line 1176: from po_vendor_sites

1172:
1173: Begin
1174: select 'y'
1175: into l_valid_pay_site
1176: from po_vendor_sites
1177: where vendor_site_id = l_alter_pay_site_id
1178: and pay_site_flag = 'Y'
1179: and nvl(inactive_date, sysdate +1) > sysdate;
1180: Exception

Line 1203: FROM po_vendor_sites

1199: Begin
1200:
1201: SELECT 'y'
1202: INTO l_valid_pay_site
1203: FROM po_vendor_sites
1204: WHERE vendor_site_id = p_vendor_site_id
1205: AND pay_site_flag = 'Y'
1206: AND nvl(inactive_date, sysdate +1) > sysdate;
1207: Exception