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_WEB_EXPORT_ER dependencies on AP_SUPPLIERS

Line 27: ap_suppliers aps,

23: hou.name,
24: aeh.default_currency_code
25: FROM
26: ap_expense_report_headers_all aeh,
27: ap_suppliers aps,
28: ap_suppliers apsbp,
29: per_employees_x per,
30: ap_lookup_codes alc,
31: hr_organization_units hou

Line 28: ap_suppliers apsbp,

24: aeh.default_currency_code
25: FROM
26: ap_expense_report_headers_all aeh,
27: ap_suppliers aps,
28: ap_suppliers apsbp,
29: per_employees_x per,
30: ap_lookup_codes alc,
31: hr_organization_units hou
32: where aeh.request_id = l_req_id

Line 56: ap_suppliers aps,

52: hou.name,
53: aeh.default_currency_code
54: FROM
55: ap_expense_report_headers_all aeh,
56: ap_suppliers aps,
57: per_cont_workers_x per,
58: ap_lookup_codes alc,
59: hr_organization_units hou
60: where aeh.request_id = l_req_id

Line 84: FROM ap_invoices_all I, ap_invoices_all P, ap_suppliers V,

80: ap_invoices_utility_pkg.get_amt_applied_per_prepay(I.invoice_id,P.invoice_id),
81: aeh.org_id OU_ID,
82: hou.name,
83: aeh.default_currency_code
84: FROM ap_invoices_all I, ap_invoices_all P, ap_suppliers V,
85: ap_expense_report_headers_all aeh, hr_organization_units hou
86: WHERE aeh.request_id = l_req_id
87: AND aeh.vouchno is not null
88: AND hou.organization_id(+) = aeh.org_id

Line 119: ap_suppliers aps,

115: aeh.default_currency_code
116: FROM
117: ap_expense_report_headers_all aeh,
118: ap_invoices_all ai,
119: ap_suppliers aps,
120: ap_suppliers apsbp,
121: per_employees_x per,
122: ap_lookup_codes alc,
123: hr_organization_units hou

Line 120: ap_suppliers apsbp,

116: FROM
117: ap_expense_report_headers_all aeh,
118: ap_invoices_all ai,
119: ap_suppliers aps,
120: ap_suppliers apsbp,
121: per_employees_x per,
122: ap_lookup_codes alc,
123: hr_organization_units hou
124: where aeh.request_id = l_req_id

Line 153: ap_suppliers aps,

149: aeh.default_currency_code
150: FROM
151: ap_expense_report_headers_all aeh,
152: ap_invoices_all ai,
153: ap_suppliers aps,
154: per_cont_workers_x per,
155: ap_lookup_codes alc,
156: hr_organization_units hou
157: where aeh.request_id = l_req_id

Line 174: l_vendor_name ap_suppliers.vendor_name%TYPE;

170: l_export_message VARCHAR2(100);
171: l_count NUMBER := 0;
172: l_full_name per_employees_x.full_name%TYPE;
173: l_emp_num per_employees_x.employee_num%TYPE;
174: l_vendor_name ap_suppliers.vendor_name%TYPE;
175: l_vendor_num ap_suppliers.segment1%TYPE;
176: l_inv_num ap_expense_report_headers_all.invoice_num%TYPE;
177: l_inv_date ap_expense_report_headers_all.week_end_date%TYPE;
178: l_inv_curr ap_expense_report_headers_all.payment_currency_code%TYPE;

Line 175: l_vendor_num ap_suppliers.segment1%TYPE;

171: l_count NUMBER := 0;
172: l_full_name per_employees_x.full_name%TYPE;
173: l_emp_num per_employees_x.employee_num%TYPE;
174: l_vendor_name ap_suppliers.vendor_name%TYPE;
175: l_vendor_num ap_suppliers.segment1%TYPE;
176: l_inv_num ap_expense_report_headers_all.invoice_num%TYPE;
177: l_inv_date ap_expense_report_headers_all.week_end_date%TYPE;
178: l_inv_curr ap_expense_report_headers_all.payment_currency_code%TYPE;
179: l_inv_amount ap_expense_report_headers_all.total%TYPE;

Line 1604: ap_suppliers V

1600: h.business_group_id,
1601: h.location_id,
1602: 'Y' is_contingent
1603: FROM PER_CONT_WORKERS_CURRENT_X h) emps,
1604: ap_suppliers V
1605: --ap_lookup_codes l1
1606: WHERE vouchno = 0
1607: AND XH.employee_id = V.employee_id(+)
1608: AND XH.employee_id = emps.employee_id(+)

Line 2510: ap_suppliers PV

