[Home] [Help] [Dependency Information]
Object Name: | JAI_PO_SUMMARY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JA.JAI_PO_SUMMARY_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
PO_NUM | VARCHAR2 | (20) | PO Number | |
RELEASE_NUM | NUMBER | Release Number | ||
LINE_NUM | NUMBER | Line Number | ||
SHIPMENT_NUM | NUMBER | Shipment Line Number | ||
TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Type of Document | |
DOC_TYPE_NAME | VARCHAR2 | (80) | Document Type Name | |
ITEM_ID | NUMBER | Item unique identifier. (References MTL_SYSTEM_ITEMS_B.inventory_item_id.) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description. (Defaulted from MTL_SYSTEM_ITEMS_TL.description.) | |
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | Unit of measure for the quantity ordered. (References MTL_UNITS_OF_MEASURE.unit_of_measure.) | |
QUANTITY | NUMBER | Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations | ||
CURRENCY_CODE | VARCHAR2 | (15) | Unique identifier for the currency (References FND_CURRENCIES.currency_code) | |
PRICE_OVERRIDE | NUMBER | Order shipment price or break price for blanket purchase orders, RFQs, and quotations | ||
SHIP_TO_ORGANIZATION_ID | NUMBER | Ship-to organization unique identifier(References HR_ORGANIZATION_UNITS.organization_id) | ||
SHIP_TO_LOCATION_ID | NUMBER | Unique identifier for the ship-to location (References HR_LOCATIONS_ALL.location_id) | ||
SHIP_TO_ORGANIZATION | VARCHAR2 | (240) | Ship to Organization | |
SHIP_TO_LOCATION | VARCHAR2 | (60) | Ship to Location | |
BILL_TO_LOCATION_ID | NUMBER | Bill-to location unique identifier (References HR_LOCATIONS_ALL.location_id) | ||
VENDOR_ID | NUMBER | Supplier unique identifier (References PO_VENDORS.vendor_id) | ||
VENDOR_NAME | VARCHAR2 | (240) | Vendor Name | |
VENDOR_SITE_ID | NUMBER | Supplier site unique identifier (References PO_VENDOR_SITES_ALL.vendor_site_id) | ||
VENDOR_SITE_CODE | VARCHAR2 | (15) | Vendor Site Code | |
PO_HEADER_ID | NUMBER | Document header unique identifier | ||
PO_LINE_ID | NUMBER | Document line unique identifier | ||
LINE_LOCATION_ID | NUMBER | Document shipment schedule unique identifier | ||
PO_RELEASE_ID | NUMBER | Release unique identifier for a release shipment(References PO_RELEASES_ALL.po_release_id) | ||
AUTHORIZATION_STATUS | VARCHAR2 | (25) | Authorization status of the purchase order (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='AUTHORIZATION STATUS') | |
NEED_BY_DATE | VARCHAR2 | (9) | Need-by date for the shipment schedule | |
AGENT_ID | NUMBER | (9) | Buyer unique identifier. (References PO_AGENTS.agent_id) | |
OWNING_ORG_ID | NUMBER | Organization identifier | ||
BLANKET_TOTAL_AMOUNT | NUMBER | Amount agreed for the planned or blanket purchase order |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PO_NUM
, RELEASE_NUM
, LINE_NUM
, SHIPMENT_NUM
, TYPE_LOOKUP_CODE
, DOC_TYPE_NAME
, ITEM_ID
, ITEM_DESCRIPTION
, UNIT_MEAS_LOOKUP_CODE
, QUANTITY
, CURRENCY_CODE
, PRICE_OVERRIDE
, SHIP_TO_ORGANIZATION_ID
, SHIP_TO_LOCATION_ID
, SHIP_TO_ORGANIZATION
, SHIP_TO_LOCATION
, BILL_TO_LOCATION_ID
, VENDOR_ID
, VENDOR_NAME
, VENDOR_SITE_ID
, VENDOR_SITE_CODE
, PO_HEADER_ID
, PO_LINE_ID
, LINE_LOCATION_ID
, PO_RELEASE_ID
, AUTHORIZATION_STATUS
, NEED_BY_DATE
, AGENT_ID
, OWNING_ORG_ID
, BLANKET_TOTAL_AMOUNT
FROM APPS.JAI_PO_SUMMARY_V;
APPS.JAI_PO_SUMMARY_V is not referenced by any database object
|
|
|