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

VIEW: APPS.OE_AK_HEADER_PAYMENTS_V

Object Details
Object Name: OE_AK_HEADER_PAYMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_AK_HEADER_PAYMENTS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PAYMENT_COLLECTION_EVENT VARCHAR2 (30)
CREDIT_CARD_APPROVAL_DATE DATE

TANGIBLE_ID VARCHAR2 (80)
CHECK_NUMBER VARCHAR2 (50)
PAYMENT_AMOUNT NUMBER

CREDIT_CARD_APPROVAL_CODE VARCHAR2 (80)
RECEIPT_METHOD_ID NUMBER

PAYMENT_TRX_ID NUMBER

Payment id
COMMITMENT_APPLIED_AMOUNT NUMBER

Commitment Id
COMMITMENT_INTERFACED_AMOUNT NUMBER

Commitment amount
PAYMENT_LEVEL_CODE VARCHAR2 (30) Yes Payment level code
HEADER_ID NUMBER
Yes Header id
LINE_ID NUMBER

Line id
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent program internal request id
PROGRAM_APPLICATION_ID NUMBER

Concurrent program id
PROGRAM_ID NUMBER

Concurrent program id.
PROGRAM_UPDATE_DATE DATE

Concurrent program that last updated row.
CONTEXT VARCHAR2 (30)
Descriptive flex-field segment
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flex-field segment
PAYMENT_TYPE_CODE VARCHAR2 (30)
Stores the type of payment. Possible values for now: COMMITMENT, CREDIT_CARD or Null. Null is equivalent to COMMITMENT.
CREDIT_CARD_CODE VARCHAR2 (80)
Stores Credit Card Type.
CREDIT_CARD_NUMBER VARCHAR2 (80)
Stores Credit Card Number.
CREDIT_CARD_HOLDER_NAME VARCHAR2 (80)
Stores Credit Card Holder Name
CREDIT_CARD_EXPIRATION_DATE DATE

Stores Credit Card Expiration Date
PREPAID_AMOUNT NUMBER

Stores total of amount successfully collected (including refund) for the entire order.
PAYMENT_SET_ID NUMBER

This is unique number to group payments belonging to one prepaid order. Foreign Key reference to AR.
PAYMENT_NUMBER NUMBER

LOCK_CONTROL NUMBER

RETURN_STATUS VARCHAR2 (1)
DB_FLAG VARCHAR2 (1)
OPERATION VARCHAR2 (30)
Query Text

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


SELECT PAYMENT_COLLECTION_EVENT
,      CREDIT_CARD_APPROVAL_DATE
,      TANGIBLE_ID
,      CHECK_NUMBER
,      PAYMENT_AMOUNT
,      CREDIT_CARD_APPROVAL_CODE
,      RECEIPT_METHOD_ID
,      PAYMENT_TRX_ID
,      COMMITMENT_APPLIED_AMOUNT
,      COMMITMENT_INTERFACED_AMOUNT
,      PAYMENT_LEVEL_CODE
,      HEADER_ID
,      LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PAYMENT_TYPE_CODE
,      CREDIT_CARD_CODE
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_EXPIRATION_DATE
,      PREPAID_AMOUNT
,      PAYMENT_SET_ID
,      PAYMENT_NUMBER
,      LOCK_CONTROL
,      RETURN_STATUS
,      DB_FLAG
,      OPERATION
FROM APPS.OE_AK_HEADER_PAYMENTS_V;

Dependencies

[top of page]

APPS.OE_AK_HEADER_PAYMENTS_V references the following:

SchemaAPPS
SynonymOE_PAYMENTS
APPS.OE_AK_HEADER_PAYMENTS_V is referenced by following:

