[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ITG_REQ_DISTRIBUTIONS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  ITG.ITG_REQ_DISTRIBUTIONS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used for generating XML at requisition distribution level
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REQUISITION_HEADER_ID | NUMBER | Yes | ||
| REQ_LINE_ID | NUMBER | Yes | ||
| DISTRIBUTION_NUM | NUMBER | Yes | ||
| QUANTITY_ITEM | NUMBER | |||
| PROPERTY1 | VARCHAR2 | (25) | ||
| PROPERTY2 | VARCHAR2 | (25) | ||
| PROPERTY3 | VARCHAR2 | (25) | ||
| PROPERTY4 | VARCHAR2 | (25) | ||
| PROPERTY5 | VARCHAR2 | (25) | ||
| PROPERTY6 | VARCHAR2 | (25) | ||
| PROPERTY7 | VARCHAR2 | (25) | ||
| PROPERTY8 | VARCHAR2 | (25) | ||
| PROPERTY9 | VARCHAR2 | (25) | ||
| PROPERTY10 | VARCHAR2 | (25) | ||
| PROPERTY11 | VARCHAR2 | (25) | ||
| PROPERTY12 | VARCHAR2 | (25) | ||
| PROPERTY13 | VARCHAR2 | (25) | ||
| PROPERTY14 | VARCHAR2 | (25) | ||
| PROPERTY15 | VARCHAR2 | (25) | ||
| PROPERTY16 | VARCHAR2 | (25) | ||
| PROPERTY17 | VARCHAR2 | (25) | ||
| PROPERTY18 | VARCHAR2 | (25) | ||
| PROPERTY19 | VARCHAR2 | (25) | ||
| PROPERTY20 | VARCHAR2 | (25) | ||
| PROPERTY21 | VARCHAR2 | (25) | ||
| PROPERTY22 | VARCHAR2 | (25) | ||
| PROPERTY23 | VARCHAR2 | (25) | ||
| PROPERTY24 | VARCHAR2 | (25) | ||
| PROPERTY25 | VARCHAR2 | (25) | ||
| PROPERTY26 | VARCHAR2 | (25) | ||
| PROPERTY27 | VARCHAR2 | (25) | ||
| PROPERTY28 | VARCHAR2 | (25) | ||
| PROPERTY29 | VARCHAR2 | (25) | ||
| PROPERTY30 | VARCHAR2 | (25) | ||
| DISTRIBUTION_ITEM | VARCHAR2 | (4000) | ||
| DESCRIPTN | VARCHAR2 | (240) | Yes | |
| DISTLINE_UA_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| DISTLINE_UA_ATTRIBUTE15 | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT REQUISITION_HEADER_ID
, REQ_LINE_ID
, DISTRIBUTION_NUM
, QUANTITY_ITEM
, PROPERTY1
, PROPERTY2
, PROPERTY3
, PROPERTY4
, PROPERTY5
, PROPERTY6
, PROPERTY7
, PROPERTY8
, PROPERTY9
, PROPERTY10
, PROPERTY11
, PROPERTY12
, PROPERTY13
, PROPERTY14
, PROPERTY15
, PROPERTY16
, PROPERTY17
, PROPERTY18
, PROPERTY19
, PROPERTY20
, PROPERTY21
, PROPERTY22
, PROPERTY23
, PROPERTY24
, PROPERTY25
, PROPERTY26
, PROPERTY27
, PROPERTY28
, PROPERTY29
, PROPERTY30
, DISTRIBUTION_ITEM
, DESCRIPTN
, DISTLINE_UA_ATTRIBUTE1
, DISTLINE_UA_ATTRIBUTE2
, DISTLINE_UA_ATTRIBUTE3
, DISTLINE_UA_ATTRIBUTE4
, DISTLINE_UA_ATTRIBUTE5
, DISTLINE_UA_ATTRIBUTE6
, DISTLINE_UA_ATTRIBUTE7
, DISTLINE_UA_ATTRIBUTE8
, DISTLINE_UA_ATTRIBUTE9
, DISTLINE_UA_ATTRIBUTE10
, DISTLINE_UA_ATTRIBUTE11
, DISTLINE_UA_ATTRIBUTE12
, DISTLINE_UA_ATTRIBUTE13
, DISTLINE_UA_ATTRIBUTE14
, DISTLINE_UA_ATTRIBUTE15
FROM APPS.ITG_REQ_DISTRIBUTIONS_V;
APPS
GL_CODE_COMBINATIONS
ITG_X_UTILS
- show dependent code
MTL_SYSTEM_ITEMS
PO_REQUISITION_LINES_ALL
PO_REQ_DISTRIBUTIONS_ALL
APPS.ITG_REQ_DISTRIBUTIONS_V is not referenced by any database object
|
|
|
|