Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AP_INVOICES_V

Object Details
Object Name: AP_INVOICES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.AP_INVOICES_V
ViewSQLAP.AP_INVOICES_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ACCTS_PAY_CODE_COMBINATION_ID NUMBER (15)
AMOUNT_APPLICABLE_TO_DISCOUNT NUMBER

AMOUNT_PAID NUMBER

APPROVAL_DESCRIPTION VARCHAR2 (240)
APPROVED_AMOUNT NUMBER

ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
AUTHORIZED_BY VARCHAR2 (25)
AWT_FLAG VARCHAR2 (1)
AWT_GROUP_ID NUMBER (15)
BASE_AMOUNT NUMBER

BATCH_ID NUMBER (15)
CANCELLED_AMOUNT NUMBER

CANCELLED_BY NUMBER (15)
CANCELLED_DATE DATE

CREATED_BY NUMBER (15)
CREATION_DATE DATE

DESCRIPTION VARCHAR2 (240)
DISCOUNT_AMOUNT_TAKEN NUMBER

DOC_CATEGORY_CODE VARCHAR2 (30)
DOC_SEQUENCE_ID NUMBER

DOC_SEQUENCE_VALUE NUMBER

EARLIEST_SETTLEMENT_DATE DATE

EXCHANGE_DATE DATE

EXCHANGE_RATE NUMBER

EXCHANGE_RATE_TYPE VARCHAR2 (30)
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 (1)
EXPENDITURE_ITEM_DATE DATE

EXPENDITURE_ORGANIZATION_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
GOODS_RECEIVED_DATE DATE

INVOICE_AMOUNT NUMBER

INVOICE_CURRENCY_CODE VARCHAR2 (15) Yes
INVOICE_DATE DATE

INVOICE_ID NUMBER (15) Yes
INVOICE_NUM VARCHAR2 (50) Yes
INVOICE_RECEIVED_DATE DATE

INVOICE_TYPE_LOOKUP_CODE VARCHAR2 (25)
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
ORIGINAL_PREPAYMENT_AMOUNT NUMBER

PAYMENT_AMOUNT_TOTAL NUMBER

PAYMENT_CROSS_RATE NUMBER
Yes
PAYMENT_CURRENCY_CODE VARCHAR2 (15) Yes
PAYMENT_STATUS_FLAG VARCHAR2 (1)
PAY_GROUP_LOOKUP_CODE VARCHAR2 (25)
PA_DEFAULT_DIST_CCID NUMBER (15)
PA_QUANTITY NUMBER (22)
PO_HEADER_ID NUMBER (15)
PROJECT_ID NUMBER (15)
RECURRING_PAYMENT_ID NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15) Yes
SOURCE VARCHAR2 (25)
TASK_ID NUMBER (15)
TEMP_CANCELLED_AMOUNT NUMBER

TERMS_DATE DATE

TERMS_ID NUMBER (15)
VENDOR_ID NUMBER (15)
VENDOR_PREPAY_AMOUNT NUMBER

VENDOR_SITE_ID NUMBER (15)
VOUCHER_NUM VARCHAR2 (50)
BATCH_NAME VARCHAR2 (50)
INVOICE_TYPE VARCHAR2 (80)
PAYMENT_STATUS VARCHAR2 (80)
PREPAYMENT_TYPE_LOOKUP_CODE VARCHAR2 (9)
USER_RATE_TYPE VARCHAR2 (30)
RECURRING_PAY_NUM VARCHAR2 (25)
RECURRING_PERIOD_TYPE VARCHAR2 (15)
RECURRING_PAYMENT_TYPE VARCHAR2 (240)
TERMS_NAME VARCHAR2 (50)
ACTUAL_INVOICE_AMOUNT NUMBER

DOC_SEQUENCE_NAME VARCHAR2 (30)
DOC_CATEGORY_NAME VARCHAR2 (80)
SET_OF_BOOKS_NAME VARCHAR2 (30) Yes
EXPENDITURE_ORGANIZATION_NAME VARCHAR2 (240)
VENDOR_NAME VARCHAR2 (360)
VENDOR_NUMBER VARCHAR2 (30)
NUM_1099 VARCHAR2 (20)
VENDOR_SITE_CODE VARCHAR2 (15)
HOLD_FUTURE_PAYMENTS_FLAG VARCHAR2 (1)
INVOICE_AMOUNT_LIMIT NUMBER

TERMS_DATE_BASIS VARCHAR2 (25)
PAYMENT_PRIORITY NUMBER

