65: SUBTYPE signingLimits_costCenter IS AP_WEB_SIGNING_LIMITS.cost_center%TYPE;
66: SUBTYPE signingLimits_orgID IS AP_WEB_SIGNING_LIMITS.org_id%TYPE;
67: ---------------------------------------------------------------------------------------------------
68:
69: /*AP Invoices */
70: ---------------------------------------------------------------------------------------------------
71: SUBTYPE invoices_invCurrCode IS AP_INVOICES.invoice_currency_code%TYPE;
72: ---------------------------------------------------------------------------------------------------
73:
67: ---------------------------------------------------------------------------------------------------
68:
69: /*AP Invoices */
70: ---------------------------------------------------------------------------------------------------
71: SUBTYPE invoices_invCurrCode IS AP_INVOICES.invoice_currency_code%TYPE;
72: ---------------------------------------------------------------------------------------------------
73:
74: /*AP Invoices Interface */
75: ---------------------------------------------------------------------------------------------------
70: ---------------------------------------------------------------------------------------------------
71: SUBTYPE invoices_invCurrCode IS AP_INVOICES.invoice_currency_code%TYPE;
72: ---------------------------------------------------------------------------------------------------
73:
74: /*AP Invoices Interface */
75: ---------------------------------------------------------------------------------------------------
76: SUBTYPE invIntf_invID IS AP_INVOICES_INTERFACE.invoice_id%TYPE;
77: SUBTYPE invIntf_invNum IS AP_INVOICES_INTERFACE.invoice_num%TYPE;
78: SUBTYPE invIntf_partyID IS AP_INVOICES_INTERFACE.party_id%TYPE;
72: ---------------------------------------------------------------------------------------------------
73:
74: /*AP Invoices Interface */
75: ---------------------------------------------------------------------------------------------------
76: SUBTYPE invIntf_invID IS AP_INVOICES_INTERFACE.invoice_id%TYPE;
77: SUBTYPE invIntf_invNum IS AP_INVOICES_INTERFACE.invoice_num%TYPE;
78: SUBTYPE invIntf_partyID IS AP_INVOICES_INTERFACE.party_id%TYPE;
79: SUBTYPE invIntf_partySiteID IS AP_INVOICES_INTERFACE.party_site_id%TYPE;
80: SUBTYPE invIntf_vendorID IS AP_INVOICES_INTERFACE.vendor_id%TYPE;
73:
74: /*AP Invoices Interface */
75: ---------------------------------------------------------------------------------------------------
76: SUBTYPE invIntf_invID IS AP_INVOICES_INTERFACE.invoice_id%TYPE;
77: SUBTYPE invIntf_invNum IS AP_INVOICES_INTERFACE.invoice_num%TYPE;
78: SUBTYPE invIntf_partyID IS AP_INVOICES_INTERFACE.party_id%TYPE;
79: SUBTYPE invIntf_partySiteID IS AP_INVOICES_INTERFACE.party_site_id%TYPE;
80: SUBTYPE invIntf_vendorID IS AP_INVOICES_INTERFACE.vendor_id%TYPE;
81: SUBTYPE invIntf_vendorSiteID IS AP_INVOICES_INTERFACE.vendor_site_id%TYPE;
74: /*AP Invoices Interface */
75: ---------------------------------------------------------------------------------------------------
76: SUBTYPE invIntf_invID IS AP_INVOICES_INTERFACE.invoice_id%TYPE;
77: SUBTYPE invIntf_invNum IS AP_INVOICES_INTERFACE.invoice_num%TYPE;
78: SUBTYPE invIntf_partyID IS AP_INVOICES_INTERFACE.party_id%TYPE;
79: SUBTYPE invIntf_partySiteID IS AP_INVOICES_INTERFACE.party_site_id%TYPE;
80: SUBTYPE invIntf_vendorID IS AP_INVOICES_INTERFACE.vendor_id%TYPE;
81: SUBTYPE invIntf_vendorSiteID IS AP_INVOICES_INTERFACE.vendor_site_id%TYPE;
82: SUBTYPE invIntf_invAmt IS AP_INVOICES_INTERFACE.invoice_amount%TYPE;
75: ---------------------------------------------------------------------------------------------------
76: SUBTYPE invIntf_invID IS AP_INVOICES_INTERFACE.invoice_id%TYPE;
77: SUBTYPE invIntf_invNum IS AP_INVOICES_INTERFACE.invoice_num%TYPE;
78: SUBTYPE invIntf_partyID IS AP_INVOICES_INTERFACE.party_id%TYPE;
79: SUBTYPE invIntf_partySiteID IS AP_INVOICES_INTERFACE.party_site_id%TYPE;
80: SUBTYPE invIntf_vendorID IS AP_INVOICES_INTERFACE.vendor_id%TYPE;
81: SUBTYPE invIntf_vendorSiteID IS AP_INVOICES_INTERFACE.vendor_site_id%TYPE;
82: SUBTYPE invIntf_invAmt IS AP_INVOICES_INTERFACE.invoice_amount%TYPE;
83: SUBTYPE invIntf_invCurrCode IS AP_INVOICES_INTERFACE.invoice_currency_code%TYPE;
76: SUBTYPE invIntf_invID IS AP_INVOICES_INTERFACE.invoice_id%TYPE;
77: SUBTYPE invIntf_invNum IS AP_INVOICES_INTERFACE.invoice_num%TYPE;
78: SUBTYPE invIntf_partyID IS AP_INVOICES_INTERFACE.party_id%TYPE;
79: SUBTYPE invIntf_partySiteID IS AP_INVOICES_INTERFACE.party_site_id%TYPE;
80: SUBTYPE invIntf_vendorID IS AP_INVOICES_INTERFACE.vendor_id%TYPE;
81: SUBTYPE invIntf_vendorSiteID IS AP_INVOICES_INTERFACE.vendor_site_id%TYPE;
82: SUBTYPE invIntf_invAmt IS AP_INVOICES_INTERFACE.invoice_amount%TYPE;
83: SUBTYPE invIntf_invCurrCode IS AP_INVOICES_INTERFACE.invoice_currency_code%TYPE;
84: SUBTYPE invIntf_source IS AP_INVOICES_INTERFACE.source%TYPE;
77: SUBTYPE invIntf_invNum IS AP_INVOICES_INTERFACE.invoice_num%TYPE;
78: SUBTYPE invIntf_partyID IS AP_INVOICES_INTERFACE.party_id%TYPE;
79: SUBTYPE invIntf_partySiteID IS AP_INVOICES_INTERFACE.party_site_id%TYPE;
80: SUBTYPE invIntf_vendorID IS AP_INVOICES_INTERFACE.vendor_id%TYPE;
81: SUBTYPE invIntf_vendorSiteID IS AP_INVOICES_INTERFACE.vendor_site_id%TYPE;
82: SUBTYPE invIntf_invAmt IS AP_INVOICES_INTERFACE.invoice_amount%TYPE;
83: SUBTYPE invIntf_invCurrCode IS AP_INVOICES_INTERFACE.invoice_currency_code%TYPE;
84: SUBTYPE invIntf_source IS AP_INVOICES_INTERFACE.source%TYPE;
85: SUBTYPE invIntf_docCategoryCode IS AP_INVOICES_INTERFACE.doc_category_code%TYPE;
78: SUBTYPE invIntf_partyID IS AP_INVOICES_INTERFACE.party_id%TYPE;
79: SUBTYPE invIntf_partySiteID IS AP_INVOICES_INTERFACE.party_site_id%TYPE;
80: SUBTYPE invIntf_vendorID IS AP_INVOICES_INTERFACE.vendor_id%TYPE;
81: SUBTYPE invIntf_vendorSiteID IS AP_INVOICES_INTERFACE.vendor_site_id%TYPE;
82: SUBTYPE invIntf_invAmt IS AP_INVOICES_INTERFACE.invoice_amount%TYPE;
83: SUBTYPE invIntf_invCurrCode IS AP_INVOICES_INTERFACE.invoice_currency_code%TYPE;
84: SUBTYPE invIntf_source IS AP_INVOICES_INTERFACE.source%TYPE;
85: SUBTYPE invIntf_docCategoryCode IS AP_INVOICES_INTERFACE.doc_category_code%TYPE;
86: SUBTYPE invIntf_invTypeCode IS AP_INVOICES_INTERFACE.invoice_type_lookup_code%TYPE;
79: SUBTYPE invIntf_partySiteID IS AP_INVOICES_INTERFACE.party_site_id%TYPE;
80: SUBTYPE invIntf_vendorID IS AP_INVOICES_INTERFACE.vendor_id%TYPE;
81: SUBTYPE invIntf_vendorSiteID IS AP_INVOICES_INTERFACE.vendor_site_id%TYPE;
82: SUBTYPE invIntf_invAmt IS AP_INVOICES_INTERFACE.invoice_amount%TYPE;
83: SUBTYPE invIntf_invCurrCode IS AP_INVOICES_INTERFACE.invoice_currency_code%TYPE;
84: SUBTYPE invIntf_source IS AP_INVOICES_INTERFACE.source%TYPE;
85: SUBTYPE invIntf_docCategoryCode IS AP_INVOICES_INTERFACE.doc_category_code%TYPE;
86: SUBTYPE invIntf_invTypeCode IS AP_INVOICES_INTERFACE.invoice_type_lookup_code%TYPE;
87: SUBTYPE invIntf_acctsPayCCID IS AP_INVOICES_INTERFACE.accts_pay_code_combination_id%TYPE;
80: SUBTYPE invIntf_vendorID IS AP_INVOICES_INTERFACE.vendor_id%TYPE;
81: SUBTYPE invIntf_vendorSiteID IS AP_INVOICES_INTERFACE.vendor_site_id%TYPE;
82: SUBTYPE invIntf_invAmt IS AP_INVOICES_INTERFACE.invoice_amount%TYPE;
83: SUBTYPE invIntf_invCurrCode IS AP_INVOICES_INTERFACE.invoice_currency_code%TYPE;
84: SUBTYPE invIntf_source IS AP_INVOICES_INTERFACE.source%TYPE;
85: SUBTYPE invIntf_docCategoryCode IS AP_INVOICES_INTERFACE.doc_category_code%TYPE;
86: SUBTYPE invIntf_invTypeCode IS AP_INVOICES_INTERFACE.invoice_type_lookup_code%TYPE;
87: SUBTYPE invIntf_acctsPayCCID IS AP_INVOICES_INTERFACE.accts_pay_code_combination_id%TYPE;
88: ---------------------------------------------------------------------------------------------------
81: SUBTYPE invIntf_vendorSiteID IS AP_INVOICES_INTERFACE.vendor_site_id%TYPE;
82: SUBTYPE invIntf_invAmt IS AP_INVOICES_INTERFACE.invoice_amount%TYPE;
83: SUBTYPE invIntf_invCurrCode IS AP_INVOICES_INTERFACE.invoice_currency_code%TYPE;
84: SUBTYPE invIntf_source IS AP_INVOICES_INTERFACE.source%TYPE;
85: SUBTYPE invIntf_docCategoryCode IS AP_INVOICES_INTERFACE.doc_category_code%TYPE;
86: SUBTYPE invIntf_invTypeCode IS AP_INVOICES_INTERFACE.invoice_type_lookup_code%TYPE;
87: SUBTYPE invIntf_acctsPayCCID IS AP_INVOICES_INTERFACE.accts_pay_code_combination_id%TYPE;
88: ---------------------------------------------------------------------------------------------------
89:
82: SUBTYPE invIntf_invAmt IS AP_INVOICES_INTERFACE.invoice_amount%TYPE;
83: SUBTYPE invIntf_invCurrCode IS AP_INVOICES_INTERFACE.invoice_currency_code%TYPE;
84: SUBTYPE invIntf_source IS AP_INVOICES_INTERFACE.source%TYPE;
85: SUBTYPE invIntf_docCategoryCode IS AP_INVOICES_INTERFACE.doc_category_code%TYPE;
86: SUBTYPE invIntf_invTypeCode IS AP_INVOICES_INTERFACE.invoice_type_lookup_code%TYPE;
87: SUBTYPE invIntf_acctsPayCCID IS AP_INVOICES_INTERFACE.accts_pay_code_combination_id%TYPE;
88: ---------------------------------------------------------------------------------------------------
89:
90:
83: SUBTYPE invIntf_invCurrCode IS AP_INVOICES_INTERFACE.invoice_currency_code%TYPE;
84: SUBTYPE invIntf_source IS AP_INVOICES_INTERFACE.source%TYPE;
85: SUBTYPE invIntf_docCategoryCode IS AP_INVOICES_INTERFACE.doc_category_code%TYPE;
86: SUBTYPE invIntf_invTypeCode IS AP_INVOICES_INTERFACE.invoice_type_lookup_code%TYPE;
87: SUBTYPE invIntf_acctsPayCCID IS AP_INVOICES_INTERFACE.accts_pay_code_combination_id%TYPE;
88: ---------------------------------------------------------------------------------------------------
89:
90:
91:
106: SUBTYPE expFeedDists_statusChangeDate IS AP_EXPENSE_FEED_DISTS.status_change_date%TYPE;
107: ---------------------------------------------------------------------------------------------------
108:
109:
110: /*AP Invoices Lines Interface */
111: ---------------------------------------------------------------------------------------------------
112: SUBTYPE invLines_invID IS AP_INVOICE_LINES_INTERFACE.invoice_id%type;
113: SUBTYPE invLines_invLineID IS AP_INVOICE_LINES_INTERFACE.invoice_line_id%type;
114: SUBTYPE invLines_lineNum IS AP_INVOICE_LINES_INTERFACE.line_number%type;
119: SUBTYPE invLines_crdCardTrxID IS AP_INVOICE_LINES_INTERFACE.credit_card_trx_id%type;
120: SUBTYPE invLines_description IS AP_INVOICE_LINES_INTERFACE.description%type;
121: ---------------------------------------------------------------------------------------------------
122:
123: /*AP Invoices All */
124: ---------------------------------------------------------------------------------------------------
125: SUBTYPE invAll_exchangeRate IS AP_INVOICES_ALL.exchange_rate%TYPE;
126: SUBTYPE invAll_id IS AP_INVOICES_ALL.invoice_id%TYPE;
127: SUBTYPE invAll_invoiceAmount IS AP_INVOICES_ALL.invoice_amount%TYPE;
121: ---------------------------------------------------------------------------------------------------
122:
123: /*AP Invoices All */
124: ---------------------------------------------------------------------------------------------------
125: SUBTYPE invAll_exchangeRate IS AP_INVOICES_ALL.exchange_rate%TYPE;
126: SUBTYPE invAll_id IS AP_INVOICES_ALL.invoice_id%TYPE;
127: SUBTYPE invAll_invoiceAmount IS AP_INVOICES_ALL.invoice_amount%TYPE;
128: SUBTYPE invAll_baseAmount IS AP_INVOICES_ALL.base_amount%TYPE;
129: ---------------------------------------------------------------------------------------------------
122:
123: /*AP Invoices All */
124: ---------------------------------------------------------------------------------------------------
125: SUBTYPE invAll_exchangeRate IS AP_INVOICES_ALL.exchange_rate%TYPE;
126: SUBTYPE invAll_id IS AP_INVOICES_ALL.invoice_id%TYPE;
127: SUBTYPE invAll_invoiceAmount IS AP_INVOICES_ALL.invoice_amount%TYPE;
128: SUBTYPE invAll_baseAmount IS AP_INVOICES_ALL.base_amount%TYPE;
129: ---------------------------------------------------------------------------------------------------
130:
123: /*AP Invoices All */
124: ---------------------------------------------------------------------------------------------------
125: SUBTYPE invAll_exchangeRate IS AP_INVOICES_ALL.exchange_rate%TYPE;
126: SUBTYPE invAll_id IS AP_INVOICES_ALL.invoice_id%TYPE;
127: SUBTYPE invAll_invoiceAmount IS AP_INVOICES_ALL.invoice_amount%TYPE;
128: SUBTYPE invAll_baseAmount IS AP_INVOICES_ALL.base_amount%TYPE;
129: ---------------------------------------------------------------------------------------------------
130:
131: /* AP Tax Codes */
124: ---------------------------------------------------------------------------------------------------
125: SUBTYPE invAll_exchangeRate IS AP_INVOICES_ALL.exchange_rate%TYPE;
126: SUBTYPE invAll_id IS AP_INVOICES_ALL.invoice_id%TYPE;
127: SUBTYPE invAll_invoiceAmount IS AP_INVOICES_ALL.invoice_amount%TYPE;
128: SUBTYPE invAll_baseAmount IS AP_INVOICES_ALL.base_amount%TYPE;
129: ---------------------------------------------------------------------------------------------------
130:
131: /* AP Tax Codes */
132: