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


VIEW: APPS.AP_ENC_GL_PAY_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
JE_HEADER_ID NUMBER (15) Yes
JE_LINE_NUM NUMBER (15) Yes
APPLICATION_ID NUMBER

SET_OF_BOOKS_ID NUMBER (15) Yes
ORG_ID NUMBER (15)
TRX_CLASS CHAR (3)
TRX_CLASS_NAME VARCHAR2 (0)
TRX_TYPE_NAME VARCHAR2 (100) Yes
TRX_TYPE_C VARCHAR2 (25)
TRX_NUMBER_N NUMBER (15) Yes
TRX_NUMBER_DISPLAYED VARCHAR2 (40)
DOC_SEQUENCE_ID NUMBER

DOC_SEQUENCE_NAME VARCHAR2 (0)
DOC_SEQUENCE_VALUE NUMBER

ACCOUNTED_CR NUMBER

ACCOUNTED_DR NUMBER

ENTERED_CR NUMBER

ENTERED_DR NUMBER

ACCOUNTING_DATE DATE

ACCT_LINE_TYPE VARCHAR2 (0)
ACCT_LINE_TYPE_NAME VARCHAR2 (0)
AEH_ID NUMBER

AEL_ID NUMBER

AEL_TABLE VARCHAR2 (0)
AE_LINE_REFERENCE VARCHAR2 (0)
CODE_COMBINATION_ID NUMBER (15) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_USER_CONVERSION_TYPE VARCHAR2 (0)
GL_TRANSFER_STATUS VARCHAR2 (0)
GL_TRANSFER_STATUS_NAME VARCHAR2 (0)
TRANSFER_STATUS_DETAIL_NAME VARCHAR2 (0)
SOURCE_ID NUMBER

SOURCE_TABLE VARCHAR2 (0)
TAX_CODE VARCHAR2 (15)
THIRD_PARTY_TYPE CHAR (8)
THIRD_PARTY_ID NUMBER

THIRD_PARTY_NUMBER VARCHAR2 (30) Yes
THIRD_PARTY_NAME VARCHAR2 (240)
THIRD_PARTY_SUB_ID VARCHAR2 (0)
THIRD_PARTY_SUB_NAME VARCHAR2 (0)
TRX_DATE DATE
Yes
TRX_HDR_ID NUMBER (15) Yes
TRX_HDR_TABLE CHAR (3)
JE_CATEGORY VARCHAR2 (25) Yes
USER_JE_CATEGORY_NAME VARCHAR2 (0)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

ACCOUNTING_EVENT_NUMBER NUMBER

ACCOUNTING_EVENT_TYPE VARCHAR2 (0)
ACCOUNTING_EVENT_TYPE_NAME VARCHAR2 (0)
ACCOUNTING_LINE_NUMBER NUMBER

COMMENTS VARCHAR2 (240)
TRX_TYPE_C_I VARCHAR2 (25)
APPLIED_TO_TRX_HDR_NUMBER_DISP VARCHAR2 (50) Yes
APPLIED_TO_TRX_HDR_NUMBER_C VARCHAR2 (50) Yes
AEH_ACCOUNTING_ERROR_CODE VARCHAR2 (0)
AEH_ACCOUNTING_ERROR_NAME VARCHAR2 (0)
AEL_ACCOUNTING_ERROR_CODE VARCHAR2 (0)
AEL_ACCOUNTING_ERROR_NAME VARCHAR2 (0)
TRX_HDR_CURRENCY VARCHAR2 (15) Yes
BANK_ACCOUNT_NAME VARCHAR2 (80) Yes
APPLIED_TO_TRX_HDR_TABLE CHAR (11)
APPLIED_TO_TRX_HDR_ID NUMBER (15) Yes
APPLIED_TO_TRX_DATE DATE

APPLIED_TO_TRX_HDR_CURRENCY VARCHAR2 (15) Yes
TRX_LINE_NUMBER NUMBER (15)
TRX_LINE_TYPE VARCHAR2 (25) Yes
TRX_LINE_TYPE_NAME VARCHAR2 (80) Yes
PO_ORDER_NUMBER VARCHAR2 (20)
PO_ORDER_RELEASE_NUM NUMBER

RCV_RECEIPT_NUM NUMBER

PAYMENT_CLEARED_DATE DATE

BANK_STATEMENT_NUMBER VARCHAR2 (50)
PAYMENT_RECON_CURRENCY VARCHAR2 (0)
BANK_STATEMENT_LINE_NUMBER VARCHAR2 (0)
BANK_STATEMENT_DOC_SEQ_ID NUMBER

