DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.JAI_PO_SUMMARY_V

Object Details
Object Name: JAI_PO_SUMMARY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJA.JAI_PO_SUMMARY_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.JAI_PO_SUMMARY_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_LOCATIONS_ALL_TL
SynonymPO_DOCUMENT_TYPES_ALL_B
SynonymPO_DOCUMENT_TYPES_ALL_TL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
SynonymPO_SYSTEM_PARAMETERS
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.JAI_PO_SUMMARY_V is not referenced by any database object