[Home] [Help] [Dependency Information]
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
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
APPS.ITG_SP_REL_POLINE_V is not referenced by any database object
|
|
|