PAY_DATE_BASIS_LOOKUP_CODE VARCHAR2 (25)
ALWAYS_TAKE_DISC_FLAG VARCHAR2 (1)
EXCLUDE_FREIGHT_FROM_DISCOUNT VARCHAR2 (1)
SITE_ALLOW_AWT_FLAG VARCHAR2 (1)
INCOME_TAX_REGION VARCHAR2 (60)
DISTRIBUTION_TOTAL NUMBER

POSTING_FLAG VARCHAR2 (4000)
APPROVAL_STATUS_LOOKUP_CODE VARCHAR2 (4000)
PO_NUMBER VARCHAR2 (4000)
RELEASE_NUMBER VARCHAR2 (4000)
RECEIPT_NUMBER VARCHAR2 (4000)
AMOUNT_WITHHELD NUMBER

PREPAID_AMOUNT NUMBER

NOTES_COUNT NUMBER

HOLDS_COUNT NUMBER

AMOUNT_HOLD_FLAG VARCHAR2 (4000)
VENDOR_HOLD_FLAG VARCHAR2 (4000)
ENCUMBERED_FLAG VARCHAR2 (4000)
GL_DATE DATE
Yes
PERIOD_NAME VARCHAR2 (4000)
SELECTED_FOR_PAYMENT_FLAG VARCHAR2 (4000)
UNPOSTED_VOID_PAYMENT_FLAG VARCHAR2 (4000)
DISCOUNT_PAY_DISTS_FLAG VARCHAR2 (4000)
PREPAYMENTS_APPLIED_FLAG VARCHAR2 (4000)
PAYMENTS_EXIST_FLAG VARCHAR2 (4000)
QUERY_PACKET_ID NUMBER

PREPAY_AMOUNT_APPLIED NUMBER

CANCELLED_BY_DISPLAY VARCHAR2 (4000)
APPROVAL_STATUS VARCHAR2 (25)
POSTING_STATUS VARCHAR2 (15)
REFERENCE_1 VARCHAR2 (30)
REFERENCE_2 VARCHAR2 (30)
ORG_ID NUMBER (15)
AWT_GROUP_NAME VARCHAR2 (25)
PROJECT VARCHAR2 (25)
TASK VARCHAR2 (278)
MINIMUM_ACCOUNTABLE_UNIT NUMBER

PRECISION NUMBER (1)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
PAYMENT_CROSS_RATE_TYPE VARCHAR2 (30)
PAYMENT_CROSS_RATE_DATE DATE

PAY_CURR_INVOICE_AMOUNT NUMBER

TYPE_1099 VARCHAR2 (10)
AWARD_ID NUMBER (15)
WFAPPROVAL_STATUS VARCHAR2 (50) Yes
APPROVAL_READY_FLAG VARCHAR2 (1) Yes
APPROVAL_ITERATION NUMBER (9)
WFAPPROVAL_STATUS_DSP VARCHAR2 (80)
REQUESTER_ID NUMBER (15)
QUICK_CREDIT VARCHAR2 (1)
CREDITED_INVOICE_ID NUMBER (15)
CREDITED_INVOICE_NUM VARCHAR2 (4000)
DISTRIBUTION_SET_ID NUMBER (15)
DISTRIBUTION_SET_NAME VARCHAR2 (50)
LINE_TOTAL NUMBER

HIGHEST_LINE_NUM NUMBER

TOTAL_TAX_AMOUNT NUMBER

CONTROL_AMOUNT NUMBER

TAXATION_COUNTRY VARCHAR2 (30)
TAXATION_COUNTRY_NAME VARCHAR2 (80)
TRX_BUSINESS_CATEGORY VARCHAR2 (240)
TRX_BUSINESS_CATEGORY_NAME VARCHAR2 (1996)
USER_DEFINED_FISC_CLASS VARCHAR2 (240)
DOCUMENT_SUB_TYPE VARCHAR2 (150)
SELF_ASSESSED_TAX_AMOUNT NUMBER

TAX_INVOICE_INTERNAL_SEQ VARCHAR2 (150)
SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2 (150)
TAX_INVOICE_RECORDING_DATE DATE

SUPPLIER_TAX_INVOICE_DATE DATE

SUPPLIER_TAX_EXCHANGE_RATE NUMBER

