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


VIEW: APPS.POS_ASN_REVIEW_HEADERS_V

Object Details
Object Name: POS_ASN_REVIEW_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.POS_ASN_REVIEW_HEADERS_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
ASN_TYPE VARCHAR2 (240)
TRANSACTION_TYPE VARCHAR2 (30)
VENDOR_NAME VARCHAR2 (240)
VENDOR_SITE_NAME VARCHAR2 (15) Yes
SHIP_TO_LOCATION VARCHAR2 (60)
SHIP_TO_ORGANIZATION VARCHAR2 (240)
SHIPMENT_NUM VARCHAR2 (30)
BILL_OF_LADING VARCHAR2 (25)
WAYBILL_AIRBILL_NUM VARCHAR2 (20)
SHIP_DATE DATE

EXPECTED_RECEIPT_DATE DATE

COMMENTS VARCHAR2 (240)
FREIGHT_CARRIER VARCHAR2 (80)
FREIGHT_CARRIER_CODE VARCHAR2 (25)
FREIGHT_TERM VARCHAR2 (240)
PACKING_SLIP VARCHAR2 (25)
CURRENCY_CODE VARCHAR2 (15)
CURRENCY_EXCHANGE_RATE NUMBER

CURRENCY_EXCHANGE_DATE DATE

NUM_OF_CONTAINERS NUMBER

CARRIER_EQUIPMENT VARCHAR2 (10)
CARRIER_METHOD VARCHAR2 (2)
FREIGHT_BILL_NUMBER VARCHAR2 (35)
GROSS_WEIGHT NUMBER

GROSS_WEIGHT_UOM VARCHAR2 (50)
GROSS_WEIGHT_UOM_CODE VARCHAR2 (3)
NET_WEIGHT NUMBER

NET_WEIGHT_UOM VARCHAR2 (50)
NET_WEIGHT_UOM_CODE VARCHAR2 (3)
TAR_WEIGHT NUMBER

TAR_WEIGHT_UOM VARCHAR2 (50)
TAR_WEIGHT_UOM_CODE VARCHAR2 (3)
PACKAGING_CODE VARCHAR2 (5)
SPECIAL_HANDLING_CODE VARCHAR2 (3)
INVOICE_NUM VARCHAR2 (30)
TOTAL_INVOICE_AMOUNT NUMBER

INVOICE_DATE DATE

FREIGHT_AMOUNT NUMBER

TAX_NAME VARCHAR2 (15)
TAX_AMOUNT NUMBER

PAYMENT_TERMS VARCHAR2 (25)
SESSION_ID NUMBER
Yes
Query Text

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


SELECT ASN_TYPE
,      TRANSACTION_TYPE
,      VENDOR_NAME
,      VENDOR_SITE_NAME
,      SHIP_TO_LOCATION
,      SHIP_TO_ORGANIZATION
,      SHIPMENT_NUM
,      BILL_OF_LADING
,      WAYBILL_AIRBILL_NUM
,      SHIP_DATE
,      EXPECTED_RECEIPT_DATE
,      COMMENTS
,      FREIGHT_CARRIER
,      FREIGHT_CARRIER_CODE
,      FREIGHT_TERM
,      PACKING_SLIP
,      CURRENCY_CODE
,      CURRENCY_EXCHANGE_RATE
,      CURRENCY_EXCHANGE_DATE
,      NUM_OF_CONTAINERS
,      CARRIER_EQUIPMENT
,      CARRIER_METHOD
,      FREIGHT_BILL_NUMBER
,      GROSS_WEIGHT
,      GROSS_WEIGHT_UOM
,      GROSS_WEIGHT_UOM_CODE
,      NET_WEIGHT
,      NET_WEIGHT_UOM
,      NET_WEIGHT_UOM_CODE
,      TAR_WEIGHT
,      TAR_WEIGHT_UOM
,      TAR_WEIGHT_UOM_CODE
,      PACKAGING_CODE
,      SPECIAL_HANDLING_CODE
,      INVOICE_NUM
,      TOTAL_INVOICE_AMOUNT
,      INVOICE_DATE
,      FREIGHT_AMOUNT
,      TAX_NAME
,      TAX_AMOUNT
,      PAYMENT_TERMS
,      SESSION_ID
FROM APPS.POS_ASN_REVIEW_HEADERS_V;

Dependencies

[top of page]

APPS.POS_ASN_REVIEW_HEADERS_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
ViewHR_ORG_UNITS_NO_JOIN
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_UNITS_OF_MEASURE
SynonymORG_FREIGHT
SynonymPOS_ASN_SHOP_CART_HEADERS
ViewPO_LOOKUP_CODES
ViewPO_VENDORS
ViewPO_VENDOR_SITES

APPS.POS_ASN_REVIEW_HEADERS_V is not referenced by any database object