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


VIEW: APPS.AP_PAYMENT_EXTRACT_HEADER_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (15)
PAYMENT_TRANSACTION_NUMBER NUMBER (15) Yes
PAYMENT_TYPE VARCHAR2 (25) Yes
PAYMENT_DOCUMENT_TYPE VARCHAR2 (30)
PAYMENT_DOCUMENT_SEQUENCE_ID NUMBER

DOC_SEQUENCE_NAME VARCHAR2 (30)
THIRD_PARTY_TYPE VARCHAR2 (1)
CBA_POOLED_BANK_ACOUNT_FLAG VARCHAR2 (1)
AC_CHECK_ID NUMBER (15) Yes
AC_PROVINCE VARCHAR2 (150)
AC_ACTUAL_VALUE_DATE DATE

AC_ADDRESS_LINE_1 VARCHAR2 (240)
AC_ADDRESS_LINE_2 VARCHAR2 (240)
AC_ADDRESS_LINE_3 VARCHAR2 (240)
AC_ADDRESS_LINE_4 VARCHAR2 (240)
AC_AMOUNT NUMBER
Yes
AC_ATTRIBUTE_CATEGORY VARCHAR2 (150)
AC_ATTRIBUTE1 VARCHAR2 (150)
AC_ATTRIBUTE10 VARCHAR2 (150)
AC_ATTRIBUTE11 VARCHAR2 (150)
AC_ATTRIBUTE12 VARCHAR2 (150)
AC_ATTRIBUTE13 VARCHAR2 (150)
AC_ATTRIBUTE14 VARCHAR2 (150)
AC_ATTRIBUTE15 VARCHAR2 (150)
AC_ATTRIBUTE2 VARCHAR2 (150)
AC_ATTRIBUTE3 VARCHAR2 (150)
AC_ATTRIBUTE4 VARCHAR2 (150)
AC_ATTRIBUTE5 VARCHAR2 (150)
AC_ATTRIBUTE6 VARCHAR2 (150)
AC_ATTRIBUTE7 VARCHAR2 (150)
AC_ATTRIBUTE8 VARCHAR2 (150)
AC_ATTRIBUTE9 VARCHAR2 (150)
AC_CHECK_DATE DATE
Yes
AC_CHECK_VOUCHER_NUMBER NUMBER (16)
AC_CHECKRUN_NAME VARCHAR2 (255)
AC_CITY VARCHAR2 (25)
AC_COUNTRY VARCHAR2 (25)
AC_COUNTY VARCHAR2 (150)
AC_DESCRIPTION VARCHAR2 (240)
AC_DOC_CATEGORY_CODE VARCHAR2 (30)
AC_DOC_SEQUENCE_VALUE NUMBER

AC_FUTURE_PAY_DUE_DATE DATE

AC_STATE VARCHAR2 (150)
AC_VENDOR_NAME VARCHAR2 (240)
AC_VOID_DATE DATE

AC_ZIP VARCHAR2 (20)
CBA_ACCOUNT_CLASSIFICATION VARCHAR2 (30)
CBA_BANK_ACCOUNT_NAME VARCHAR2 (100)
CBA_BANK_ACCOUNT_NAME_ALT VARCHAR2 (320)
CBA_BANK_ACCOUNT_NUM VARCHAR2 (30)
CBA_BANK_ACCOUNT_TYPE VARCHAR2 (25)
CBA_DESCRIPTION VARCHAR2 (240)
CBA_IBAN_NUMBER VARCHAR2 (50)
AC_VENDOR_ID NUMBER

AC_VENDOR_SITE_ID NUMBER

AC_ORG_ID NUMBER (15)
AC_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_1 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_2 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_3 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_4 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_5 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_6 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_7 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_8 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_9 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_10 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_11 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_12 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_13 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_14 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_15 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_16 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_17 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_18 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_19 VARCHAR2 (150)
AC_GLOBAL_ATTRIBUTE_20 VARCHAR2 (150)
AC_EXTERNAL_BANK_ACCOUNT_ID NUMBER (15)
APH_PAYMENT_HISTORY_ID NUMBER (15) Yes
APH_ACCOUNTING_DATE DATE
Yes
APH_TRANSACTION_TYPE VARCHAR2 (30) Yes
APH_REV_PMT_HIST_ID NUMBER (15)
APH_BANK_CURR_AMOUNT NUMBER