FORCE_REVALIDATION_FLAG VARCHAR2 (1)
APPLICATION_ID NUMBER (15)
PRODUCT_TABLE VARCHAR2 (30)
REFERENCE_KEY1 VARCHAR2 (150)
REFERENCE_KEY2 VARCHAR2 (150)
REFERENCE_KEY3 VARCHAR2 (150)
REFERENCE_KEY4 VARCHAR2 (150)
REFERENCE_KEY5 VARCHAR2 (150)
DISC_IS_INV_LESS_TAX_FLAG VARCHAR2 (1)
QUICK_PO_HEADER_ID NUMBER (15)
QUICK_PO_NUMBER VARCHAR2 (50)
PAYMENT_METHOD_CODE VARCHAR2 (30)
IBY_PAYMENT_METHOD VARCHAR2 (100)
PAYMENT_REASON_CODE VARCHAR2 (30)
PAYMENT_REASON VARCHAR2 (80)
PAYMENT_REASON_COMMENTS VARCHAR2 (240)
UNIQUE_REMITTANCE_IDENTIFIER VARCHAR2 (30)
URI_CHECK_DIGIT VARCHAR2 (2)
REMITTANCE_MESSAGE1 VARCHAR2 (150)
REMITTANCE_MESSAGE2 VARCHAR2 (150)
REMITTANCE_MESSAGE3 VARCHAR2 (150)
BANK_CHARGE_BEARER VARCHAR2 (30)
BANK_CHARGE_BEARER_DSP VARCHAR2 (80)
DELIVERY_CHANNEL_CODE VARCHAR2 (30)
DELIVERY_CHANNEL VARCHAR2 (80)
SETTLEMENT_PRIORITY VARCHAR2 (30)
SETTLEMENT_PRIORITY_DSP VARCHAR2 (80)
PARTY_ID NUMBER

PARTY_SITE_ID NUMBER (15)
NET_OF_RETAINAGE_FLAG VARCHAR2 (1)
RELEASE_AMOUNT_NET_OF_TAX NUMBER

RETAINED_TOTAL VARCHAR2 (0)
ITEM_TOTAL VARCHAR2 (0)
FREIGHT_TOTAL VARCHAR2 (0)
MISC_TOTAL VARCHAR2 (0)
PREPAY_APP_TOTAL VARCHAR2 (0)
AWT_TOTAL VARCHAR2 (0)
CUST_REGISTRATION_CODE VARCHAR2 (50)
CUST_REGISTRATION_NUMBER VARCHAR2 (30)
PORT_OF_ENTRY_CODE VARCHAR2 (30)
EXTERNAL_BANK_ACCOUNT_ID NUMBER (15)
BANK_ACCOUNT_NAME VARCHAR2 (80)
BANK_ACCOUNT_NUM VARCHAR2 (100)
PAYMENT_FUNCTION VARCHAR2 (30)
PAY_PROC_TRXN_TYPE_CODE VARCHAR2 (30)
PAY_AWT_GROUP_ID NUMBER (15)
PAY_AWT_GROUP_NAME VARCHAR2 (25)
ORIGINAL_INVOICE_AMOUNT NUMBER