SchemaAPPS
Package BodyOE_1024PC1_ORDER_AHLORD - show dependent code
Package BodyOE_1024PC1_ORDER_BOOKED - show dependent code
Package BodyOE_1024PC1_ORDER_CANORD - show dependent code
Package BodyOE_1024PC1_ORDER_CLOSED - show dependent code
Package BodyOE_1024PC1_ORDER_CUSTACC - show dependent code
Package BodyOE_1024PC1_ORDER_CUSTREJ - show dependent code
Package BodyOE_1024PC1_ORDER_CUSTSIG - show dependent code
Package BodyOE_1024PC1_ORDER_DEALAPP - show dependent code
Package BodyOE_1024PC1_ORDER_DEALSUB - show dependent code
Package BodyOE_1024PC1_ORDER_DRAFSUB - show dependent code
Package BodyOE_1024PC1_ORDER_DRAFT - show dependent code
Package BodyOE_1024PC1_ORDER_ENTER - show dependent code
Package BodyOE_1024PC1_ORDER_HDRINVC - show dependent code
Package BodyOE_1024PC1_ORDER_INTAPPR - show dependent code
Package BodyOE_1024PC1_ORDER_INTORD - show dependent code
Package BodyOE_1024PC1_ORDER_INTREJ - show dependent code
Package BodyOE_1024PC1_ORDER_LOST - show dependent code
Package BodyOE_1024PC1_ORDER_NEGCOMP - show dependent code
Package BodyOE_1024PC1_ORDER_OFFEXP - show dependent code
Package BodyOE_1024PC1_ORDER_PENAPPR - show dependent code
Package BodyOE_1024PC1_ORDER_PENCUSA - show dependent code
Package BodyOE_1024PC1_ORDER_REGORD - show dependent code
Package BodyOE_1024PC1_ORDER_RETAPVD - show dependent code
Package BodyOE_1024PC1_ORDER_RETORD - show dependent code
Package BodyOE_1024PC1_ORDER_RETREJD - show dependent code
Package BodyOE_DEFAULT_HEADER_PAYMENT - show dependent code
Package BodyOE_DEFAULT_PVT - show dependent code
PL/SQL PackageOE_HEADER_PAYMENT_CL_DEP_ATTR - show dependent code
Package BodyOE_HEADER_PAYMENT_CL_DEP_ATTR - show dependent code
PL/SQL PackageOE_HEADER_PAYMENT_SECURITY - show dependent code
Package BodyOE_HEADER_PAYMENT_SECURITY - show dependent code
PL/SQL PackageOE_HEADER_PAYMENT_UTIL - show dependent code
Package BodyOE_HEADER_PAYMENT_UTIL - show dependent code
Package BodyOE_INVOICE_PUB - show dependent code
Package BodyOE_PREPAYMENT_UTIL - show dependent code
Package BodyONT_D1024_CREDIT_CARD_EXPIRATI - show dependent code
PL/SQL PackageONT_D1024_CREDIT_CARD_EXPIRATI - show dependent code
Package BodyONT_D1024_CREDIT_CARD_HOLDER_N - show dependent code
PL/SQL PackageONT_D1024_CREDIT_CARD_HOLDER_N - show dependent code
PL/SQL PackageONT_D1024_CREDIT_CARD_NUMBER - show dependent code
Package BodyONT_D1024_CREDIT_CARD_NUMBER - show dependent code
Package BodyONT_D1024_PAYMENT_TYPE_CODE - show dependent code
PL/SQL PackageONT_D1024_PAYMENT_TYPE_CODE - show dependent code
PL/SQL PackageONT_D1024_RECEIPT_METHOD_ID - show dependent code
Package BodyONT_D1024_RECEIPT_METHOD_ID - show dependent code
Package BodyONT_HEADER_PAYMENT_DEF_HDLR - show dependent code
PL/SQL PackageONT_HEADER_PAYMENT_DEF_HDLR - show dependent code
Package BodyONT_HEADER_PAYMENT_DEF_UTIL - show dependent code
PL/SQL PackageONT_HEADER_PAYMENT_DEF_UTIL - show dependent code