Skip to content

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

VIEW: APPS.AP_PREPAYAPP_EXTRACT_DTLS_BC_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (15)
LINE_NUMBER NUMBER (15) Yes
DEFERRED_OPTION VARCHAR2 (1)
DEFERRED_START_DATE DATE

DEFERRED_END_DATE DATE

DEFERRED_NUMBER_OF_PERIODS NUMBER

DEFERRED_PERIOD_TYPE VARCHAR2 (30)
APAD_DISTRIBUTION_IDENTIFIER NUMBER (15) Yes
DIST_ACCOUNT_REVERSAL_OPTION VARCHAR2 (1)
APAD_DIST_LOOKUP_CODE VARCHAR2 (30) Yes
APAD_INVOICE_ADJ_EVENT_ID NUMBER (15)
APPH_PREPAY_INVOICE_ID NUMBER (15) Yes
APAD_AMOUNT NUMBER

PREPAY_PAY_CURRENCY_CODE VARCHAR2 (15) Yes
PREPAY_CLEAR_CURRENCY_CODE VARCHAR2 (15)
AIL_LINE_NUMBER NUMBER
Yes
AIL_LINE_TYPE_LOOKUP_CODE VARCHAR2 (25) Yes
AIL_ACCOUNT_SEGMENT VARCHAR2 (25)
AIL_BALANCING_SEGMENT VARCHAR2 (25)
AIL_COST_CENTER_SEGMENT VARCHAR2 (25)
AIL_OVERLAY_DIST_CODE_CONCAT VARCHAR2 (250)
AIL_DEFAULT_DIST_CCID NUMBER (15)
AIL_ACCOUNTING_DATE DATE
Yes
AIL_PERIOD_NAME VARCHAR2 (15)
AIL_AMOUNT NUMBER
Yes
AIL_ROUNDING_AMT NUMBER

AIL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
AIL_ATTRIBUTE1 VARCHAR2 (150)
AIL_ATTRIBUTE2 VARCHAR2 (150)
AIL_ATTRIBUTE3 VARCHAR2 (150)
AIL_ATTRIBUTE4 VARCHAR2 (150)
AIL_ATTRIBUTE5 VARCHAR2 (150)
AIL_ATTRIBUTE6 VARCHAR2 (150)
AIL_ATTRIBUTE7 VARCHAR2 (150)
AIL_ATTRIBUTE8 VARCHAR2 (150)
AIL_ATTRIBUTE9 VARCHAR2 (150)
AIL_ATTRIBUTE10 VARCHAR2 (150)
AIL_ATTRIBUTE11 VARCHAR2 (150)
AIL_ATTRIBUTE12 VARCHAR2 (150)
AIL_ATTRIBUTE13 VARCHAR2 (150)
AIL_ATTRIBUTE14 VARCHAR2 (150)
AIL_ATTRIBUTE15 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
AIL_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
SUMMARY_TAX_LINE_ID NUMBER

AID_ACCOUNTING_DATE DATE
Yes
AID_DISTRIBUTION_LINE_NUMBER NUMBER (15) Yes
AID_LINE_TYPE_LOOKUP_CODE VARCHAR2 (25) Yes
AID_PERIOD_NAME VARCHAR2 (15) Yes
AID_ACCTS_PAY_CCID NUMBER (15)
AID_DIST_CCID NUMBER (15) Yes
AID_DESCRIPTION VARCHAR2 (240)
AID_EXCHANGE_RATE_VARIANCE NUMBER

AID_INVOICE_PRICE_VARIANCE NUMBER

AID_RATE_VAR_CCID NUMBER (15)
AID_REVERSAL_FLAG VARCHAR2 (1)
AID_AMOUNT_ENCUMBERED NUMBER

AID_ENCUMBERED_FLAG VARCHAR2 (1)
AID_EXCHANGE_DATE DATE

AID_EXCHANGE_RATE NUMBER

AID_EXCHANGE_RATE_TYPE VARCHAR2 (30)
AID_STAT_AMOUNT NUMBER

AID_ATTRIBUTE1 VARCHAR2 (150)
AID_ATTRIBUTE10 VARCHAR2 (150)
AID_ATTRIBUTE11 VARCHAR2 (150)
AID_ATTRIBUTE12 VARCHAR2 (150)
AID_ATTRIBUTE13 VARCHAR2 (150)
AID_ATTRIBUTE14 VARCHAR2 (150)
AID_ATTRIBUTE15 VARCHAR2 (150)
AID_ATTRIBUTE2 VARCHAR2 (150)
AID_ATTRIBUTE3 VARCHAR2 (150)
AID_ATTRIBUTE4 VARCHAR2 (150)
AID_ATTRIBUTE5 VARCHAR2 (150)
AID_ATTRIBUTE6 VARCHAR2 (150)
AID_ATTRIBUTE7 VARCHAR2 (150)
AID_ATTRIBUTE8 VARCHAR2 (150)
AID_ATTRIBUTE9 VARCHAR2 (150)
AID_ATTRIBUTE_CATEGORY VARCHAR2 (150)
AID_PARENT_INVOICE_ID NUMBER (15)
AID_GLOBAL_ATTRIBUTE_CAT VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
AID_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
AID_MERCHANT_DOCUMENT_NUMBER VARCHAR2 (80)
AID_MERCHANT_NAME VARCHAR2 (80)
AID_PREPAY_DISTRIBUTION_ID NUMBER (15)
AID_INV_INCLUDES_PREPAY_FLAG VARCHAR2 (1)
AID_INVOICE_LINE_NUMBER NUMBER

AID_ROUNDING_AMOUNT NUMBER

AID_AMT_AT_PREPAY_PAY_XRATE NUMBER

AID_PREPAY_TAX_PARENT_ID NUMBER (15)
REVERSED_PREPAY_APP_DIST_ID NUMBER (15)
INV_DIST_BASE_AMOUNT NUMBER

INV_ENTERED_AMOUNT NUMBER

AID_INVOICE_DIST_ID NUMBER (15) Yes
AID_DETAIL_TAX_DIST_ID NUMBER

APAD_PREPAY_XDATE DATE

APAD_PREPAY_PAY_XDATE DATE

APAD_PREPAY_XRATE NUMBER

APAD_PREPAY_PAY_XRATE NUMBER

APAD_PREPAY_XRATE_TYPE VARCHAR2 (30)
APAD_PREPAY_PAY_XRATE_TYPE VARCHAR2 (30)
APAD_PREPAY_CLR_XRATE NUMBER

APAD_PREPAY_CLR_XRATE_TYPE VARCHAR2 (30)
APAD_PREPAY_CLR_XDATE DATE

BASE_AMT_AT_PP_CLR_XRATE NUMBER

BASE_AMT_AT_PP_XRATE NUMBER

BASE_AMT_AT_PP_PAY_XRATE NUMBER

APAD_BASE_AMOUNT NUMBER

APAD_ROUNDING_AMOUNT NUMBER

APAD_BASE_AMT_NO_ROUND NUMBER

APAD_BASE_AMOUNT_DIFF NUMBER

INV_PREPMT_GAIN_LOSS_INDICATOR VARCHAR2 (4)
PO_DISTRIBUTION_ID NUMBER (15)
AID_PO_DISTRIBUTION_ID NUMBER (15)
BUS_FLOW_AP_APP_ID NUMBER

BUS_FLOW_INV_DIST_TYPE CHAR (11)
BUS_FLOW_INV_ENTITY_CODE CHAR (11)
BUS_FLOW_INV_DIST_ID NUMBER (15) Yes
BUS_FLOW_INV_ID NUMBER (15) Yes
BUS_FLOW_PO_APP_ID NUMBER

BUS_FLOW_PO_DIST_TYPE CHAR (20)
BUS_FLOW_PO_ENTITY_CODE VARCHAR2 (14)
BUS_FLOW_PO_DOC_ID NUMBER

BF_ACCRUAL_PREPAY_ENTITY_CODE CHAR (11)
BF_CASH_ALWAYS_PREPAY_ENTITY CHAR (11)
BF_CASHCLEARONLY_PREPAY_ENTITY VARCHAR2 (14)
BF_ACCRUAL_PREPAY_DIST_TYPE CHAR (11)
BF_CASH_ALWAYS_PP_DIST_TYPE CHAR (11)
BF_CASHCLEARONLY_PP_DIST_TYPE CHAR (7)
BF_PREPAY_REC_DIST_ID NUMBER (15) Yes
BF_PREPAY_REC_INV NUMBER (15) Yes
BF_ACCRUAL_PP_DIST_ID NUMBER (15)
BF_ACCRUAL_PP_INV NUMBER (15) Yes
BF_CASHALWAYS_PP_PMT_ID NUMBER

BF_CASHALWAYS_PP_PMT_DIST_ID NUMBER

BF_CASHCLEAR_PP_CLEAR_DIST_ID NUMBER

AID_PROJECT_ID NUMBER (15)
AID_TASK_ID NUMBER (15)
AID_EXPENDITURE_TYPE VARCHAR2 (30)
AID_EXPENDITURE_ORG_ID NUMBER (15)
AID_AWARD_ID NUMBER (15)
AID_AMOUNT NUMBER

BF_RET_INV_ASSOC_TO_PP_RECIP NUMBER (15)
BF_RET_DIST_ASSOC_TO_PP_RECIP NUMBER (15)
AI_RECIPIENT_INV_TYPE VARCHAR2 (25)
RECP_INV_DIST_TYPE VARCHAR2 (25) Yes
APAD_PREPAY_APP_DIST_ID NUMBER (15) Yes
RECP_INV_DIST_CCID NUMBER (15) Yes
VARIANCE_PARENT_DIST_ID NUMBER (15)
APAD_QUANTITY_VARIANCE NUMBER

APAD_INV_BASE_QTY_VARIANCE NUMBER

APAD_AMOUNT_VARIANCE NUMBER

APAD_INV_BASE_AMT_VARIANCE NUMBER

RECP_DETAIL_TAX_DIST_ID NUMBER

POD_PO_DISTRIBUTION_ID NUMBER

POD_ENCUMBERED_FLAG VARCHAR2 (1)
POD_ENCUMBERED_AMOUNT NUMBER

POD_GL_ENCUMBERED_DATE DATE

POD_GL_ENCUMBERED_PERIOD_NAME VARCHAR2 (15)
POD_ATTRIBUTE_CATEGORY VARCHAR2 (30)
POD_ATTRIBUTE1 VARCHAR2 (150)
POD_ATTRIBUTE2 VARCHAR2 (150)
POD_ATTRIBUTE3 VARCHAR2 (150)
POD_ATTRIBUTE4 VARCHAR2 (150)
POD_ATTRIBUTE5 VARCHAR2 (150)
POD_ATTRIBUTE6 VARCHAR2 (150)
POD_ATTRIBUTE7 VARCHAR2 (150)
POD_ATTRIBUTE8 VARCHAR2 (150)
POD_ATTRIBUTE9 VARCHAR2 (150)
POD_ATTRIBUTE10 VARCHAR2 (150)
POD_ATTRIBUTE11 VARCHAR2 (150)
POD_ATTRIBUTE12 VARCHAR2 (150)
POD_ATTRIBUTE13 VARCHAR2 (150)
POD_ATTRIBUTE14 VARCHAR2 (150)
POD_ATTRIBUTE15 VARCHAR2 (150)
POD_DISTRIBUTION_NUM NUMBER

POD_ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
POD_CCID NUMBER

PO_VARIANCE_ACCOUNT NUMBER

POD_PO_HEADER_ID NUMBER

POD_PO_LINE_ID NUMBER

POD_LINE_LOCATION_ID NUMBER

UPG_AP_ENCUM_OPTION VARCHAR2 (4000)
UPG_CR_ENC_TYPE_ID VARCHAR2 (4)
UPG_ENC_CR_CCID VARCHAR2 (40)
UPG_ENC_CR_BASE_AMT VARCHAR2 (40)
UPG_ENC_CR_AMT VARCHAR2 (40)
UPG_DR_ENC_TYPE_ID NUMBER (15) Yes
UPG_ENC_DR_CCID NUMBER (15) Yes
UPG_ENC_DR_BASE_AMT NUMBER

UPG_ENC_DR_AMT NUMBER

UPG_ENC_DR_ACCT_CLASS CHAR (15)
UPG_ENC_CR_ACCT_CLASS CHAR (3)
OVERRIDE_ACCTD_AMT_FLAG CHAR (1)
Query Text

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