DISPUTE_REASON VARCHAR2 (100)
REMIT_TO_SUPPLIER_NAME VARCHAR2 (240)
REMIT_TO_SUPPLIER_ID NUMBER (15)
REMIT_TO_SUPPLIER_SITE VARCHAR2 (240)
REMIT_TO_SUPPLIER_SITE_ID NUMBER (15)
RELATIONSHIP_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ACCTS_PAY_CODE_COMBINATION_ID
,      AMOUNT_APPLICABLE_TO_DISCOUNT
,      AMOUNT_PAID
,      APPROVAL_DESCRIPTION
,      APPROVED_AMOUNT
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      AUTHORIZED_BY
,      AWT_FLAG
,      AWT_GROUP_ID
,      BASE_AMOUNT
,      BATCH_ID
,      CANCELLED_AMOUNT
,      CANCELLED_BY
,      CANCELLED_DATE
,      CREATED_BY
,      CREATION_DATE
,      DESCRIPTION
,      DISCOUNT_AMOUNT_TAKEN
,      DOC_CATEGORY_CODE
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      EARLIEST_SETTLEMENT_DATE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCLUSIVE_PAYMENT_FLAG
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      GOODS_RECEIVED_DATE
,      INVOICE_AMOUNT
,      INVOICE_CURRENCY_CODE
,      INVOICE_DATE
,      INVOICE_ID
,      INVOICE_NUM
,      INVOICE_RECEIVED_DATE
,      INVOICE_TYPE_LOOKUP_CODE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORIGINAL_PREPAYMENT_AMOUNT
,      PAYMENT_AMOUNT_TOTAL
,      PAYMENT_CROSS_RATE
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_STATUS_FLAG
,      PAY_GROUP_LOOKUP_CODE
,      PA_DEFAULT_DIST_CCID
,      PA_QUANTITY
,      PO_HEADER_ID
,      PROJECT_ID
,      RECURRING_PAYMENT_ID
,      SET_OF_BOOKS_ID
,      SOURCE
,      TASK_ID
,      TEMP_CANCELLED_AMOUNT
,      TERMS_DATE
,      TERMS_ID
,      VENDOR_ID
,      VENDOR_PREPAY_AMOUNT
,      VENDOR_SITE_ID
,      VOUCHER_NUM
,      BATCH_NAME
,      INVOICE_TYPE
,      PAYMENT_STATUS
,      PREPAYMENT_TYPE_LOOKUP_CODE
,      USER_RATE_TYPE
,      RECURRING_PAY_NUM
,      RECURRING_PERIOD_TYPE
,      RECURRING_PAYMENT_TYPE
,      TERMS_NAME
,      ACTUAL_INVOICE_AMOUNT
,      DOC_SEQUENCE_NAME
,      DOC_CATEGORY_NAME
,      SET_OF_BOOKS_NAME
,      EXPENDITURE_ORGANIZATION_NAME
,      VENDOR_NAME
,      VENDOR_NUMBER
,      NUM_1099
,      VENDOR_SITE_CODE
,      HOLD_FUTURE_PAYMENTS_FLAG
,      INVOICE_AMOUNT_LIMIT
,      TERMS_DATE_BASIS
,      PAYMENT_PRIORITY
,      PAY_DATE_BASIS_LOOKUP_CODE
,      ALWAYS_TAKE_DISC_FLAG
,      EXCLUDE_FREIGHT_FROM_DISCOUNT
,      SITE_ALLOW_AWT_FLAG
,      INCOME_TAX_REGION
,      DISTRIBUTION_TOTAL
,      POSTING_FLAG
,      APPROVAL_STATUS_LOOKUP_CODE
,      PO_NUMBER
,      RELEASE_NUMBER
,      RECEIPT_NUMBER
,      AMOUNT_WITHHELD
,      PREPAID_AMOUNT
,      NOTES_COUNT
,      HOLDS_COUNT
,      AMOUNT_HOLD_FLAG
,      VENDOR_HOLD_FLAG
,      ENCUMBERED_FLAG
,      GL_DATE
,      PERIOD_NAME
,      SELECTED_FOR_PAYMENT_FLAG
,      UNPOSTED_VOID_PAYMENT_FLAG
,      DISCOUNT_PAY_DISTS_FLAG
,      PREPAYMENTS_APPLIED_FLAG
,      PAYMENTS_EXIST_FLAG
,      QUERY_PACKET_ID
,      PREPAY_AMOUNT_APPLIED
,      CANCELLED_BY_DISPLAY
,      APPROVAL_STATUS
,      POSTING_STATUS
,      REFERENCE_1
,      REFERENCE_2
,      ORG_ID
,      AWT_GROUP_NAME
,      PROJECT
,      TASK
,      MINIMUM_ACCOUNTABLE_UNIT
,      PRECISION
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      PAYMENT_CROSS_RATE_TYPE
,      PAYMENT_CROSS_RATE_DATE
,      PAY_CURR_INVOICE_AMOUNT
,      TYPE_1099
,      AWARD_ID
,      WFAPPROVAL_STATUS
,      APPROVAL_READY_FLAG
,      APPROVAL_ITERATION
,      WFAPPROVAL_STATUS_DSP
,      REQUESTER_ID
,      QUICK_CREDIT
,      CREDITED_INVOICE_ID
,      CREDITED_INVOICE_NUM
,      DISTRIBUTION_SET_ID
,      DISTRIBUTION_SET_NAME
,      LINE_TOTAL
,      HIGHEST_LINE_NUM
,      TOTAL_TAX_AMOUNT
,      CONTROL_AMOUNT
,      TAXATION_COUNTRY
,      TAXATION_COUNTRY_NAME
,      TRX_BUSINESS_CATEGORY
,      TRX_BUSINESS_CATEGORY_NAME
,      USER_DEFINED_FISC_CLASS
,      TAX_RELATED_INVOICE_ID
,      TAX_RELATED_INVOICE_NUM
,      DOCUMENT_SUB_TYPE
,      SELF_ASSESSED_TAX_AMOUNT
,      TAX_INVOICE_INTERNAL_SEQ
,      SUPPLIER_TAX_INVOICE_NUMBER
,      TAX_INVOICE_RECORDING_DATE
,      SUPPLIER_TAX_INVOICE_DATE
,      SUPPLIER_TAX_EXCHANGE_RATE
,      LEGAL_ENTITY_ID
,      FORCE_REVALIDATION_FLAG
,      APPLICATION_ID
,      PRODUCT_TABLE
,      REFERENCE_KEY1
,      REFERENCE_KEY2
,      REFERENCE_KEY3
,      REFERENCE_KEY4
,      REFERENCE_KEY5
,      DISC_IS_INV_LESS_TAX_FLAG
,      QUICK_PO_HEADER_ID
,      QUICK_PO_NUMBER
,      PAYMENT_METHOD_CODE
,      IBY_PAYMENT_METHOD
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON
,      PAYMENT_REASON_COMMENTS
,      UNIQUE_REMITTANCE_IDENTIFIER
,      URI_CHECK_DIGIT
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      BANK_CHARGE_BEARER
,      BANK_CHARGE_BEARER_DSP
,      DELIVERY_CHANNEL_CODE
,      DELIVERY_CHANNEL
,      SETTLEMENT_PRIORITY
,      SETTLEMENT_PRIORITY_DSP
,      PARTY_ID
,      PARTY_SITE_ID
,      NET_OF_RETAINAGE_FLAG
,      RELEASE_AMOUNT_NET_OF_TAX
,      RETAINED_TOTAL
,      ITEM_TOTAL
,      FREIGHT_TOTAL
,      MISC_TOTAL
,      PREPAY_APP_TOTAL
,      AWT_TOTAL
,      CUST_REGISTRATION_CODE
,      CUST_REGISTRATION_NUMBER
,      PORT_OF_ENTRY_CODE
,      EXTERNAL_BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      PAYMENT_FUNCTION
,      PAY_PROC_TRXN_TYPE_CODE
,      PAY_AWT_GROUP_ID
,      PAY_AWT_GROUP_NAME
,      ORIGINAL_INVOICE_AMOUNT
,      DISPUTE_REASON
,      REMIT_TO_SUPPLIER_NAME
,      REMIT_TO_SUPPLIER_ID
,      REMIT_TO_SUPPLIER_SITE
,      REMIT_TO_SUPPLIER_SITE_ID
,      RELATIONSHIP_ID
FROM APPS.AP_INVOICES_V;