APH_AMOUNT NUMBER
Yes
APH_HISTORICAL_FLAG VARCHAR2 (1)
CGAC_CASH_CLEARING_CCID NUMBER

CGAC_AP_ASSET_CCID NUMBER (15)
CGAC_BANK_CHARGES_CCID NUMBER (15)
CGAC_BANK_ERRORS_CCID NUMBER (15)
CGAC_FUTURE_DATED_PMT_CCID NUMBER (15)
TRANSAC_REVERSAL_FLAG VARCHAR2 (1)
AC_PARTY_ID NUMBER (15)
AC_PARTY_SITE_ID NUMBER (15)
AC_CURRENCY_CODE VARCHAR2 (15) Yes
AC_EXCHANGE_DATE DATE

AC_EXCHANGE_RATE NUMBER

AC_EXCHANGE_RATE_TYPE VARCHAR2 (30)
AC_LEDGER_AMOUNT NUMBER

APH_BASE_AMOUNT NUMBER

APH_ERRORS_BASE_AMOUNT NUMBER

APH_CHARGES_BASE_AMOUNT NUMBER

APH_BANK_CURRENCY_CODE VARCHAR2 (15)
APH_BANK_TO_BASE_XRATE_TYPE VARCHAR2 (30)
APH_BANK_TO_BASE_XRATE_DATE DATE

APH_BANK_TO_BASE_XRATE NUMBER

APH_PMT_CURRENCY_CODE VARCHAR2 (15) Yes
APH_PMT_TO_BASE_XRATE_TYPE VARCHAR2 (30)
APH_PMT_TO_BASE_XRATE_DATE DATE

APH_PMT_TO_BASE_XRATE NUMBER

APH_INVOICE_ADJ_EVENT_ID NUMBER (15)
POV_ATTRIBUTE_CATEGORY VARCHAR2 (30)
POV_ATTRIBUTE1 VARCHAR2 (150)
POV_ATTRIBUTE10 VARCHAR2 (150)
POV_ATTRIBUTE11 VARCHAR2 (150)
POV_ATTRIBUTE12 VARCHAR2 (150)
POV_ATTRIBUTE13 VARCHAR2 (150)
POV_ATTRIBUTE14 VARCHAR2 (150)
POV_ATTRIBUTE15 VARCHAR2 (150)
POV_ATTRIBUTE2 VARCHAR2 (150)
POV_ATTRIBUTE3 VARCHAR2 (150)
POV_ATTRIBUTE4 VARCHAR2 (150)
POV_ATTRIBUTE5 VARCHAR2 (150)
POV_ATTRIBUTE6 VARCHAR2 (150)
POV_ATTRIBUTE7 VARCHAR2 (150)
POV_ATTRIBUTE8 VARCHAR2 (150)
POV_ATTRIBUTE9 VARCHAR2 (150)
POV_VENDOR_NAME_ALT VARCHAR2 (320)
POV_VENDOR_ID NUMBER

POV_SEGMENT1 VARCHAR2 (30)
POV_VENDOR_NAME VARCHAR2 (360)
POV_SEGMENT2 VARCHAR2 (30)
POV_SEGMENT3 VARCHAR2 (30)
POV_SEGMENT4 VARCHAR2 (30)
POV_SEGMENT5 VARCHAR2 (30)
POV_MERCHANT_TYPE_LOOKUP_CODE VARCHAR2 (30)
POV_GLOBAL_ATTRIBUTE_1 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_2 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_3 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_4 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_5 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_6 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_7 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_8 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_9 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_10 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_11 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_12 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_13 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_14 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_15 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_16 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_17 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_18 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_19 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_20 VARCHAR2 (150)
POV_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
POV_NUM_1099 VARCHAR2 (30)
PARTY_ID NUMBER