BANK_STATEMENT_DOC_SEQ_NAME VARCHAR2 (0)
BANK_STATEMENT_DOC_SEQ_VALUE NUMBER

Query Text

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


SELECT JE_HEADER_ID
,      JE_LINE_NUM
,      APPLICATION_ID
,      SET_OF_BOOKS_ID
,      ORG_ID
,      TRX_CLASS
,      TRX_CLASS_NAME
,      TRX_TYPE_NAME
,      TRX_TYPE_C
,      TRX_NUMBER_N
,      TRX_NUMBER_DISPLAYED
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_NAME
,      DOC_SEQUENCE_VALUE
,      ACCOUNTED_CR
,      ACCOUNTED_DR
,      ENTERED_CR
,      ENTERED_DR
,      ACCOUNTING_DATE
,      ACCT_LINE_TYPE
,      ACCT_LINE_TYPE_NAME
,      AEH_ID
,      AEL_ID
,      AEL_TABLE
,      AE_LINE_REFERENCE
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_USER_CONVERSION_TYPE
,      GL_TRANSFER_STATUS
,      GL_TRANSFER_STATUS_NAME
,      TRANSFER_STATUS_DETAIL_NAME
,      SOURCE_ID
,      SOURCE_TABLE
,      TAX_CODE
,      THIRD_PARTY_TYPE
,      THIRD_PARTY_ID
,      THIRD_PARTY_NUMBER
,      THIRD_PARTY_NAME
,      THIRD_PARTY_SUB_ID
,      THIRD_PARTY_SUB_NAME
,      TRX_DATE
,      TRX_HDR_ID
,      TRX_HDR_TABLE
,      JE_CATEGORY
,      USER_JE_CATEGORY_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ACCOUNTING_EVENT_NUMBER
,      ACCOUNTING_EVENT_TYPE
,      ACCOUNTING_EVENT_TYPE_NAME
,      ACCOUNTING_LINE_NUMBER
,      COMMENTS
,      TRX_TYPE_C_I
,      APPLIED_TO_TRX_HDR_NUMBER_DISP
,      APPLIED_TO_TRX_HDR_NUMBER_C
,      AEH_ACCOUNTING_ERROR_CODE
,      AEH_ACCOUNTING_ERROR_NAME
,      AEL_ACCOUNTING_ERROR_CODE
,      AEL_ACCOUNTING_ERROR_NAME
,      TRX_HDR_CURRENCY
,      BANK_ACCOUNT_NAME
,      APPLIED_TO_TRX_HDR_TABLE
,      APPLIED_TO_TRX_HDR_ID
,      APPLIED_TO_TRX_DATE
,      APPLIED_TO_TRX_HDR_CURRENCY
,      TRX_LINE_NUMBER
,      TRX_LINE_TYPE
,      TRX_LINE_TYPE_NAME
,      PO_ORDER_NUMBER
,      PO_ORDER_RELEASE_NUM
,      RCV_RECEIPT_NUM
,      PAYMENT_CLEARED_DATE
,      BANK_STATEMENT_NUMBER
,      PAYMENT_RECON_CURRENCY
,      BANK_STATEMENT_LINE_NUMBER
,      BANK_STATEMENT_DOC_SEQ_ID
,      BANK_STATEMENT_DOC_SEQ_NAME
,      BANK_STATEMENT_DOC_SEQ_VALUE
FROM APPS.AP_ENC_GL_PAY_V;

Dependencies

[top of page]

APPS.AP_ENC_GL_PAY_V references the following:

SchemaAPPS
SynonymAP_CHECKS_ALL
SynonymAP_ENCUMBRANCE_LINES_ALL
SynonymAP_INVOICES_ALL
SynonymAP_INVOICE_DISTRIBUTIONS_ALL
ViewAP_LOOKUP_CODES
SynonymAP_TAX_CODES_ALL
SynonymCE_STATEMENT_HEADERS
SynonymCE_STATEMENT_LINES
ViewCE_STATEMENT_RECONCILIATIONS
PL/SQL PackageFND_ACCESS_CONTROL_UTIL - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
SynonymGL_IMPORT_REFERENCES
SynonymGL_JE_HEADERS
SynonymGL_JE_LINES
ViewGL_LOOKUPS
ViewIBY_PAYMENT_METHODS_VL
PL/SQL PackageMO_GLOBAL - show dependent code
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
ViewPO_VENDORS
PL/SQL PackageXTR_USER_ACCESS - show dependent code
APPS.AP_ENC_GL_PAY_V is referenced by following:

SchemaAPPS
ViewXLA_AP_ENC_GL_PAY_V