DBA Data[Home] [Help]

APPS.JAI_AP_TDS_ETDS_PKG dependencies on PO_VENDOR_SITES_ALL

Line 981: from jai_cmn_taxes_all a, ap_invoices_all base_invoices, po_vendor_sites_all povs, \* Added by Avanija for FVU3.6 *\

977: fnd_global.user_id,
978: sysdate,
979: fnd_global.user_id,
980: sysdate
981: from jai_cmn_taxes_all a, ap_invoices_all base_invoices, po_vendor_sites_all povs, \* Added by Avanija for FVU3.6 *\
982: ap_invoice_distributions_all aida, jai_ap_tds_vendor_hdrs jte
983: where jte.vendor_id = base_invoices.vendor_id
984: \* FVU3.6 -start *\
985: and povs.vendor_id = jte.vendor_id

Line 1055: ap_invoice_distributions_all aida, jai_ap_tds_vendor_hdrs jte, po_vendor_sites_all povs

1051: sysdate,
1052: fnd_global.user_id,
1053: sysdate
1054: from ap_invoices_all base_invoices,
1055: ap_invoice_distributions_all aida, jai_ap_tds_vendor_hdrs jte, po_vendor_sites_all povs
1056: where jte.vendor_id = base_invoices.vendor_id
1057: and jte.vendor_site_id = base_invoices.vendor_site_id--Added by Zhhou for bug#15962641 20121205
1058: --Changed by Zhiwei for Bug#15840480 FVU3.6 begin
1059: -----------------------------------------------------

Line 5088: FROM po_vendor_sites_all

5084: -- gives the Deductee code based on Vendor Classification
5085: CURSOR c_deductee_site_dtls(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER) IS
5086: SELECT address_line1 addr1, address_line2 addr2, address_line3 addr3, address_line4 addr4, city,
5087: UPPER(state) state, REPLACE(zip,' ') zip --Removed to_number for Bug 6281440
5088: FROM po_vendor_sites_all
5089: WHERE vendor_id = p_vendor_id
5090: AND vendor_site_id = p_vendor_site_id;
5091:
5092: v_deductee_state_code NUMBER;

Line 5675: v_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;

5671: ln_amt_of_oth number(14);
5672:
5673: -- used variables
5674: --v_vendor_name PO_VENDORS.vendor_name%TYPE;
5675: v_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
5676: v_error_message VARCHAR2(100);
5677: v_conc_request_id NUMBER(15); -- := FND_PROFILE.value('CONC_REQUEST_ID'); File.Sql.35 by Brathod
5678: v_statement_id VARCHAR2(3) ; --:= '0'; File.Sql.35 by Brathod
5679: