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.ITG_SP_REL_POLINE_V

Object Details

Object Name:	ITG_SP_REL_POLINE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ITG.ITG_SP_REL_POLINE_V
Subobject Name:
Status:	VALID

This view is used to generate the PO release line segment in the Sync PO Release XML

[View Source]

Columns

Name	Datatype	Length	Mandatory
PO_HEADER_ID	NUMBER		Yes
PO_LINE_ID	NUMBER		Yes
LINE_LOCATION_ID	NUMBER		Yes
PO_RELEASE_ID	NUMBER		Yes
UNIT_AMOUNT	NUMBER
UNIT_CURRENCY	VARCHAR2	(15)
UNIT_QUANTITY	NUMBER
UNIT_UOM	VARCHAR2	(3)
ORDERED_QUANTITY	NUMBER
POLINENUM	VARCHAR2	(40)
COMMODITY	VARCHAR2	(4000)
CONTRACTS	VARCHAR2	(20)
FRGHTCLS	VARCHAR2	(25)
HAZRDMATL	VARCHAR2	(40)
ITEMRV	VARCHAR2	(3)
ITEMTYPE	VARCHAR2	(240)
NOTES	VARCHAR2	(480)
POENTITY	VARCHAR2	(40)
ITEM	VARCHAR2	(4000)
ITEMX	VARCHAR2	(25)
UA_REF_STATUS	VARCHAR2	(4)
UA_REF_EXP	VARCHAR2	(1)
UA_REF_ATTR	VARCHAR2	(150)
UA_LINE_ATTR1	VARCHAR2	(150)
UA_LINE_ATTR2	VARCHAR2	(150)
UA_LINE_ATTR3	VARCHAR2	(150)
UA_LINE_ATTR4	VARCHAR2	(150)
UA_LINE_ATTR5	VARCHAR2	(150)
UA_LINE_ATTR6	VARCHAR2	(150)
UA_LINE_ATTR7	VARCHAR2	(150)
UA_LINE_ATTR8	VARCHAR2	(150)
UA_LINE_ATTR9	VARCHAR2	(150)
UA_LINE_ATTR10	VARCHAR2	(150)
UA_LINE_ATTR11	VARCHAR2	(150)
UA_LINE_ATTR12	VARCHAR2	(150)
UA_LINE_ATTR13	VARCHAR2	(150)
UA_LINE_ATTR14	VARCHAR2	(150)
UA_LINE_ATTR15	VARCHAR2	(150)
TO_PO_INTERNAL	VARCHAR2	(0)
TO_MISC	VARCHAR2	(0)
TO_APPROVER	VARCHAR2	(0)
TO_BUYER	VARCHAR2	(0)
TO_PAYABLES	VARCHAR2	(0)
TO_RECEIVER	VARCHAR2	(0)
TO_SUPPLIER	VARCHAR2	(0)

Query Text

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


SELECT PO_HEADER_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      PO_RELEASE_ID
,      UNIT_AMOUNT
,      UNIT_CURRENCY
,      UNIT_QUANTITY
,      UNIT_UOM
,      ORDERED_QUANTITY
,      POLINENUM
,      COMMODITY
,      CONTRACTS
,      FRGHTCLS
,      HAZRDMATL
,      ITEMRV
,      ITEMTYPE
,      NOTES
,      POENTITY
,      ITEM
,      ITEMX
,      UA_REF_STATUS
,      UA_REF_EXP
,      UA_REF_ATTR
,      UA_LINE_ATTR1
,      UA_LINE_ATTR2
,      UA_LINE_ATTR3
,      UA_LINE_ATTR4
,      UA_LINE_ATTR5
,      UA_LINE_ATTR6
,      UA_LINE_ATTR7
,      UA_LINE_ATTR8
,      UA_LINE_ATTR9
,      UA_LINE_ATTR10
,      UA_LINE_ATTR11
,      UA_LINE_ATTR12
,      UA_LINE_ATTR13
,      UA_LINE_ATTR14
,      UA_LINE_ATTR15
,      TO_PO_INTERNAL
,      TO_MISC
,      TO_APPROVER
,      TO_BUYER
,      TO_PAYABLES
,      TO_RECEIVER
,      TO_SUPPLIER
FROM APPS.ITG_SP_REL_POLINE_V;

Dependencies

[top of page]

APPS.ITG_SP_REL_POLINE_V references the following:

APPS: ITG_X_UTILS - show dependent code; MTL_CATEGORIES; MTL_SYSTEM_ITEMS; MTL_UNITS_OF_MEASURE; PO_HAZARD_CLASSES_TL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL

APPS.ITG_SP_REL_POLINE_V is not referenced by any database object