Dependencies

[top of page]

APPS.AP_INVOICES_V references the following:

SchemaAPPS
SynonymAP_AWT_GROUPS
SynonymAP_BATCHES_ALL
SynonymAP_DISTRIBUTION_SETS
SynonymAP_INVOICES_ALL
PL/SQL PackageAP_INVOICES_PKG - show dependent code
PL/SQL PackageAP_INVOICES_UTILITY_PKG - show dependent code
ViewAP_LOOKUP_CODES
SynonymAP_OTHER_PERIOD_TYPES
PL/SQL PackageAP_PREPAY_UTILS_PKG - show dependent code
SynonymAP_RECURRING_PAYMENTS_ALL
SynonymAP_SYSTEM_PARAMETERS
SynonymAP_TERMS
SynonymFND_CURRENCIES
SynonymFND_DOCUMENT_SEQUENCES
SynonymFND_DOC_SEQUENCE_CATEGORIES
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymFND_TERRITORIES_TL
PL/SQL PackageFND_USER_AP_PKG - show dependent code
SynonymGL_DAILY_CONVERSION_TYPES
ViewGL_SETS_OF_BOOKS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHZ_PARTIES
ViewIBY_DELIVERY_CHANNELS_VL
SynonymIBY_EXT_BANK_ACCOUNTS
ViewIBY_PAYMENT_METHODS_VL
ViewIBY_PAYMENT_REASONS_VL
SynonymPA_PROJECTS_ALL
ViewPA_TASKS_EXPEND_V
PL/SQL PackagePA_TASK_UTILS - show dependent code
PL/SQL PackagePA_UTILS4 - show dependent code
SynonymPO_HEADERS
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
ViewZX_FC_BUSINESS_CATEGORIES_V
APPS.AP_INVOICES_V is referenced by following:

SchemaAPPS
Package BodyARP_PROCESS_APPLICATION - show dependent code
Package BodyAR_REFUNDS_GRP - show dependent code
Package BodyFV_IPAC_DISBURSEMENT_PKG - show dependent code
Package BodyIGIPMSDA - show dependent code
ViewIGI_EXP_AVAILABLE_TRX_V
ViewIGI_EXP_DU_LINES_V
ViewIGI_MPP_AP_INVOICES_MERGE_V
ViewIGI_MPP_EXP_RECOGNITION
ViewIGI_MPP_NON_MPP_INVOICES_V
ViewIGI_MPP_SELECTED_INVOICES_V
Package BodyJA_CN_AP_PBD_EXPORT_PKG - show dependent code
Package BodyJL_ZZ_AP_LIBRARY_1_PKG - show dependent code