[Home] [Help] [Dependency Information]
Object Name: | PO_LINES_ALL_EBS# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PO_LINE_ID | NUMBER | Yes | ||
PO_HEADER_ID | NUMBER | Yes | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
ORG_ID | NUMBER | |||
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | ||
QUANTITY_COMMITTED | NUMBER | |||
COMMITTED_AMOUNT | NUMBER | |||
NOT_TO_EXCEED_PRICE | NUMBER | |||
LIST_PRICE_PER_UNIT | NUMBER | |||
UNIT_PRICE | NUMBER | |||
MARKET_PRICE | NUMBER | |||
QUANTITY | NUMBER | |||
CONTRACT_NUM | VARCHAR2 | (25) | ||
MIN_RELEASE_AMOUNT | NUMBER | |||
EURO_PO_LINE_ID | NUMBER | |||
EURO_PO_HEADER_ID | NUMBER | |||
SECURITY_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PO_LINE_ID
, PO_HEADER_ID
, CREATION_DATE
, CREATED_BY
, ORG_ID
, UNIT_MEAS_LOOKUP_CODE
, QUANTITY_COMMITTED
, COMMITTED_AMOUNT
, NOT_TO_EXCEED_PRICE
, LIST_PRICE_PER_UNIT
, UNIT_PRICE
, MARKET_PRICE
, QUANTITY
, CONTRACT_NUM
, MIN_RELEASE_AMOUNT
, EURO_PO_LINE_ID
, EURO_PO_HEADER_ID
, SECURITY_GROUP_ID
FROM PO.PO_LINES_ALL_EBS#;
|
|
|