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

VIEW: APPS.INL_SHIP_PO_OVERALL_V

Object Details
Object Name: INL_SHIP_PO_OVERALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINL.INL_SHIP_PO_OVERALL_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Yes Shipment Identifier
ORGANIZATION_ID NUMBER
Yes Inventory Organization Identifier
LOCATION_ID NUMBER

Location Identifier
ORG_ID NUMBER
Yes Operating Unit Identifier
SHIP_TYPE_ID NUMBER
Yes Shipment Type Identifier
SHIP_TYPE_CODE VARCHAR2 (15)
Shipment Type Code
SHIP_TYPE_NAME VARCHAR2 (30)
Shipment Type Name
SHIP_NUM VARCHAR2 (25) Yes Shipment Number
SHIP_DATE DATE
Yes Shipment Date
SHIP_STATUS_CODE VARCHAR2 (30) Yes Shipment Status, taken from lookup INL_SHIP_STATUSES
PENDING_MATCHING_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating the existence of lines matched but not absorbed by the landed cost calculation
PENDING_UPDATE_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating the existence of lines updated but not processed by the landed cost calculation
SIMULATION_ID NUMBER

Simulation Identifier
SHIP_LINE_GROUP_ID NUMBER

Line Group Identifier
SHIP_LINE_GROUP_NUM NUMBER

Line Group Number
SHIP_LINE_GROUP_REFERENCE VARCHAR2 (30)
Line Group Reference
SRC_TYPE_CODE VARCHAR2 (30)
Source Type Code
GROUP_PARTY_ID NUMBER

Group Party Identifier
GROUP_PARTY_NAME VARCHAR2 (360)
Group Party Name
GROUP_PARTY_SITE_ID NUMBER

Group Party Site Identifier
GROUP_PARTY_SITE_NAME VARCHAR2 (240)
Group Party Site Name
GROUP_ORGANIZATION_ID VARCHAR2 (0)
Group Organization Identifier
GROUP_ORGANIZATION_NAME VARCHAR2 (0)
Group Organization Name
SHIP_LINE_ID NUMBER

Shipment Line Identifier
SHIP_LINE_NUM NUMBER

Shipment Line Number
EST_SHIP_LINE_ID NUMBER

Estimated Shipment Line Identifier
EST_TXN_UNIT_PRICE NUMBER

Estimated Transaction Unit Price
SHIP_LINE_SRC_TYPE_CODE VARCHAR2 (30)
Source Type Code, taken from lookup INL_SHIP_LINE_SRC_TYPES
SHIP_LINE_SOURCE_ID NUMBER

Shipment Line Source Identifier
SHIP_LINE_TYPE_CODE VARCHAR2 (15)
Shipment Line Type Code
SHIP_LINE_TYPE_NAME VARCHAR2 (30)
Shipment Line Type Name
ITEM_ID NUMBER

Inventory Item Identifier
ITEM VARCHAR2 (40)
Item
ITEM_REVISION VARCHAR2 (3)
Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
TXN_QTY NUMBER

Transaction Quantity
TXN_UOM_CODE VARCHAR2 (3)
Transaction Unit of Measure
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary Unit of Measure Code
PRIMARY_QTY NUMBER

Primary Quantity
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary Unit of Measure
SECONDARY_QTY NUMBER

Secondary Quantity
TXN_UNIT_PRICE NUMBER

Transaction Unit Price
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
LINE_AMT NUMBER

Line Amount
SRC_ID NUMBER

Source Identifier
SRC_TYPE VARCHAR2 (80)
Source Type
SRC_NUMBER VARCHAR2 (20)
Source Number
SRC_DESCRIPTION VARCHAR2 (0)
Source Description
SRC_ORG_ID NUMBER

Source Operating Unit Identifier
SRC_PARTY_ID NUMBER

Source Party Identifier
SRC_PARTY_NAME VARCHAR2 (360)
Source Party Name
SRC_PARTY_SITE_ID NUMBER (15)
Source Party Site Identifier
SRC_PARTY_SITE_NAME VARCHAR2 (240)
Source Party Site Name
SRC_VENDOR_ID NUMBER

Source Vendor Identifier
SRC_VENDOR_NAME VARCHAR2 (240)
Source Vendor Name
SRC_VENDOR_SITE_ID NUMBER

Source Vendor Site Identifier
SRC_VENDOR_SITE_CODE VARCHAR2 (15)
Source Vendor Site Code
SRC_ORGANIZATION_ID VARCHAR2 (0)
Source Inventory Organization Identifier
SRC_LOCATION_ID VARCHAR2 (0)
Source Location Identifier
SRC_CUSTOMER_ID VARCHAR2 (0)
Source Customer Identifier
SRC_CUSTOMER_NAME VARCHAR2 (0)
Source Customer Name
SRC_CUSTOMER_NUMBER VARCHAR2 (0)
Source Customer Number
SRC_CUSTOMER_SITE_CODE VARCHAR2 (0)
Source Customer Site Code
SRC_CUST_ITEM_NUM VARCHAR2 (0)
Source Customer Item Number
SRC_RELEASE_NUM NUMBER

Source Release Number
SRC_RELEASE_ID NUMBER

Source Release Identifier
SRC_RELEASE_DATE DATE

Source Release Date
SRC_LINE_ID NUMBER

Source Line Identifier
SRC_LINE_NUM NUMBER

Source Line Number
SRC_SHIP_ID NUMBER

Source Shipment Identifier
SRC_SHIP_NUM VARCHAR2 (40)
Source Shipment Number
SRC_SHIPPED_DATE VARCHAR2 (0)
Source Shipped Date
SRC_QTY NUMBER

