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


VIEW: APPS.POS_PO_QA_SHIPMENTS_V

Object Details
Object Name: POS_PO_QA_SHIPMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_PO_QA_SHIPMENTS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Fetches shipment information for POs created for outside processing items.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Yes Document Unique Identifier
PO_NUMBER VARCHAR2 (61)
Document Number
PO_RELEASE_ID NUMBER

Document Release Unique Identifier
PO_LINE_ID NUMBER
Yes Document Line Unique Identifier
LINE_NUMBER NUMBER
Yes Document Line Number
PO_SHIPMENT_ID NUMBER
Yes Shipment Unique Identifier
SHIPMENT_NUMBER NUMBER

Shipment Number
SHIP_TO_LOCATION_ID NUMBER

Ship to Location Unique Identifier
SHIP_TO_LOCATION_CODE VARCHAR2 (60)
Ship to location
SUPPLIER_ITEM_NUMBER VARCHAR2 (25)
Supplier Item Number
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
QUANTITY_ORDERED NUMBER

Quantity Ordered
UNIT_OF_MEASURE_CODE VARCHAR2 (25)
Unit of measure
DUE_DATE DATE

Due Date
SUPPLIER_ID NUMBER

Supplier Unique Identifier
SUPPLIER_NAME VARCHAR2 (240)
Supplier Name
SUPPLIER_SITE_ID NUMBER

Supplier Site Unique Identifier
SUPPLIER_SITE_CODE VARCHAR2 (15) Yes Supplier Site Code
SHIP_TO_ORGANIZATION_ID NUMBER

Ship to organization Unique Identifier
SHIP_TO_ORGANIZATION_CODE VARCHAR2 (3)
Ship to organization code
SHIP_TO_ORGANIZATION_NAME VARCHAR2 (240)
Ship to organization Name
ITEM_ID NUMBER

Item Unique Identifier
ITEM_NUMBER VARCHAR2 (40)
Item Number
ITEM_REVISION VARCHAR2 (3)
Item Revision
CATEGORY_ID NUMBER

category Unique Identifier
CATEGORY VARCHAR2 (163)
category name
BASE_PO_NUM VARCHAR2 (20) Yes Base po number
QA_PLAN VARCHAR2 (4000)
QA Plan
ORG_ID NUMBER

Organization Unique Identifier
ORG_NAME VARCHAR2 (240)
Oarganization Name
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PO_HEADER_ID
,      PO_NUMBER
,      PO_RELEASE_ID
,      PO_LINE_ID
,      LINE_NUMBER
,      PO_SHIPMENT_ID
,      SHIPMENT_NUMBER
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION_CODE
,      SUPPLIER_ITEM_NUMBER
,      ITEM_DESCRIPTION
,      QUANTITY_ORDERED
,      UNIT_OF_MEASURE_CODE
,      DUE_DATE
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_CODE
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      SHIP_TO_ORGANIZATION_NAME
,      ITEM_ID
,      ITEM_NUMBER
,      ITEM_REVISION
,      CATEGORY_ID
,      CATEGORY
,      BASE_PO_NUM
,      QA_PLAN
,      ORG_ID
,      ORG_NAME
FROM APPS.POS_PO_QA_SHIPMENTS_V;

Dependencies

[top of page]

APPS.POS_PO_QA_SHIPMENTS_V references the following:

SchemaAPPS
SynonymAP_SUPPLIERS
SynonymAP_SUPPLIER_SITES_ALL
PL/SQL PackageFND_MESSAGE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_LOCATIONS_ALL
SynonymHZ_PARTIES
SynonymMTL_CATEGORIES_KFV
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
PL/SQL PackageQA_SS_SHIP - show dependent code
APPS.POS_PO_QA_SHIPMENTS_V is referenced by following:

SchemaAPPS
Package BodyQA_SS_SHIP - show dependent code