[Home] [Help] [Dependency Information]
Object Name: | PO_LINE_LOCATIONS_ALL_EBS# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_LOCATION_ID | NUMBER | Yes | ||
PO_LINE_ID | NUMBER | Yes | ||
PO_HEADER_ID | NUMBER | Yes | ||
PO_RELEASE_ID | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
SHIPMENT_TYPE | VARCHAR2 | (25) | ||
ORG_ID | NUMBER | |||
QUANTITY | NUMBER | |||
QUANTITY_RECEIVED | NUMBER | |||
QUANTITY_BILLED | NUMBER | |||
QUANTITY_CANCELLED | NUMBER | |||
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | ||
PRICE_OVERRIDE | NUMBER | |||
EURO_LINE_LOCATION_ID | NUMBER | |||
EURO_PO_LINE_ID | NUMBER | |||
EURO_PO_HEADER_ID | NUMBER | |||
EURO_PO_RELEASE_ID | NUMBER | |||
SOURCE_SHIPMENT_ID | NUMBER | |||
EURO_SOURCE_SHIPMENT_ID | NUMBER | |||
SECURITY_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_LOCATION_ID
, PO_LINE_ID
, PO_HEADER_ID
, PO_RELEASE_ID
, CREATION_DATE
, CREATED_BY
, SHIPMENT_TYPE
, ORG_ID
, QUANTITY
, QUANTITY_RECEIVED
, QUANTITY_BILLED
, QUANTITY_CANCELLED
, UNIT_MEAS_LOOKUP_CODE
, PRICE_OVERRIDE
, EURO_LINE_LOCATION_ID
, EURO_PO_LINE_ID
, EURO_PO_HEADER_ID
, EURO_PO_RELEASE_ID
, SOURCE_SHIPMENT_ID
, EURO_SOURCE_SHIPMENT_ID
, SECURITY_GROUP_ID
FROM PO.PO_LINE_LOCATIONS_ALL_EBS#;
|
|
|