Source Quantity
SRC_ITEM_ID NUMBER

Source Inventory Item Identifier
SRC_ITEM_REVISION VARCHAR2 (3)
Source Item Revision
SRC_ITEM_DESCRIPTION VARCHAR2 (240)
Source Item Description
SRC_CONTAINER_NUM VARCHAR2 (35)
Source Container Number
SRC_TRUCK_NUM VARCHAR2 (35)
Source Truck Number
SRC_BAR_CODE_LABEL VARCHAR2 (35)
Source Bar Code Label
SRC_DELIVER_TO_PERSON_ID NUMBER (9)
Source Deliver To Person Identifier
SRC_VENDOR_ITEM_NUM VARCHAR2 (25)
Source Vendor Item Number
SRC_PACKING_SLIP VARCHAR2 (25)
Source Packing Slip
SRC_EMPLOYEE_ID NUMBER (9)
Source Employee Identifier
SRC_FREIGHT_CARRIER_CODE VARCHAR2 (25)
Source Freight Carrier Code
SRC_BILL_OF_LADING VARCHAR2 (25)
Source Bill Of Lading
SRC_ROUTING_ID NUMBER

Source Routing Identifier
SRC_INSPECTION_STATUS_CODE VARCHAR2 (25)
Source Inspection Status Code
SRC_TRANSACTION_DATE DATE

Source Transaction Date
Query Text

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


SELECT SHIP_HEADER_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      ORG_ID
,      SHIP_TYPE_ID
,      SHIP_TYPE_CODE
,      SHIP_TYPE_NAME
,      SHIP_NUM
,      SHIP_DATE
,      SHIP_STATUS_CODE
,      PENDING_MATCHING_FLAG
,      PENDING_UPDATE_FLAG
,      SIMULATION_ID
,      SHIP_LINE_GROUP_ID
,      SHIP_LINE_GROUP_NUM
,      SHIP_LINE_GROUP_REFERENCE
,      SRC_TYPE_CODE
,      GROUP_PARTY_ID
,      GROUP_PARTY_NAME
,      GROUP_PARTY_SITE_ID
,      GROUP_PARTY_SITE_NAME
,      GROUP_ORGANIZATION_ID
,      GROUP_ORGANIZATION_NAME
,      SHIP_LINE_ID
,      SHIP_LINE_NUM
,      EST_SHIP_LINE_ID
,      EST_TXN_UNIT_PRICE
,      SHIP_LINE_SRC_TYPE_CODE
,      SHIP_LINE_SOURCE_ID
,      SHIP_LINE_TYPE_CODE
,      SHIP_LINE_TYPE_NAME
,      ITEM_ID
,      ITEM
,      ITEM_REVISION
,      ITEM_DESCRIPTION
,      TXN_QTY
,      TXN_UOM_CODE
,      PRIMARY_UOM_CODE
,      PRIMARY_QTY
,      SECONDARY_UOM_CODE
,      SECONDARY_QTY
,      TXN_UNIT_PRICE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      LINE_AMT
,      SRC_ID
,      SRC_TYPE
,      SRC_NUMBER
,      SRC_DESCRIPTION
,      SRC_ORG_ID
,      SRC_PARTY_ID
,      SRC_PARTY_NAME
,      SRC_PARTY_SITE_ID
,      SRC_PARTY_SITE_NAME
,      SRC_VENDOR_ID
,      SRC_VENDOR_NAME
,      SRC_VENDOR_SITE_ID
,      SRC_VENDOR_SITE_CODE
,      SRC_ORGANIZATION_ID
,      SRC_LOCATION_ID
,      SRC_CUSTOMER_ID
,      SRC_CUSTOMER_NAME
,      SRC_CUSTOMER_NUMBER
,      SRC_CUSTOMER_SITE_CODE
,      SRC_CUST_ITEM_NUM
,      SRC_RELEASE_NUM
,      SRC_RELEASE_ID
,      SRC_RELEASE_DATE
,      SRC_LINE_ID
,      SRC_LINE_NUM
,      SRC_SHIP_ID
,      SRC_SHIP_NUM
,      SRC_SHIPPED_DATE
,      SRC_QTY
,      SRC_ITEM_ID
,      SRC_ITEM_REVISION
,      SRC_ITEM_DESCRIPTION
,      SRC_CONTAINER_NUM
,      SRC_TRUCK_NUM
,      SRC_BAR_CODE_LABEL
,      SRC_DELIVER_TO_PERSON_ID
,      SRC_VENDOR_ITEM_NUM
,      SRC_PACKING_SLIP
,      SRC_EMPLOYEE_ID
,      SRC_FREIGHT_CARRIER_CODE
,      SRC_BILL_OF_LADING
,      SRC_ROUTING_ID
,      SRC_INSPECTION_STATUS_CODE
,      SRC_TRANSACTION_DATE
FROM APPS.INL_SHIP_PO_OVERALL_V;

Dependencies

[top of page]

APPS.INL_SHIP_PO_OVERALL_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
ViewINL_ADJ_SHIP_LINES_V
SynonymINL_SHIP_HEADERS
SynonymINL_SHIP_LINES
SynonymINL_SHIP_LINE_GROUPS
ViewINL_SHIP_LINE_TYPES_VL
ViewINL_SHIP_TYPES_VL
ViewMTL_SYSTEM_ITEMS_VL
SynonymPO_HEADERS
SynonymPO_LINES
SynonymPO_LINE_LOCATIONS
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES
ViewPO_VENDORS
ViewPO_VENDOR_SITES
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_SUPPLY
SynonymRCV_TRANSACTIONS

APPS.INL_SHIP_PO_OVERALL_V is not referenced by any database object