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 488: ap_suppliers V

484: h.first_name,
485: h.business_group_id,
486: h.location_id
487: FROM PER_CONT_WORKERS_CURRENT_X h) emps,
488: ap_suppliers V
489: --ap_lookup_codes l1
490: WHERE vouchno = 0
491: AND XH.employee_id = V.employee_id(+)
492: AND XH.employee_id = emps.employee_id(+)

Line 1454: ap_suppliers PV

1450: decode(sign(earliest_settlement_date - sysdate),1,0,1),
1451: 0)), 0)
1452: INTO l_available_prepays
1453: FROM ap_invoices I,
1454: ap_suppliers PV
1455: WHERE exists (SELECT 'x'
1456: FROM ap_invoice_distributions aid
1457: WHERE aid.invoice_id = i.invoice_id
1458: AND aid.line_type_lookup_code IN ('ITEM','TAX')

Line 1483: ap_suppliers PV

1479: decode(sign(earliest_settlement_date - sysdate),1,0,1),
1480: 0)), 0)
1481: INTO l_available_prepays
1482: FROM ap_invoices I,
1483: ap_suppliers PV
1484: WHERE exists (SELECT 'x'
1485: FROM ap_invoice_distributions aid
1486: WHERE aid.invoice_id = i.invoice_id
1487: AND aid.line_type_lookup_code IN ('ITEM','TAX')

Line 2728: FROM ap_suppliers

2724: nvl(pay_date_basis_lookup_code, ''),
2725: vendor_name,
2726: segment1,
2727: party_id
2728: FROM ap_suppliers
2729: WHERE vendor_id = l_vendor_id;
2730:
2731: CURSOR c_vendor_site_known(l_vendor_site_id IN NUMBER) IS
2732: SELECT nvl(pay_group_lookup_code, ''),

Line 2759: l_terms_date_basis ap_suppliers.terms_date_basis%TYPE;

2755: l_vendor_site_id NUMBER;
2756: l_party_id NUMBER;
2757: l_party_site_id NUMBER;
2758: l_location_id NUMBER;
2759: l_terms_date_basis ap_suppliers.terms_date_basis%TYPE;
2760: l_terms_id ap_suppliers.terms_id%TYPE;
2761: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
2762: l_payment_priority ap_suppliers.payment_priority%TYPE;
2763: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;

Line 2760: l_terms_id ap_suppliers.terms_id%TYPE;

2756: l_party_id NUMBER;
2757: l_party_site_id NUMBER;
2758: l_location_id NUMBER;
2759: l_terms_date_basis ap_suppliers.terms_date_basis%TYPE;
2760: l_terms_id ap_suppliers.terms_id%TYPE;
2761: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
2762: l_payment_priority ap_suppliers.payment_priority%TYPE;
2763: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
2764: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;

Line 2761: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;

2757: l_party_site_id NUMBER;
2758: l_location_id NUMBER;
2759: l_terms_date_basis ap_suppliers.terms_date_basis%TYPE;
2760: l_terms_id ap_suppliers.terms_id%TYPE;
2761: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
2762: l_payment_priority ap_suppliers.payment_priority%TYPE;
2763: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
2764: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
2765: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;

Line 2762: l_payment_priority ap_suppliers.payment_priority%TYPE;

2758: l_location_id NUMBER;
2759: l_terms_date_basis ap_suppliers.terms_date_basis%TYPE;
2760: l_terms_id ap_suppliers.terms_id%TYPE;
2761: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
2762: l_payment_priority ap_suppliers.payment_priority%TYPE;
2763: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
2764: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
2765: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
2766: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;

Line 2763: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;

2759: l_terms_date_basis ap_suppliers.terms_date_basis%TYPE;
2760: l_terms_id ap_suppliers.terms_id%TYPE;
2761: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
2762: l_payment_priority ap_suppliers.payment_priority%TYPE;
2763: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
2764: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
2765: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
2766: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;
2767: l_vendor_name ap_suppliers.vendor_name%TYPE;

Line 2764: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;

2760: l_terms_id ap_suppliers.terms_id%TYPE;
2761: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
2762: l_payment_priority ap_suppliers.payment_priority%TYPE;
2763: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
2764: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
2765: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
2766: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;
2767: l_vendor_name ap_suppliers.vendor_name%TYPE;
2768: l_vendor_num ap_suppliers.segment1%TYPE;

Line 2765: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;

2761: l_pay_group ap_suppliers.pay_group_lookup_code%TYPE;
2762: l_payment_priority ap_suppliers.payment_priority%TYPE;
2763: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
2764: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
2765: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
2766: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;
2767: l_vendor_name ap_suppliers.vendor_name%TYPE;
2768: l_vendor_num ap_suppliers.segment1%TYPE;
2769:

Line 2766: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;

2762: l_payment_priority ap_suppliers.payment_priority%TYPE;
2763: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
2764: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
2765: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
2766: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;
2767: l_vendor_name ap_suppliers.vendor_name%TYPE;
2768: l_vendor_num ap_suppliers.segment1%TYPE;
2769:
2770: l_create_vendor BOOLEAN := FALSE;

Line 2767: l_vendor_name ap_suppliers.vendor_name%TYPE;

2763: l_liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE;
2764: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
2765: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
2766: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;
2767: l_vendor_name ap_suppliers.vendor_name%TYPE;
2768: l_vendor_num ap_suppliers.segment1%TYPE;
2769:
2770: l_create_vendor BOOLEAN := FALSE;
2771:

Line 2768: l_vendor_num ap_suppliers.segment1%TYPE;

2764: l_prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE;
2765: l_always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE;
2766: l_pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE;
2767: l_vendor_name ap_suppliers.vendor_name%TYPE;
2768: l_vendor_num ap_suppliers.segment1%TYPE;
2769:
2770: l_create_vendor BOOLEAN := FALSE;
2771:
2772: l_site_pay_group ap_supplier_sites.pay_group_lookup_code%TYPE;

Line 2817: FROM ap_suppliers

2813: party_id
2814: INTO l_vendor_id,
2815: l_duplicate_vendor,
2816: l_party_id
2817: FROM ap_suppliers
2818: WHERE employee_id = p_vendor_rec.employee_id;
2819: EXCEPTION
2820: WHEN NO_DATA_FOUND THEN
2821: fnd_file.put_line(fnd_file.log, 'Employee Id '||p_vendor_rec.employee_id||' is not found');

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

3318:
3319: END GetVendorInfo;
3320:
3321: ------------------------------------------------------------------------
3322: FUNCTION CreatePayee(p_party_id IN ap_suppliers.party_id%TYPE,
3323: p_org_id IN ap_expense_report_headers.org_id%TYPE,
3324: p_reject_code OUT NOCOPY VARCHAR2)
3325: RETURN BOOLEAN IS
3326: ------------------------------------------------------------------------