DBA Data[Home] [Help]

APPS.AP_TAX_ENGINE_PKG dependencies on PO_VENDOR_SITES_ALL

Line 37: ship_from_country po_vendor_sites_all.country%TYPE,

33: ship_from_supplier_id po_headers_all.vendor_id%TYPE,
34: ship_from_supplier_number po_vendors.segment1%TYPE,
35: ship_from_supplier_name po_vendors.vendor_name%TYPE,
36: ship_from_site_use_id po_headers_all.vendor_site_id%TYPE,
37: ship_from_country po_vendor_sites_all.country%TYPE,
38: ship_from_state po_vendor_sites_all.state%TYPE,
39: ship_from_county po_vendor_sites_all.county%TYPE,
40: -- Modified the definition of ship_to_city for bug 3480512 ..
41: ship_from_city po_vendor_sites_all.city%TYPE,

Line 38: ship_from_state po_vendor_sites_all.state%TYPE,

34: ship_from_supplier_number po_vendors.segment1%TYPE,
35: ship_from_supplier_name po_vendors.vendor_name%TYPE,
36: ship_from_site_use_id po_headers_all.vendor_site_id%TYPE,
37: ship_from_country po_vendor_sites_all.country%TYPE,
38: ship_from_state po_vendor_sites_all.state%TYPE,
39: ship_from_county po_vendor_sites_all.county%TYPE,
40: -- Modified the definition of ship_to_city for bug 3480512 ..
41: ship_from_city po_vendor_sites_all.city%TYPE,
42: ship_from_province varchar2(150),

Line 39: ship_from_county po_vendor_sites_all.county%TYPE,

35: ship_from_supplier_name po_vendors.vendor_name%TYPE,
36: ship_from_site_use_id po_headers_all.vendor_site_id%TYPE,
37: ship_from_country po_vendor_sites_all.country%TYPE,
38: ship_from_state po_vendor_sites_all.state%TYPE,
39: ship_from_county po_vendor_sites_all.county%TYPE,
40: -- Modified the definition of ship_to_city for bug 3480512 ..
41: ship_from_city po_vendor_sites_all.city%TYPE,
42: ship_from_province varchar2(150),
43: ship_from_postal_code po_vendor_sites_all.zip%TYPE,

Line 41: ship_from_city po_vendor_sites_all.city%TYPE,

37: ship_from_country po_vendor_sites_all.country%TYPE,
38: ship_from_state po_vendor_sites_all.state%TYPE,
39: ship_from_county po_vendor_sites_all.county%TYPE,
40: -- Modified the definition of ship_to_city for bug 3480512 ..
41: ship_from_city po_vendor_sites_all.city%TYPE,
42: ship_from_province varchar2(150),
43: ship_from_postal_code po_vendor_sites_all.zip%TYPE,
44: ship_from_in_city_limits_flag varchar2(1),
45: ship_from_geocode varchar2(1),

Line 43: ship_from_postal_code po_vendor_sites_all.zip%TYPE,

39: ship_from_county po_vendor_sites_all.county%TYPE,
40: -- Modified the definition of ship_to_city for bug 3480512 ..
41: ship_from_city po_vendor_sites_all.city%TYPE,
42: ship_from_province varchar2(150),
43: ship_from_postal_code po_vendor_sites_all.zip%TYPE,
44: ship_from_in_city_limits_flag varchar2(1),
45: ship_from_geocode varchar2(1),
46: line_number po_lines_all.line_num%TYPE,
47: trx_line_type po_line_types_tl.line_type%TYPE,

Line 104: --tax_rounding_rule po_vendor_sites_all.ap_tax_rounding_rule%TYPE,

100: company_code varchar2(1),
101: division_code varchar2(1),
102: audit_flag varchar2(1),
103: tax_header_level_flag varchar2(1),
104: --tax_rounding_rule po_vendor_sites_all.ap_tax_rounding_rule%TYPE,
105: tax_rounding_rule ap_supplier_sites_all.ap_tax_rounding_rule%TYPE,
106: tax_type ap_tax_codes_all.tax_type%TYPE,
107: tax_description ap_tax_codes_all.description%TYPE,
108: allow_tax_code_override_flag gl_tax_option_accounts.allow_tax_code_override_flag%TYPE,

Line 211: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE

207: /* Function called by view JG_AP_TAX_LINES_SUMMARY_V to provide multiple tax inclusive calculation solution. */
208: FUNCTION sum_tax_group_rate
209: (p_tax_group_id IN ar_tax_group_codes_all.tax_group_id%TYPE,
210: p_trx_date IN ap_invoices_all.invoice_date%TYPE,
211: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE
212: )
213: return NUMBER;
214:
215: /* Function called by view AP_TAX_LINES_SUMMARY_V to provide inclusive tax calculation with offset solution. */