eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PN_EXP_PAYMENT_ITEMS_V

Object Details

Object Name:	PN_EXP_PAYMENT_ITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PN.PN_EXP_PAYMENT_ITEMS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
EXPORT_TO_AP_FLAG	VARCHAR2	(1)	Identifies whether this transaction should be exported to Oracle Accounts Payable. Valid values: Y - Export, N - Do not export. The data element is null for a billing item row.
EXPORT_TO_AR_FLAG	VARCHAR2	(1)
TRANSFERRED_TO_AP_FLAG	VARCHAR2	(1)
TRANSFERRED_TO_AR_FLAG	VARCHAR2	(1)
VENDOR_ID	NUMBER
CUSTOMER_ID	NUMBER
VENDOR_SITE_ID	NUMBER
CUSTOMER_SITE_USE_ID	NUMBER
VENDOR_NAME	VARCHAR2	(240)
CUSTOMER_NAME	VARCHAR2	(360)
AP_INVOICE_NUM	VARCHAR2	(50)
AR_TRX_NUM	VARCHAR2	(20)
PAYMENT_PURPOSE	VARCHAR2	(80)
PAYMENT_TYPE	VARCHAR2	(80)
DUE_DATE	DATE
SET_OF_BOOKS_ID	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
EXPORT_CURRENCY_CODE	VARCHAR2	(15)
RATE	NUMBER
ACTUAL_AMOUNT	NUMBER
EXPORT_CURRENCY_AMOUNT	NUMBER
CODE_COMBINATION_ID	NUMBER
COMMENTS	VARCHAR2	(240)
LEASE_ID	NUMBER
LEASE_NAME	VARCHAR2	(50)
LEASE_NUMBER	VARCHAR2	(30)
SCHEDULE_DATE	DATE
PERIOD_NAME	VARCHAR2	(15)
PAYMENT_ITEM_ID	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
PAYMENT_TERM_TYPE_CODE	VARCHAR2	(30)
PAYMENT_SCHEDULE_ID	NUMBER
PAYMENT_TERM_ID	NUMBER
ESTIMATED_AMOUNT	NUMBER
PERIOD_FRACTION	NUMBER
DESCRIPTION	VARCHAR2	(50)
ORG_ID	NUMBER	(15)
PAYMENT_PURPOSE_CODE	VARCHAR2	(30)
REC_LIA_ACCOUNT_ID	NUMBER	(15)
GROUPING_RULE_ID	NUMBER
INV_GROUP_NAME	VARCHAR2	(30)

Query Text

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


SELECT EXPORT_TO_AP_FLAG
,      EXPORT_TO_AR_FLAG
,      TRANSFERRED_TO_AP_FLAG
,      TRANSFERRED_TO_AR_FLAG
,      VENDOR_ID
,      CUSTOMER_ID
,      VENDOR_SITE_ID
,      CUSTOMER_SITE_USE_ID
,      VENDOR_NAME
,      CUSTOMER_NAME
,      AP_INVOICE_NUM
,      AR_TRX_NUM
,      PAYMENT_PURPOSE
,      PAYMENT_TYPE
,      DUE_DATE
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      EXPORT_CURRENCY_CODE
,      RATE
,      ACTUAL_AMOUNT
,      EXPORT_CURRENCY_AMOUNT
,      CODE_COMBINATION_ID
,      COMMENTS
,      LEASE_ID
,      LEASE_NAME
,      LEASE_NUMBER
,      SCHEDULE_DATE
,      PERIOD_NAME
,      PAYMENT_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PAYMENT_TERM_TYPE_CODE
,      PAYMENT_SCHEDULE_ID
,      PAYMENT_TERM_ID
,      ESTIMATED_AMOUNT
,      PERIOD_FRACTION
,      DESCRIPTION
,      ORG_ID
,      PAYMENT_PURPOSE_CODE
,      REC_LIA_ACCOUNT_ID
,      GROUPING_RULE_ID
,      INV_GROUP_NAME
FROM APPS.PN_EXP_PAYMENT_ITEMS_V;

Dependencies

[top of page]

APPS.PN_EXP_PAYMENT_ITEMS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HZ_CUST_ACCOUNTS; HZ_PARTIES; PNP_UTIL_FUNC - show dependent code; PN_DISTRIBUTIONS_ALL; PN_LEASES_ALL; PN_PAYMENT_ITEMS; PN_PAYMENT_SCHEDULES_ALL; PN_PAYMENT_TERMS_ALL; PN_PAY_GROUP_RULES; PO_VENDORS
PUBLIC: DUAL

APPS.PN_EXP_PAYMENT_ITEMS_V is not referenced by any database object