SELECT EVENT_ID
,      LINE_NUMBER
,      DISTRIBUTION_LINK_TYPE
,      DEFERRED_OPTION
,      DEFERRED_START_DATE
,      DEFERRED_END_DATE
,      DEFERRED_NUMBER_OF_PERIODS
,      DEFERRED_PERIOD_TYPE
,      APAD_DISTRIBUTION_IDENTIFIER
,      DIST_ACCOUNT_REVERSAL_OPTION
,      APAD_DIST_LOOKUP_CODE
,      APAD_INVOICE_ADJ_EVENT_ID
,      APPH_PREPAY_INVOICE_ID
,      APAD_AMOUNT
,      PREPAY_PAY_CURRENCY_CODE
,      PREPAY_CLEAR_CURRENCY_CODE
,      AIL_LINE_NUMBER
,      AIL_LINE_TYPE_LOOKUP_CODE
,      AIL_ACCOUNT_SEGMENT
,      AIL_BALANCING_SEGMENT
,      AIL_COST_CENTER_SEGMENT
,      AIL_OVERLAY_DIST_CODE_CONCAT
,      AIL_DEFAULT_DIST_CCID
,      AIL_ACCOUNTING_DATE
,      AIL_PERIOD_NAME
,      AIL_AMOUNT
,      AIL_ROUNDING_AMT
,      AIL_ATTRIBUTE_CATEGORY
,      AIL_ATTRIBUTE1
,      AIL_ATTRIBUTE2
,      AIL_ATTRIBUTE3
,      AIL_ATTRIBUTE4
,      AIL_ATTRIBUTE5
,      AIL_ATTRIBUTE6
,      AIL_ATTRIBUTE7
,      AIL_ATTRIBUTE8
,      AIL_ATTRIBUTE9
,      AIL_ATTRIBUTE10
,      AIL_ATTRIBUTE11
,      AIL_ATTRIBUTE12
,      AIL_ATTRIBUTE13
,      AIL_ATTRIBUTE14
,      AIL_ATTRIBUTE15
,      AIL_GLOBAL_ATTRIBUTE_CATEGORY
,      AIL_GLOBAL_ATTRIBUTE1
,      AIL_GLOBAL_ATTRIBUTE2
,      AIL_GLOBAL_ATTRIBUTE3
,      AIL_GLOBAL_ATTRIBUTE4
,      AIL_GLOBAL_ATTRIBUTE5
,      AIL_GLOBAL_ATTRIBUTE6
,      AIL_GLOBAL_ATTRIBUTE7
,      AIL_GLOBAL_ATTRIBUTE8
,      AIL_GLOBAL_ATTRIBUTE9
,      AIL_GLOBAL_ATTRIBUTE10
,      AIL_GLOBAL_ATTRIBUTE11
,      AIL_GLOBAL_ATTRIBUTE12
,      AIL_GLOBAL_ATTRIBUTE13
,      AIL_GLOBAL_ATTRIBUTE14
,      AIL_GLOBAL_ATTRIBUTE15
,      AIL_GLOBAL_ATTRIBUTE16
,      AIL_GLOBAL_ATTRIBUTE17
,      AIL_GLOBAL_ATTRIBUTE18
,      AIL_GLOBAL_ATTRIBUTE19
,      AIL_GLOBAL_ATTRIBUTE20
,      SUMMARY_TAX_LINE_ID
,      AID_ACCOUNTING_DATE
,      AID_DISTRIBUTION_LINE_NUMBER
,      AID_LINE_TYPE_LOOKUP_CODE
,      AID_PERIOD_NAME
,      AID_ACCTS_PAY_CCID
,      AID_DIST_CCID
,      AID_DESCRIPTION
,      AID_EXCHANGE_RATE_VARIANCE
,      AID_INVOICE_PRICE_VARIANCE
,      AID_RATE_VAR_CCID
,      AID_REVERSAL_FLAG
,      AID_AMOUNT_ENCUMBERED
,      AID_ENCUMBERED_FLAG
,      AID_EXCHANGE_DATE
,      AID_EXCHANGE_RATE
,      AID_EXCHANGE_RATE_TYPE
,      AID_STAT_AMOUNT
,      AID_ATTRIBUTE1
,      AID_ATTRIBUTE10
,      AID_ATTRIBUTE11
,      AID_ATTRIBUTE12
,      AID_ATTRIBUTE13
,      AID_ATTRIBUTE14
,      AID_ATTRIBUTE15
,      AID_ATTRIBUTE2
,      AID_ATTRIBUTE3
,      AID_ATTRIBUTE4
,      AID_ATTRIBUTE5
,      AID_ATTRIBUTE6
,      AID_ATTRIBUTE7
,      AID_ATTRIBUTE8
,      AID_ATTRIBUTE9
,      AID_ATTRIBUTE_CATEGORY
,      AID_PARENT_INVOICE_ID
,      AID_GLOBAL_ATTRIBUTE_CAT
,      AID_GLOBAL_ATTRIBUTE1
,      AID_GLOBAL_ATTRIBUTE2
,      AID_GLOBAL_ATTRIBUTE3
,      AID_GLOBAL_ATTRIBUTE4
,      AID_GLOBAL_ATTRIBUTE5
,      AID_GLOBAL_ATTRIBUTE6
,      AID_GLOBAL_ATTRIBUTE7
,      AID_GLOBAL_ATTRIBUTE8
,      AID_GLOBAL_ATTRIBUTE9
,      AID_GLOBAL_ATTRIBUTE10
,      AID_GLOBAL_ATTRIBUTE11
,      AID_GLOBAL_ATTRIBUTE12
,      AID_GLOBAL_ATTRIBUTE13
,      AID_GLOBAL_ATTRIBUTE14
,      AID_GLOBAL_ATTRIBUTE15
,      AID_GLOBAL_ATTRIBUTE16
,      AID_GLOBAL_ATTRIBUTE17
,      AID_GLOBAL_ATTRIBUTE18
,      AID_GLOBAL_ATTRIBUTE19
,      AID_GLOBAL_ATTRIBUTE20
,      AID_MERCHANT_DOCUMENT_NUMBER
,      AID_MERCHANT_NAME
,      AID_PREPAY_DISTRIBUTION_ID
,      AID_INV_INCLUDES_PREPAY_FLAG
,      AID_INVOICE_LINE_NUMBER
,      AID_ROUNDING_AMOUNT
,      AID_AMT_AT_PREPAY_PAY_XRATE
,      AID_PREPAY_TAX_PARENT_ID
,      REVERSED_PREPAY_APP_DIST_ID
,      INV_DIST_BASE_AMOUNT
,      INV_ENTERED_AMOUNT
,      AID_INVOICE_DIST_ID
,      AID_DETAIL_TAX_DIST_ID
,      APAD_PREPAY_XDATE
,      APAD_PREPAY_PAY_XDATE
,      APAD_PREPAY_XRATE
,      APAD_PREPAY_PAY_XRATE
,      APAD_PREPAY_XRATE_TYPE
,      APAD_PREPAY_PAY_XRATE_TYPE
,      APAD_PREPAY_CLR_XRATE
,      APAD_PREPAY_CLR_XRATE_TYPE
,      APAD_PREPAY_CLR_XDATE
,      BASE_AMT_AT_PP_CLR_XRATE
,      BASE_AMT_AT_PP_XRATE
,      BASE_AMT_AT_PP_PAY_XRATE
,      APAD_BASE_AMOUNT
,      APAD_ROUNDING_AMOUNT
,      APAD_BASE_AMT_NO_ROUND
,      APAD_BASE_AMOUNT_DIFF
,      INV_PREPMT_GAIN_LOSS_INDICATOR
,      PO_DISTRIBUTION_ID
,      AID_PO_DISTRIBUTION_ID
,      BUS_FLOW_AP_APP_ID
,      BUS_FLOW_INV_DIST_TYPE
,      BUS_FLOW_INV_ENTITY_CODE
,      BUS_FLOW_INV_DIST_ID
,      BUS_FLOW_INV_ID
,      BUS_FLOW_PO_APP_ID
,      BUS_FLOW_PO_DIST_TYPE
,      BUS_FLOW_PO_ENTITY_CODE
,      BUS_FLOW_PO_DOC_ID
,      BF_ACCRUAL_PREPAY_ENTITY_CODE
,      BF_CASH_ALWAYS_PREPAY_ENTITY
,      BF_CASHCLEARONLY_PREPAY_ENTITY
,      BF_ACCRUAL_PREPAY_DIST_TYPE
,      BF_CASH_ALWAYS_PP_DIST_TYPE
,      BF_CASHCLEARONLY_PP_DIST_TYPE
,      BF_PREPAY_REC_DIST_ID
,      BF_PREPAY_REC_INV
,      BF_ACCRUAL_PP_DIST_ID
,      BF_ACCRUAL_PP_INV
,      BF_CASHALWAYS_PP_PMT_ID
,      BF_CASHALWAYS_PP_PMT_DIST_ID
,      BF_CASHCLEAR_PP_CLEAR_DIST_ID
,      AID_PROJECT_ID
,      AID_TASK_ID
,      AID_EXPENDITURE_TYPE
,      AID_EXPENDITURE_ORG_ID
,      AID_AWARD_ID
,      AID_AMOUNT
,      BF_RET_INV_ASSOC_TO_PP_RECIP
,      BF_RET_DIST_ASSOC_TO_PP_RECIP
,      AI_RECIPIENT_INV_TYPE
,      RECP_INV_DIST_TYPE
,      APAD_PREPAY_APP_DIST_ID
,      RECP_INV_DIST_CCID
,      AID_RET_RELATED_DIST_CCID
,      VARIANCE_PARENT_DIST_ID
,      APAD_QUANTITY_VARIANCE
,      APAD_INV_BASE_QTY_VARIANCE
,      APAD_AMOUNT_VARIANCE
,      APAD_INV_BASE_AMT_VARIANCE
,      RECP_DETAIL_TAX_DIST_ID
,      POD_PO_DISTRIBUTION_ID
,      POD_ENCUMBERED_FLAG
,      POD_ENCUMBERED_AMOUNT
,      POD_GL_ENCUMBERED_DATE
,      POD_GL_ENCUMBERED_PERIOD_NAME
,      POD_ATTRIBUTE_CATEGORY
,      POD_ATTRIBUTE1
,      POD_ATTRIBUTE2
,      POD_ATTRIBUTE3
,      POD_ATTRIBUTE4
,      POD_ATTRIBUTE5
,      POD_ATTRIBUTE6
,      POD_ATTRIBUTE7
,      POD_ATTRIBUTE8
,      POD_ATTRIBUTE9
,      POD_ATTRIBUTE10
,      POD_ATTRIBUTE11
,      POD_ATTRIBUTE12
,      POD_ATTRIBUTE13
,      POD_ATTRIBUTE14
,      POD_ATTRIBUTE15
,      POD_DISTRIBUTION_NUM
,      POD_ACCRUE_ON_RECEIPT_FLAG
,      POD_CCID
,      PO_VARIANCE_ACCOUNT
,      RELATED_INV_DIST_DEST_TYPE
,      POD_PO_HEADER_ID
,      POD_PO_LINE_ID
,      POD_LINE_LOCATION_ID
,      UPG_AP_ENCUM_OPTION
,      UPG_CR_ENC_TYPE_ID
,      UPG_ENC_CR_CCID
,      UPG_ENC_CR_BASE_AMT
,      UPG_ENC_CR_AMT
,      UPG_DR_ENC_TYPE_ID
,      UPG_ENC_DR_CCID
,      UPG_ENC_DR_BASE_AMT
,      UPG_ENC_DR_AMT
,      UPG_ENC_DR_ACCT_CLASS
,      UPG_ENC_CR_ACCT_CLASS
,      OVERRIDE_ACCTD_AMT_FLAG
FROM APPS.AP_PREPAYAPP_EXTRACT_DTLS_BC_V;

Dependencies

[top of page]

APPS.AP_PREPAYAPP_EXTRACT_DTLS_BC_V references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
SynonymAP_INVOICE_DISTRIBUTIONS_ALL
SynonymAP_INVOICE_LINES_ALL
SynonymAP_PAYMENT_HISTORY_ALL
SynonymAP_PAYMENT_HIST_DISTS
SynonymAP_PREPAY_APP_DISTS
SynonymAP_PREPAY_HISTORY_ALL
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
SynonymGL_ENCUMBRANCE_TYPES
SynonymPO_DISTRIBUTIONS_ALL
PL/SQL PackagePSA_BC_XLA_PUB - show dependent code
SynonymXLA_EVENTS_GT
APPS.AP_PREPAYAPP_EXTRACT_DTLS_BC_V is referenced by following:

SchemaAPPS
Package BodyXLA_00200_AAD_S_000006_BC_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000010_BC_PKG - show dependent code