POS_ATTRIBUTE1 VARCHAR2 (150)
POS_ATTRIBUTE10 VARCHAR2 (150)
POS_ATTRIBUTE11 VARCHAR2 (150)
POS_ATTRIBUTE12 VARCHAR2 (150)
POS_ATTRIBUTE13 VARCHAR2 (150)
POS_ATTRIBUTE14 VARCHAR2 (150)
POS_ATTRIBUTE15 VARCHAR2 (150)
POS_ATTRIBUTE2 VARCHAR2 (150)
POS_ATTRIBUTE3 VARCHAR2 (150)
POS_ATTRIBUTE4 VARCHAR2 (150)
POS_ATTRIBUTE5 VARCHAR2 (150)
POS_ATTRIBUTE6 VARCHAR2 (150)
POS_ATTRIBUTE7 VARCHAR2 (150)
POS_ATTRIBUTE8 VARCHAR2 (150)
POS_ATTRIBUTE9 VARCHAR2 (150)
POS_ATTRIBUTE_CATEGORY VARCHAR2 (30)
POS_ADDRESS_LINE1 VARCHAR2 (240)
POS_ADDRESS_LINE2 VARCHAR2 (240)
POS_ADDRESS_LINE3 VARCHAR2 (240)
POS_ADDRESS_LINE4 VARCHAR2 (240)
POS_ADDRESS_LINES_ALT VARCHAR2 (560)
POS_CITY VARCHAR2 (60)
POS_COUNTY VARCHAR2 (150)
POS_COUNTRY VARCHAR2 (60)
POS_VENDOR_SITE_CODE VARCHAR2 (15)
POS_ZIP VARCHAR2 (20)
POS_PROVINCE VARCHAR2 (150)
POS_STATE VARCHAR2 (150)
POS_VENDOR_SITE_ID NUMBER

POS_GLOBAL_ATTRIBUTE_1 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_2 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_3 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_4 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_5 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_6 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_7 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_8 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_9 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_10 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_11 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_12 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_13 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_14 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_15 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_16 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_17 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_18 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_19 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_20 VARCHAR2 (150)
POS_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
POS_FDP_CCID NUMBER

POS_PARTY_SITE_ID NUMBER

POS_ORG_ID NUMBER

POS_VENDOR_ID NUMBER

CGAC_GAIN_CCID NUMBER (15)
CGAC_LOSS_CCID NUMBER (15)
PAYMENT_PROCESSING_TYPE VARCHAR2 (30)
PAYCARD_ACCRUED_ACCOUNT_CCID NUMBER (15)
Query Text

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


