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]

TABLE: PON.PON_EMD_CORPORATE

Object Details

Object Name:	PON_EMD_CORPORATE
Object Type:	TABLE
Owner:	PON
FND Design Data:	PON.PON_EMD_CORPORATE
Subobject Name:
Status:	VALID

This table stores corporate EMD details of suppliers

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CORPORATE_ID	NUMBER	(15)	Yes	Primary key generated by sequence
SUPPLIER_ID	NUMBER	(15)	Yes	Party ID of the supplier who deposited corporate EMD amount
CORPORATE_EMD	NUMBER			The corporate EMD amount deposited by the supplier
CORPORATE_EMD_BALANCE	NUMBER			Corporate EMD balance amount
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
ORG_ID	NUMBER	(15)	Yes	Operating unit in which supplier deposited corporate EMD

Query Text

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


SELECT CORPORATE_ID
,      SUPPLIER_ID
,      CORPORATE_EMD
,      CORPORATE_EMD_BALANCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM PON.PON_EMD_CORPORATE;

Dependencies

[top of page]

PON.PON_EMD_CORPORATE does not reference any database object

PON.PON_EMD_CORPORATE is referenced by following:

PON: PON_EMD_CORPORATE#