[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ITG_SP_PO_LINE_DIST_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  ITG.ITG_SP_PO_LINE_DIST_V
|
| Subobject Name: | |
| Status: | VALID |
This view is used to generate XML at PO line distribution level for Sync PO message
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PO_DISTRIBUTION_ID | NUMBER | Yes | ||
| PO_HEADER_ID | NUMBER | Yes | ||
| PO_LINE_ID | NUMBER | |||
| LINE_LOCATION_ID | NUMBER | |||
| OPERAMT_EXTENDED | NUMBER | |||
| OPERAMT_CURRENCY | VARCHAR2 | (15) | ||
| OPERAMT_UOMVALUE | NUMBER | |||
| OPERAMT_UOM | VARCHAR2 | (3) | ||
| COSTCENTER | VARCHAR2 | (25) | ||
| ELEMENT1 | VARCHAR2 | (25) | ||
| ELEMENT2 | VARCHAR2 | (25) | ||
| ELEMENT3 | VARCHAR2 | (25) | ||
| ELEMENT4 | VARCHAR2 | (25) | ||
| ELEMENT5 | VARCHAR2 | (25) | ||
| ELEMENT6 | VARCHAR2 | (25) | ||
| ELEMENT7 | VARCHAR2 | (25) | ||
| ELEMENT8 | VARCHAR2 | (25) | ||
| ELEMENT9 | VARCHAR2 | (25) | ||
| ELEMENT10 | VARCHAR2 | (25) | ||
| ELEMENT11 | VARCHAR2 | (25) | ||
| ELEMENT12 | VARCHAR2 | (25) | ||
| ELEMENT13 | VARCHAR2 | (25) | ||
| ELEMENT14 | VARCHAR2 | (25) | ||
| ELEMENT15 | VARCHAR2 | (25) | ||
| ELEMENT16 | VARCHAR2 | (25) | ||
| ELEMENT17 | VARCHAR2 | (25) | ||
| ELEMENT18 | VARCHAR2 | (25) | ||
| ELEMENT19 | VARCHAR2 | (25) | ||
| ELEMENT20 | VARCHAR2 | (25) | ||
| ELEMENT21 | VARCHAR2 | (25) | ||
| ELEMENT22 | VARCHAR2 | (25) | ||
| ELEMENT23 | VARCHAR2 | (25) | ||
| ELEMENT24 | VARCHAR2 | (25) | ||
| ELEMENT25 | VARCHAR2 | (25) | ||
| ELEMENT26 | VARCHAR2 | (25) | ||
| ELEMENT27 | VARCHAR2 | (25) | ||
| ELEMENT28 | VARCHAR2 | (25) | ||
| ELEMENT29 | VARCHAR2 | (25) | ||
| ELEMENT30 | VARCHAR2 | (25) | ||
| GLENTITYS | VARCHAR2 | (40) | ||
| GLNOMACCT | VARCHAR2 | (25) | ||
| PROJECT | VARCHAR2 | (40) | ||
| UNIT | VARCHAR2 | (240) | ||
| UA_DISTRID | VARCHAR2 | (40) | ||
| UA_SCHEDLID | VARCHAR2 | (40) | ||
| UA_LINENUM | VARCHAR2 | (40) | ||
| UA_DELIVERTO | VARCHAR2 | (30) | ||
| UA_DIST_ATTR1 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR2 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR3 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR4 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR5 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR6 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR7 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR8 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR9 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR10 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR11 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR12 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR13 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR14 | VARCHAR2 | (150) | ||
| UA_DIST_ATTR15 | VARCHAR2 | (150) | ||
| UA_REQUISITNID | VARCHAR2 | (4000) | ||
| UA_REQLINENUM | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT PO_DISTRIBUTION_ID
, PO_HEADER_ID
, PO_LINE_ID
, LINE_LOCATION_ID
, OPERAMT_EXTENDED
, OPERAMT_CURRENCY
, OPERAMT_UOMVALUE
, OPERAMT_UOM
, COSTCENTER
, ELEMENT1
, ELEMENT2
, ELEMENT3
, ELEMENT4
, ELEMENT5
, ELEMENT6
, ELEMENT7
, ELEMENT8
, ELEMENT9
, ELEMENT10
, ELEMENT11
, ELEMENT12
, ELEMENT13
, ELEMENT14
, ELEMENT15
, ELEMENT16
, ELEMENT17
, ELEMENT18
, ELEMENT19
, ELEMENT20
, ELEMENT21
, ELEMENT22
, ELEMENT23
, ELEMENT24
, ELEMENT25
, ELEMENT26
, ELEMENT27
, ELEMENT28
, ELEMENT29
, ELEMENT30
, GLENTITYS
, GLNOMACCT
, PROJECT
, UNIT
, UA_DISTRID
, UA_SCHEDLID
, UA_LINENUM
, UA_DELIVERTO
, UA_DIST_ATTR1
, UA_DIST_ATTR2
, UA_DIST_ATTR3
, UA_DIST_ATTR4
, UA_DIST_ATTR5
, UA_DIST_ATTR6
, UA_DIST_ATTR7
, UA_DIST_ATTR8
, UA_DIST_ATTR9
, UA_DIST_ATTR10
, UA_DIST_ATTR11
, UA_DIST_ATTR12
, UA_DIST_ATTR13
, UA_DIST_ATTR14
, UA_DIST_ATTR15
, UA_REQUISITNID
, UA_REQLINENUM
FROM APPS.ITG_SP_PO_LINE_DIST_V;
APPS
GL_CODE_COMBINATIONS
HR_GENERAL
- show dependent code
HR_PERSON_NAME
- show dependent code
HR_SECURITY
- show dependent code
ITG_X_UTILS
- show dependent code
MTL_UNITS_OF_MEASURE
ORG_ORGANIZATION_DEFINITIONS
PER_PEOPLE_F
PO_DISTRIBUTIONS_ALL
PO_HEADERS_ALL
PO_LINE_LOCATIONS_ALL
APPS.ITG_SP_PO_LINE_DIST_V is not referenced by any database object
|
|
|
|