2506: decode(sign(earliest_settlement_date - sysdate),1,0,1),
2507: 0)), 0)
2508: INTO l_available_prepays
2509: FROM ap_invoices I,
2510: ap_suppliers PV
2511: WHERE exists (SELECT 'x'
2512: FROM ap_invoice_distributions aid
2513: WHERE aid.invoice_id = i.invoice_id
2514: AND aid.line_type_lookup_code IN ('ITEM','TAX')

Line 2539: ap_suppliers PV

2535: decode(sign(earliest_settlement_date - sysdate),1,0,1),
2536: 0)), 0)
2537: INTO l_available_prepays
2538: FROM ap_invoices I,
2539: ap_suppliers PV
2540: WHERE exists (SELECT 'x'
2541: FROM ap_invoice_distributions aid
2542: WHERE aid.invoice_id = i.invoice_id
2543: AND aid.line_type_lookup_code IN ('ITEM','TAX')

Line 3837: FROM ap_suppliers

3833: nvl(pay_date_basis_lookup_code, ''),
3834: vendor_name,
3835: segment1,
3836: party_id
3837: FROM ap_suppliers
3838: WHERE vendor_id = l_vendor_id;
3839:
3840: CURSOR c_vendor_site_known(l_vendor_site_id IN NUMBER) IS
3841: SELECT nvl(pay_group_lookup_code, ''),

Line 3868: l_terms_date_basis ap_suppliers.terms_date_basis%TYPE;

3864: l_vendor_site_id NUMBER;
3865: l_party_id NUMBER;
3866: l_party_site_id NUMBER;
3867: l_location_id NUMBER;
3868: l_terms_date_basis ap_suppliers.terms_date_basis%TYPE;
3869: l_terms_id ap_suppliers.terms_id%TYPE;
3870: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
3871: l_payment_priority ap_suppliers.payment_priority%TYPE;
3872: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;

Line 3869: l_terms_id ap_suppliers.terms_id%TYPE;

3865: l_party_id NUMBER;
3866: l_party_site_id NUMBER;
3867: l_location_id NUMBER;
3868: l_terms_date_basis ap_suppliers.terms_date_basis%TYPE;
3869: l_terms_id ap_suppliers.terms_id%TYPE;
3870: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
3871: l_payment_priority ap_suppliers.payment_priority%TYPE;
3872: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
3873: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;

Line 3870: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;

3866: l_party_site_id NUMBER;
3867: l_location_id NUMBER;
3868: l_terms_date_basis ap_suppliers.terms_date_basis%TYPE;
3869: l_terms_id ap_suppliers.terms_id%TYPE;
3870: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
3871: l_payment_priority ap_suppliers.payment_priority%TYPE;
3872: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
3873: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
3874: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;

Line 3871: l_payment_priority ap_suppliers.payment_priority%TYPE;

3867: l_location_id NUMBER;
3868: l_terms_date_basis ap_suppliers.terms_date_basis%TYPE;
3869: l_terms_id ap_suppliers.terms_id%TYPE;
3870: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
3871: l_payment_priority ap_suppliers.payment_priority%TYPE;
3872: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
3873: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
3874: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
3875: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;

Line 3872: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;

3868: l_terms_date_basis ap_suppliers.terms_date_basis%TYPE;
3869: l_terms_id ap_suppliers.terms_id%TYPE;
3870: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
3871: l_payment_priority ap_suppliers.payment_priority%TYPE;
3872: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
3873: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
3874: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
3875: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;
3876: l_vendor_name ap_suppliers.vendor_name%TYPE;

Line 3873: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;

3869: l_terms_id ap_suppliers.terms_id%TYPE;
3870: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
3871: l_payment_priority ap_suppliers.payment_priority%TYPE;
3872: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
3873: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
3874: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
3875: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;
3876: l_vendor_name ap_suppliers.vendor_name%TYPE;
3877: l_vendor_num ap_suppliers.segment1%TYPE;

Line 3874: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;

3870: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
3871: l_payment_priority ap_suppliers.payment_priority%TYPE;
3872: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
3873: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
3874: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
3875: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;
3876: l_vendor_name ap_suppliers.vendor_name%TYPE;
3877: l_vendor_num ap_suppliers.segment1%TYPE;
3878:

Line 3875: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;

3871: l_payment_priority ap_suppliers.payment_priority%TYPE;
3872: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
3873: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
3874: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
3875: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;
3876: l_vendor_name ap_suppliers.vendor_name%TYPE;
3877: l_vendor_num ap_suppliers.segment1%TYPE;
3878:
3879: l_create_vendor BOOLEAN := FALSE;

Line 3876: l_vendor_name ap_suppliers.vendor_name%TYPE;

3872: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
3873: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
3874: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
3875: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;
3876: l_vendor_name ap_suppliers.vendor_name%TYPE;
3877: l_vendor_num ap_suppliers.segment1%TYPE;
3878:
3879: l_create_vendor BOOLEAN := FALSE;
3880:

Line 3877: l_vendor_num ap_suppliers.segment1%TYPE;

3873: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
3874: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
3875: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;
3876: l_vendor_name ap_suppliers.vendor_name%TYPE;
3877: l_vendor_num ap_suppliers.segment1%TYPE;
3878:
3879: l_create_vendor BOOLEAN := FALSE;
3880:
3881: l_site_pay_group ap_supplier_sites.pay_group_lookup_code%TYPE;

Line 3926: FROM ap_suppliers

3922: party_id
3923: INTO l_vendor_id,
3924: l_duplicate_vendor,
3925: l_party_id
3926: FROM ap_suppliers
3927: WHERE employee_id = p_vendor_rec.employee_id;
3928: EXCEPTION
3929: WHEN NO_DATA_FOUND THEN
3930: fnd_file.put_line(fnd_file.log, 'Employee Id '||p_vendor_rec.employee_id||' is not found');

Line 4445: FUNCTION CreatePayee(p_party_id IN ap_suppliers.party_id%TYPE,

4441:
4442: END GetVendorInfo;
4443:
4444: ------------------------------------------------------------------------
4445: FUNCTION CreatePayee(p_party_id IN ap_suppliers.party_id%TYPE,
4446: p_org_id IN ap_expense_report_headers.org_id%TYPE,
4447: p_reject_code OUT NOCOPY VARCHAR2)
4448: RETURN BOOLEAN IS
4449: ------------------------------------------------------------------------