DBA Data[Home] [Help]

APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_INVOICES

Line 69: /*AP Invoices */

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:

Line 71: SUBTYPE invoices_invCurrCode IS AP_INVOICES.invoice_currency_code%TYPE;

67: ---------------------------------------------------------------------------------------------------
68:
69: /*AP Invoices */
70: ---------------------------------------------------------------------------------------------------
71: SUBTYPE invoices_invCurrCode IS AP_INVOICES.invoice_currency_code%TYPE;
72: ---------------------------------------------------------------------------------------------------
73:
74: /*AP Invoices Interface */
75: ---------------------------------------------------------------------------------------------------

Line 74: /*AP Invoices Interface */

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;

Line 76: SUBTYPE invIntf_invID IS AP_INVOICES_INTERFACE.invoice_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;

Line 77: SUBTYPE invIntf_invNum IS AP_INVOICES_INTERFACE.invoice_num%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;

Line 78: SUBTYPE invIntf_partyID IS AP_INVOICES_INTERFACE.party_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;

Line 79: SUBTYPE invIntf_partySiteID IS AP_INVOICES_INTERFACE.party_site_id%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;

Line 80: SUBTYPE invIntf_vendorID IS AP_INVOICES_INTERFACE.vendor_id%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;

Line 81: SUBTYPE invIntf_vendorSiteID IS AP_INVOICES_INTERFACE.vendor_site_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;
85: SUBTYPE invIntf_docCategoryCode IS AP_INVOICES_INTERFACE.doc_category_code%TYPE;

Line 82: SUBTYPE invIntf_invAmt IS AP_INVOICES_INTERFACE.invoice_amount%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;

Line 83: SUBTYPE invIntf_invCurrCode IS AP_INVOICES_INTERFACE.invoice_currency_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;

Line 84: SUBTYPE invIntf_source IS AP_INVOICES_INTERFACE.source%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: ---------------------------------------------------------------------------------------------------

Line 85: SUBTYPE invIntf_docCategoryCode IS AP_INVOICES_INTERFACE.doc_category_code%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: ---------------------------------------------------------------------------------------------------
89:

Line 86: SUBTYPE invIntf_invTypeCode IS AP_INVOICES_INTERFACE.invoice_type_lookup_code%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:
90:

Line 87: SUBTYPE invIntf_acctsPayCCID IS AP_INVOICES_INTERFACE.accts_pay_code_combination_id%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:
91:

Line 110: /*AP Invoices Lines Interface */

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;

Line 123: /*AP Invoices All */

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;

Line 125: SUBTYPE invAll_exchangeRate IS AP_INVOICES_ALL.exchange_rate%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: ---------------------------------------------------------------------------------------------------

Line 126: SUBTYPE invAll_id IS AP_INVOICES_ALL.invoice_id%TYPE;

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:

Line 127: SUBTYPE invAll_invoiceAmount IS AP_INVOICES_ALL.invoice_amount%TYPE;

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 */

Line 128: SUBTYPE invAll_baseAmount IS AP_INVOICES_ALL.base_amount%TYPE;

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: