[Home] [Help] [Dependency Information]
Object Name: | INL_SHIP_PO_OVERALL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INL.INL_SHIP_PO_OVERALL_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.INL_SHIP_PO_OVERALL_V is not referenced by any database object
|
|
|