APPS.AP_WEB_EXPORT_ER dependencies on AP_SUPPLIER_SITES

Line 2709: FROM ap_supplier_sites s, fnd_lookup_values l

2705: nvl(accts_pay_code_combination_id, -1),
2706: nvl(terms_id, -1),
2707: allow_awt_flag,
2708: party_site_id
2709: FROM ap_supplier_sites s, fnd_lookup_values l
2710: WHERE s.vendor_site_code || '' = SUBSTRB(UPPER(l.meaning), 1, 15)
2711: AND s.vendor_id = l_vendor_id
2712: AND l.lookup_type = 'HOME_OFFICE'
2713: AND l.lookup_code = home_or_office

Line 2738: FROM ap_supplier_sites s

2734: nvl(accts_pay_code_combination_id, -1),
2735: nvl(terms_id, -1),
2736: allow_awt_flag,
2737: party_site_id
2738: FROM ap_supplier_sites s
2739: WHERE vendor_site_id = l_vendor_site_id;
2740:
2741: CURSOR c_party_id(l_employee_id IN NUMBER) IS
2742: SELECT party_id

Line 2772: l_site_pay_group ap_supplier_sites.pay_group_lookup_code%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;
2773: l_site_terms_date_basis ap_supplier_sites.terms_date_basis%TYPE;
2774: l_site_liab_acc ap_supplier_sites.accts_pay_code_combination_id%TYPE;
2775: l_site_terms_id ap_supplier_sites.terms_id%TYPE;
2776: l_site_allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE;

Line 2773: l_site_terms_date_basis ap_supplier_sites.terms_date_basis%TYPE;

2769:
2770: l_create_vendor BOOLEAN := FALSE;
2771:
2772: l_site_pay_group ap_supplier_sites.pay_group_lookup_code%TYPE;
2773: l_site_terms_date_basis ap_supplier_sites.terms_date_basis%TYPE;
2774: l_site_liab_acc ap_supplier_sites.accts_pay_code_combination_id%TYPE;
2775: l_site_terms_id ap_supplier_sites.terms_id%TYPE;
2776: l_site_allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE;
2777: l_debug_info VARCHAR2(2000);

Line 2774: l_site_liab_acc ap_supplier_sites.accts_pay_code_combination_id%TYPE;

2770: l_create_vendor BOOLEAN := FALSE;
2771:
2772: l_site_pay_group ap_supplier_sites.pay_group_lookup_code%TYPE;
2773: l_site_terms_date_basis ap_supplier_sites.terms_date_basis%TYPE;
2774: l_site_liab_acc ap_supplier_sites.accts_pay_code_combination_id%TYPE;
2775: l_site_terms_id ap_supplier_sites.terms_id%TYPE;
2776: l_site_allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE;
2777: l_debug_info VARCHAR2(2000);
2778: l_duplicate_vendor VARCHAR2(2);

Line 2775: l_site_terms_id ap_supplier_sites.terms_id%TYPE;

2771:
2772: l_site_pay_group ap_supplier_sites.pay_group_lookup_code%TYPE;
2773: l_site_terms_date_basis ap_supplier_sites.terms_date_basis%TYPE;
2774: l_site_liab_acc ap_supplier_sites.accts_pay_code_combination_id%TYPE;
2775: l_site_terms_id ap_supplier_sites.terms_id%TYPE;
2776: l_site_allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE;
2777: l_debug_info VARCHAR2(2000);
2778: l_duplicate_vendor VARCHAR2(2);
2779: l_val_return_status VARCHAR2(50);

Line 2776: l_site_allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE;

2772: l_site_pay_group ap_supplier_sites.pay_group_lookup_code%TYPE;
2773: l_site_terms_date_basis ap_supplier_sites.terms_date_basis%TYPE;
2774: l_site_liab_acc ap_supplier_sites.accts_pay_code_combination_id%TYPE;
2775: l_site_terms_id ap_supplier_sites.terms_id%TYPE;
2776: l_site_allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE;
2777: l_debug_info VARCHAR2(2000);
2778: l_duplicate_vendor VARCHAR2(2);
2779: l_val_return_status VARCHAR2(50);
2780: l_val_msg_count NUMBER;