[Home] [Help] [Dependency Information]

TABLE: ICX.POS_ASN_SHOP_CART_DETAILS

Object Details

Object Name:	POS_ASN_SHOP_CART_DETAILS
Object Type:	TABLE
Owner:	ICX
FND Design Data:	ICX.POS_ASN_SHOP_CART_DETAILS
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

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POS_ASN_SHOP_CART_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SESSION_ID

Columns

Query Text

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

SELECT SESSION_ID
,      ASN_LINE_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      SHIP_TO_ORGANIZATION_ID
,      QUANTITY_SHIPPED
,      UNIT_OF_MEASURE
,      UOM_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ITEM_ID
,      EXPECTED_RECEIPT_DATE
,      COMMENTS
,      WAYBILL_AIRBILL_NUM
,      BARCODE_LABEL
,      BILL_OF_LADING
,      CONTAINER_NUM
,      COUNTRY_OF_ORIGIN_CODE
,      VENDOR_CUM_SHIPPED_QTY
,      FREIGHT_CARRIER_CODE
,      VENDOR_LOT_NUM
,      TRUCK_NUM
,      NUM_OF_CONTAINERS
,      PACKING_SLIP
,      REASON_ID
,      ACTUAL_COST
,      TRANSFER_COST
,      TRANSPORTATION_COST
,      RMA_REFERENCE
,      TRANSPORTATION_ACCOUNT_ID
,      QUANTITY_INVOICED
,      NOTICE_UNIT_PRICE
,      UNIT_PRICE
,      EXTENDED_PRICE
,      TAX_NAME
,      TAX_AMOUNT
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ASN_LINE_SPLIT_ID
,      INTERFACE_TRANSACTION_ID
,      HEADER_INTERFACE_ID
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_OPERATION_SEQ_NUM
,      PO_DISTRIBUTION_ID
,      WIP_JOB_INFO
FROM ICX.POS_ASN_SHOP_CART_DETAILS;

Dependencies

[top of page]

ICX.POS_ASN_SHOP_CART_DETAILS does not reference any database object

ICX.POS_ASN_SHOP_CART_DETAILS is referenced by following:

ICX

POS_ASN_SHOP_CART_DETAILS#