SELECT EVENT_ID
,      PAYMENT_TRANSACTION_NUMBER
,      PAYMENT_TYPE
,      PAYMENT_DOCUMENT_TYPE
,      PAYMENT_DOCUMENT_SEQUENCE_ID
,      DOC_SEQUENCE_NAME
,      THIRD_PARTY_TYPE
,      CBA_POOLED_BANK_ACOUNT_FLAG
,      AC_CHECK_ID
,      AC_PROVINCE
,      AC_ACTUAL_VALUE_DATE
,      AC_ADDRESS_LINE_1
,      AC_ADDRESS_LINE_2
,      AC_ADDRESS_LINE_3
,      AC_ADDRESS_LINE_4
,      AC_AMOUNT
,      AC_ATTRIBUTE_CATEGORY
,      AC_ATTRIBUTE1
,      AC_ATTRIBUTE10
,      AC_ATTRIBUTE11
,      AC_ATTRIBUTE12
,      AC_ATTRIBUTE13
,      AC_ATTRIBUTE14
,      AC_ATTRIBUTE15
,      AC_ATTRIBUTE2
,      AC_ATTRIBUTE3
,      AC_ATTRIBUTE4
,      AC_ATTRIBUTE5
,      AC_ATTRIBUTE6
,      AC_ATTRIBUTE7
,      AC_ATTRIBUTE8
,      AC_ATTRIBUTE9
,      AC_CHECK_DATE
,      AC_CHECK_VOUCHER_NUMBER
,      AC_CHECKRUN_NAME
,      AC_CITY
,      AC_COUNTRY
,      AC_COUNTY
,      AC_DESCRIPTION
,      AC_DOC_CATEGORY_CODE
,      AC_DOC_SEQUENCE_VALUE
,      AC_FUTURE_PAY_DUE_DATE
,      AC_STATE
,      AC_VENDOR_NAME
,      AC_VOID_DATE
,      AC_ZIP
,      CBA_ACCOUNT_CLASSIFICATION
,      CBA_BANK_ACCOUNT_NAME
,      CBA_BANK_ACCOUNT_NAME_ALT
,      CBA_BANK_ACCOUNT_NUM
,      CBA_BANK_ACCOUNT_TYPE
,      CBA_DESCRIPTION
,      CBA_IBAN_NUMBER
,      AC_VENDOR_ID
,      AC_VENDOR_SITE_ID
,      AC_ORG_ID
,      AC_GLOBAL_ATTRIBUTE_CATEGORY
,      AC_GLOBAL_ATTRIBUTE_1
,      AC_GLOBAL_ATTRIBUTE_2
,      AC_GLOBAL_ATTRIBUTE_3
,      AC_GLOBAL_ATTRIBUTE_4
,      AC_GLOBAL_ATTRIBUTE_5
,      AC_GLOBAL_ATTRIBUTE_6
,      AC_GLOBAL_ATTRIBUTE_7
,      AC_GLOBAL_ATTRIBUTE_8
,      AC_GLOBAL_ATTRIBUTE_9
,      AC_GLOBAL_ATTRIBUTE_10
,      AC_GLOBAL_ATTRIBUTE_11
,      AC_GLOBAL_ATTRIBUTE_12
,      AC_GLOBAL_ATTRIBUTE_13
,      AC_GLOBAL_ATTRIBUTE_14
,      AC_GLOBAL_ATTRIBUTE_15
,      AC_GLOBAL_ATTRIBUTE_16
,      AC_GLOBAL_ATTRIBUTE_17
,      AC_GLOBAL_ATTRIBUTE_18
,      AC_GLOBAL_ATTRIBUTE_19
,      AC_GLOBAL_ATTRIBUTE_20
,      AC_EXTERNAL_BANK_ACCOUNT_ID
,      APH_PAYMENT_HISTORY_ID
,      APH_ACCOUNTING_DATE
,      APH_TRANSACTION_TYPE
,      APH_REV_PMT_HIST_ID
,      APH_BANK_CURR_AMOUNT
,      APH_AMOUNT
,      APH_HISTORICAL_FLAG
,      CGAC_CASH_CLEARING_CCID
,      CGAC_AP_ASSET_CCID
,      CGAC_BANK_CHARGES_CCID
,      CGAC_BANK_ERRORS_CCID
,      CGAC_FUTURE_DATED_PMT_CCID
,      TRANSAC_REVERSAL_FLAG
,      AC_PARTY_ID
,      AC_PARTY_SITE_ID
,      AC_CURRENCY_CODE
,      AC_EXCHANGE_DATE
,      AC_EXCHANGE_RATE
,      AC_EXCHANGE_RATE_TYPE
,      AC_LEDGER_AMOUNT
,      APH_BASE_AMOUNT
,      APH_ERRORS_BASE_AMOUNT
,      APH_CHARGES_BASE_AMOUNT
,      APH_BANK_CURRENCY_CODE
,      APH_BANK_TO_BASE_XRATE_TYPE
,      APH_BANK_TO_BASE_XRATE_DATE
,      APH_BANK_TO_BASE_XRATE
,      APH_PMT_CURRENCY_CODE
,      APH_PMT_TO_BASE_XRATE_TYPE
,      APH_PMT_TO_BASE_XRATE_DATE
,      APH_PMT_TO_BASE_XRATE
,      APH_INVOICE_ADJ_EVENT_ID
,      POV_ATTRIBUTE_CATEGORY
,      POV_ATTRIBUTE1
,      POV_ATTRIBUTE10
,      POV_ATTRIBUTE11
,      POV_ATTRIBUTE12
,      POV_ATTRIBUTE13
,      POV_ATTRIBUTE14
,      POV_ATTRIBUTE15
,      POV_ATTRIBUTE2
,      POV_ATTRIBUTE3
,      POV_ATTRIBUTE4
,      POV_ATTRIBUTE5
,      POV_ATTRIBUTE6
,      POV_ATTRIBUTE7
,      POV_ATTRIBUTE8
,      POV_ATTRIBUTE9
,      POV_VENDOR_NAME_ALT
,      POV_VENDOR_ID
,      POV_SEGMENT1
,      POV_VENDOR_NAME
,      POV_SEGMENT2
,      POV_SEGMENT3
,      POV_SEGMENT4
,      POV_SEGMENT5
,      POV_MERCHANT_TYPE_LOOKUP_CODE
,      POV_GLOBAL_ATTRIBUTE_1
,      POV_GLOBAL_ATTRIBUTE_2
,      POV_GLOBAL_ATTRIBUTE_3
,      POV_GLOBAL_ATTRIBUTE_4
,      POV_GLOBAL_ATTRIBUTE_5
,      POV_GLOBAL_ATTRIBUTE_6
,      POV_GLOBAL_ATTRIBUTE_7
,      POV_GLOBAL_ATTRIBUTE_8
,      POV_GLOBAL_ATTRIBUTE_9
,      POV_GLOBAL_ATTRIBUTE_10
,      POV_GLOBAL_ATTRIBUTE_11
,      POV_GLOBAL_ATTRIBUTE_12
,      POV_GLOBAL_ATTRIBUTE_13
,      POV_GLOBAL_ATTRIBUTE_14
,      POV_GLOBAL_ATTRIBUTE_15
,      POV_GLOBAL_ATTRIBUTE_16
,      POV_GLOBAL_ATTRIBUTE_17
,      POV_GLOBAL_ATTRIBUTE_18
,      POV_GLOBAL_ATTRIBUTE_19
,      POV_GLOBAL_ATTRIBUTE_20
,      POV_GLOBAL_ATTRIBUTE_CATEGORY
,      POV_NUM_1099
,      PARTY_ID
,      POS_ATTRIBUTE1
,      POS_ATTRIBUTE10
,      POS_ATTRIBUTE11
,      POS_ATTRIBUTE12
,      POS_ATTRIBUTE13
,      POS_ATTRIBUTE14
,      POS_ATTRIBUTE15
,      POS_ATTRIBUTE2
,      POS_ATTRIBUTE3
,      POS_ATTRIBUTE4
,      POS_ATTRIBUTE5
,      POS_ATTRIBUTE6
,      POS_ATTRIBUTE7
,      POS_ATTRIBUTE8
,      POS_ATTRIBUTE9
,      POS_ATTRIBUTE_CATEGORY
,      POS_ADDRESS_LINE1
,      POS_ADDRESS_LINE2
,      POS_ADDRESS_LINE3
,      POS_ADDRESS_LINE4
,      POS_ADDRESS_LINES_ALT
,      POS_CITY
,      POS_COUNTY
,      POS_COUNTRY
,      POS_VENDOR_SITE_CODE
,      POS_ZIP
,      POS_PROVINCE
,      POS_STATE
,      POS_VENDOR_SITE_ID
,      POS_GLOBAL_ATTRIBUTE_1
,      POS_GLOBAL_ATTRIBUTE_2
,      POS_GLOBAL_ATTRIBUTE_3
,      POS_GLOBAL_ATTRIBUTE_4
,      POS_GLOBAL_ATTRIBUTE_5
,      POS_GLOBAL_ATTRIBUTE_6
,      POS_GLOBAL_ATTRIBUTE_7
,      POS_GLOBAL_ATTRIBUTE_8
,      POS_GLOBAL_ATTRIBUTE_9
,      POS_GLOBAL_ATTRIBUTE_10
,      POS_GLOBAL_ATTRIBUTE_11
,      POS_GLOBAL_ATTRIBUTE_12
,      POS_GLOBAL_ATTRIBUTE_13
,      POS_GLOBAL_ATTRIBUTE_14
,      POS_GLOBAL_ATTRIBUTE_15
,      POS_GLOBAL_ATTRIBUTE_16
,      POS_GLOBAL_ATTRIBUTE_17
,      POS_GLOBAL_ATTRIBUTE_18
,      POS_GLOBAL_ATTRIBUTE_19
,      POS_GLOBAL_ATTRIBUTE_20
,      POS_GLOBAL_ATTRIBUTE_CATEGORY
,      POS_FDP_CCID
,      POS_PARTY_SITE_ID
,      POS_ORG_ID
,      POS_VENDOR_ID
,      CGAC_GAIN_CCID
,      CGAC_LOSS_CCID
,      PAYMENT_PROCESSING_TYPE
,      PAYCARD_ACCRUED_ACCOUNT_CCID
FROM APPS.AP_PAYMENT_EXTRACT_HEADER_V;

Dependencies

[top of page]

APPS.AP_PAYMENT_EXTRACT_HEADER_V references the following:

SchemaAPPS
SynonymAP_CARDS_ALL
SynonymAP_CARD_PROGRAMS_ALL
SynonymAP_CHECKS_ALL
SynonymAP_PAYMENT_HISTORY_ALL
SynonymAP_SUPPLIERS
SynonymAP_SUPPLIER_SITES_ALL
SynonymCE_BANK_ACCOUNTS
SynonymCE_BANK_ACCT_USES_ALL
SynonymCE_GL_ACCOUNTS_CCID
SynonymFND_DOCUMENT_SEQUENCES
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
ViewIBY_PAYMENT_PROFILES
APPS.AP_PAYMENT_EXTRACT_HEADER_V is referenced by following:

SchemaAPPS
Package BodyFV_SLA_PROCESSING_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000002_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000006_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000010_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000011_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000012_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000020_PKG - show dependent code