[Home] [Help] [Dependency Information]
Object Name: | OE_LINE_ACKS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ONT.OE_LINE_ACKS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view shows information about the acknowledgements for Order Lines
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORDER_SOURCE_ID | NUMBER | Order source id | ||
ORIG_SYS_DOCUMENT_REF | VARCHAR2 | (50) | Original system document reference | |
ORIG_SYS_LINE_REF | VARCHAR2 | (50) | Original system line reference | |
ORIG_SYS_SHIPMENT_REF | VARCHAR2 | (50) | Original system shipment reference | |
ORG_ID | NUMBER | Org id | ||
CHANGE_SEQUENCE | VARCHAR2 | (50) | Change sequence | |
CHANGE_DATE | DATE | Change date | ||
ORDER_NUMBER | NUMBER | Order number | ||
HEADER_ID | NUMBER | Header id | ||
ACCOUNTING_RULE | VARCHAR2 | (30) | Accounting rule used by AR for generating Invoice | |
ACCOUNTING_RULE_ID | NUMBER | Accounting rule id used by AR for generating Invoice | ||
ACCOUNTING_RULE_DURATION | NUMBER | (15) | Number of accounting periods, across which revenue is recognized. | |
ACKNOWLEDGMENT_FLAG | VARCHAR2 | (1) | Acknowledgment flag | |
AGREEMENT | VARCHAR2 | (240) | Agreement | |
AGREEMENT_ID | NUMBER | Agreement id | ||
ARRIVAL_SET_ID | NUMBER | Arrival set id | ||
ARRIVAL_SET_NAME | VARCHAR2 | (30) | Arrival set name | |
CUSTOMER_ITEM_NET_PRICE | NUMBER | Customer item net price | ||
PRICE_LIST | VARCHAR2 | (240) | Price list | |
PRICE_LIST_ID | NUMBER | Price list id | ||
CUSTOMER_PAYMENT_TERM_ID | NUMBER | Customer payment term id | ||
SHIP_FROM_ORG | VARCHAR2 | (240) | Ship from org | |
SHIP_FROM_ORG_ID | NUMBER | Ship from org id | ||
SHIP_TO_ORG | VARCHAR2 | (240) | Ship to org | |
SHIP_TO_ORG_ID | NUMBER | Ship to org id | ||
CUSTOMER_SHIPMENT_NUMBER | VARCHAR2 | (50) | Customer shipment number | |
DROP_SHIP_FLAG | VARCHAR2 | (1) | Drop ship flag | |
SOLD_FROM_ORG | VARCHAR2 | (240) | Sold from org | |
SOLD_FROM_ORG_ID | NUMBER | Sold from org id | ||
SOLD_TO_ORG | VARCHAR2 | (360) | Sold to org | |
SOLD_TO_ORG_ID | NUMBER | Sold to org id | ||
ATO_LINE_ID | NUMBER | ATO line id | ||
AUTHORIZED_TO_SHIP_FLAG | VARCHAR2 | (1) | Authorized to ship flag | |
BOOKED_FLAG | VARCHAR2 | (1) | Booked flag | |
CALCULATE_PRICE_FLAG | VARCHAR2 | (1) | Calculate price flag | |
CANCELLED_FLAG | VARCHAR2 | (1) | Cancelled flag | |
CANCELLED_QUANTITY | NUMBER | Cancelled quantity | ||
CLOSED_FLAG | VARCHAR2 | (1) | Closed flag | |
COMPONENT_CODE | VARCHAR2 | (1000) | Component code | |
COMPONENT_NUMBER | NUMBER | Component number | ||
COMPONENT_SEQUENCE_ID | NUMBER | Component sequence id | ||
CONFIG_DISPLAY_SEQUENCE | NUMBER | Config display sequence | ||
CONFIGURATION_ID | NUMBER | Configuration id | ||
CONFIG_LINE_REF | VARCHAR2 | (50) | Config line reference | |
TOP_MODEL_LINE_ID | NUMBER | Top model line id | ||
CONTRACT_PO_NUMBER | VARCHAR2 | (150) | Contract PO number | |
CUST_PO_NUMBER | VARCHAR2 | (50) | Customer PO number | |
CUSTOMER_ITEM | VARCHAR2 | (2000) | Customer item | |
CUSTOMER_ITEM_ID | NUMBER | Customer item id | ||
CUSTOMER_ITEM_REVISION | VARCHAR2 | (50) | Customer item revision | |
CUSTOMER_LINE_NUMBER | VARCHAR2 | (50) | Customer line number | |
DELIVER_TO_CONTACT | VARCHAR2 | (330) | Deliver to contact | |
DELIVER_TO_CONTACT_ID | NUMBER | Deliver to contact id | ||
DELIVER_TO_ORG | VARCHAR2 | (240) | Deliver to org | |
DELIVER_TO_ORG_ID | NUMBER | Deliver to org id | ||
DELIVERY_LEAD_TIME | NUMBER | Delivery lead time | ||
DEMAND_BUCKET_TYPE | VARCHAR2 | (80) | Demand bucket type | |
DEMAND_BUCKET_TYPE_CODE | VARCHAR2 | (30) | Demand bucket type code | |
DEMAND_CLASS | VARCHAR2 | (80) | Demand class | |
DEMAND_CLASS_CODE | VARCHAR2 | (30) | Demand class code | |
DEMAND_STREAM | VARCHAR2 | (30) | Demand stream | |
EARLIEST_ACCEPTABLE_DATE | DATE | Earliest acceptable date | ||
FOB_POINT | VARCHAR2 | (240) | FOB point | |
FOB_POINT_CODE | VARCHAR2 | (30) | FOB point code | |
FREIGHT_CARRIER_CODE | VARCHAR2 | (30) | Freight Carrier code | |
FREIGHT_TERMS | VARCHAR2 | (80) | Freight terms | |
FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Freight terms code | |
FULFILLED_QUANTITY | NUMBER | The fulfilled quantity for the line | ||
FULFILLMENT_SET_ID | NUMBER | Fulfillment set id | ||
FULFILLMENT_SET_NAME | VARCHAR2 | (30) | Fulfillment set name | |
INDUSTRY_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
INVENTORY_ITEM | VARCHAR2 | (240) | Inventory Item | |
INVENTORY_ITEM_ID | NUMBER | Inventory Item ID | ||
INVOICE_SET_ID | NUMBER | Invoice set id | ||
INVOICE_SET_NAME | VARCHAR2 | (30) | Invoice set name | |
INVOICE_NUMBER | VARCHAR2 | (20) | Invoice Number | |
INVOICE_TO_CONTACT | VARCHAR2 | (330) | Invoice To Contact | |
INVOICE_TO_CONTACT_ID | NUMBER | Invoice To Contact ID | ||
INVOICE_TO_ORG | VARCHAR2 | (240) | Invoice To Organization | |
INVOICE_TO_ORG_ID | NUMBER | Invoice To Organization ID | ||
INVOICING_RULE | VARCHAR2 | (30) | Invoicing rule | |
INVOICING_RULE_ID | NUMBER | Invoicing rule id | ||
ITEM_INPUT | VARCHAR2 | (240) | To Store Ordered Item Name | |
ITEM_REVISION | VARCHAR2 | (3) | Item revision | |
ITEM_TYPE_CODE | VARCHAR2 | (30) | Item type code | |
LATEST_ACCEPTABLE_DATE | DATE | Latest acceptable date | ||
LINE_CATEGORY_CODE | VARCHAR2 | (30) | Line category code | |
LINE_ID | NUMBER | Line id | ||
LINE_NUMBER | NUMBER | Line number | ||
LINE_PO_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
LINE_TYPE | VARCHAR2 | (30) | Line type | |
LINE_TYPE_ID | NUMBER | Line type id | ||
LINK_TO_LINE_ID | NUMBER | Link to line id | ||
LINK_TO_LINE_REF | VARCHAR2 | (50) | Link to line reference | |
LOAD_SEQ_NUMBER | NUMBER | Load sequence number | ||
LOT | VARCHAR2 | (30) | Lot | |
MODEL_GROUP_NUMBER | NUMBER | Model group number | ||
OPEN_FLAG | VARCHAR2 | (1) | Open flag | |
OPERATION_CODE | VARCHAR2 | (30) | Operation code | |
OPTION_FLAG | VARCHAR2 | (1) | Option flag | |
OPTION_NUMBER | NUMBER | Option number | ||
ORDER_QUANTITY_UOM | VARCHAR2 | (3) | Order quantity uom | |
ORDERED_QUANTITY | NUMBER | Ordered quantity | ||
PAYMENT_TERM | VARCHAR2 | (30) | Payment term | |
PAYMENT_TERM_ID | NUMBER | Payment term id | ||
PRICING_ATTRIBUTE1 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
PRICING_ATTRIBUTE10 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
PRICING_ATTRIBUTE2 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
PRICING_ATTRIBUTE3 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
PRICING_ATTRIBUTE4 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
PRICING_ATTRIBUTE5 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
PRICING_ATTRIBUTE6 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
PRICING_ATTRIBUTE7 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
PRICING_ATTRIBUTE8 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
PRICING_ATTRIBUTE9 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
PRICING_CONTEXT | VARCHAR2 | (150) | Descriptive Flexfield segment | |
PRICING_DATE | DATE | Pricing date | ||
PRICING_QUANTITY | NUMBER | Pricing quantity | ||
PRICING_QUANTITY_UOM | VARCHAR2 | (3) | Pricing quantity UOM | |
PROJECT | VARCHAR2 | (30) | Project | |
PROJECT_ID | NUMBER | Project id | ||
PROMISE_DATE | DATE | Promise date | ||
REFERENCE_HEADER_ID | NUMBER | Reference header id | ||
REFERENCE_LINE_ID | NUMBER | Reference line id | ||
REFERENCE_TYPE | VARCHAR2 | (30) | Reference type | |
RELATED_PO_NUMBER | VARCHAR2 | (50) | Related po number | |
REQUEST_DATE | DATE | Request date | ||
REQUEST_ID | NUMBER | Concurrent request that last changed row | ||
RESERVED_QUANTITY | NUMBER | Reserved quantity | ||
RETURN_ATTRIBUTE1 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE10 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE11 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE12 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE13 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE14 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE15 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE2 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE3 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE4 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE5 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE6 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE7 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE8 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_ATTRIBUTE9 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
RETURN_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
RETURN_REASON_CODE | VARCHAR2 | (30) | Return reason code | |
SALESREP_ID | NUMBER | Salesrep id | ||
SALESREP | VARCHAR2 | (240) | Salesrep | |
SCHEDULE_ARRIVAL_DATE | DATE | Schedule arrival date | ||
SCHEDULE_SHIP_DATE | DATE | Schedule ship date | ||
SCHEDULE_ITEM_DETAIL | VARCHAR2 | (30) | Schedule item detail | |
SCHEDULE_STATUS_CODE | VARCHAR2 | (30) | Schedule status code | |
SHIP_MODEL_COMPLETE_FLAG | VARCHAR2 | (1) | Ship model complete flag | |
SHIP_SET_ID | NUMBER | Ship set id | ||
SHIP_SET_NAME | VARCHAR2 | (30) | Ship set name | |
SHIP_TO_ADDRESS1 | VARCHAR2 | (240) | Ship to address1 | |
SHIP_TO_ADDRESS2 | VARCHAR2 | (240) | Ship to address2 | |
SHIP_TO_ADDRESS3 | VARCHAR2 | (240) | Ship to address3 | |
SHIP_TO_ADDRESS4 | VARCHAR2 | (240) | Ship to address4 | |
SHIP_TOLERANCE_ABOVE | NUMBER | Over shipment/return Tolerance | ||
SHIP_TOLERANCE_BELOW | NUMBER | Under Shipment/Return Tolerance | ||
SHIPMENT_NUMBER | NUMBER | Shipment number | ||
SHIPMENT_PRIORITY | VARCHAR2 | (80) | Shipment priority | |
SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | Shipment priority code | |
SHIPPED_QUANTITY | NUMBER | Shipped quantity for the line | ||
SHIPPING_METHOD | VARCHAR2 | (80) | Shipping method | |
SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Shipping method code | |
SHIPPING_QUANTITY | NUMBER | Quantity which has been shippedd by Shipping in Shipping UOM | ||
SHIPPING_QUANTITY_UOM | VARCHAR2 | (3) | The UOM for Shipping Quantity. | |
SORT_ORDER | VARCHAR2 | (2000) | Sort order | |
SOURCE_DOCUMENT_ID | NUMBER | Source document id | ||
SOURCE_DOCUMENT_LINE_ID | NUMBER | Source document line id | ||
SOURCE_DOCUMENT_TYPE_ID | NUMBER | Source document type id | ||
SOURCE_TYPE_CODE | VARCHAR2 | (30) | Source type code | |
SPLIT_FROM_LINE_ID | NUMBER | Split from line id | ||
SUBINVENTORY | VARCHAR2 | (30) | Subinventory | |
SUBMISSION_DATETIME | DATE | Submission datetime | ||
TASK | VARCHAR2 | (30) | Task | |
TASK_ID | NUMBER | Task id | ||
TAX | VARCHAR2 | (50) | Tax | |
TAX_CODE | VARCHAR2 | (50) | Tax code | |
TAX_DATE | DATE | Tax date | ||
TAX_EXEMPT_FLAG | VARCHAR2 | (30) | Tax exempt flag | |
TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | Tax exempt number | |
TAX_EXEMPT_REASON | VARCHAR2 | (80) | Tax exempt reason | |
TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax exempt reason code | |
TAX_POINT | VARCHAR2 | (80) | Tax point | |
TAX_POINT_CODE | VARCHAR2 | (30) | Tax point code | |
TAX_RATE | NUMBER | Tax rate | ||
TAX_VALUE | NUMBER | Tax value | ||
UNIT_LIST_PRICE | NUMBER | Unit list price | ||
UNIT_SELLING_PRICE | NUMBER | Unit selling price | ||
VEH_CUS_ITEM_CUM_KEY_ID | NUMBER | Customer item cum key id | ||
VISIBLE_DEMAND_FLAG | VARCHAR2 | (1) | Visible demand flag | |
FIRST_ACK_CODE | VARCHAR2 | (30) | Code used when first acknowledged | |
LAST_ACK_CODE | VARCHAR2 | (30) | Code used when last acknowledged | |
FIRST_ACK_DATE | DATE | Date first acknowledged | ||
LAST_ACK_DATE | DATE | Date last acknowledged | ||
SPLIT_FROM_LINE_REF | VARCHAR2 | (50) | Split from line reference. | |
SPLIT_FROM_SHIPMENT_REF | VARCHAR2 | (50) | Original Shipment Number, from which the Line is splitted. | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE1 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE10 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE11 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE12 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE13 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE14 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE15 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE16 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE17 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE18 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE19 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE2 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE20 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE21 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE22 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE23 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE24 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE25 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE26 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE27 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE28 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE29 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE3 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE30 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE4 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE5 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE6 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE7 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE8 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
INDUSTRY_ATTRIBUTE9 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
INVENTORY_ITEM_SEGMENT_1 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_10 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_11 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_12 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_13 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_14 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_15 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_16 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_17 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_18 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_19 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_2 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_20 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_3 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_4 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_5 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_6 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_7 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_8 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
INVENTORY_ITEM_SEGMENT_9 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
CUST_MODEL_SERIAL_NUMBER | VARCHAR2 | (50) | Customer model serial number | |
CUSTOMER_DOCK | VARCHAR2 | (50) | Customer dock | |
CUSTOMER_DOCK_CODE | VARCHAR2 | (50) | Customer dock code | |
CUST_PRODUCTION_SEQ_NUM | VARCHAR2 | (50) | Customer production sequence number | |
CUSTOMER_PRODUCTION_LINE | VARCHAR2 | (50) | Customer production line | |
ACTUAL_SHIPMENT_DATE | DATE | Actual shipment date | ||
ACTUAL_ARRIVAL_DATE | DATE | Actual arrival date | ||
SHIP_TO_CITY | VARCHAR2 | (60) | Ship to city | |
SHIP_TO_POSTAL_CODE | VARCHAR2 | (60) | Ship to postal code | |
SHIP_TO_COUNTRY | VARCHAR2 | (60) | Ship to country | |
SHIP_TO_COUNTY | VARCHAR2 | (60) | Ship to county | |
SHIP_TO_STATE | VARCHAR2 | (60) | Ship to state | |
SHIP_TO_EDI_LOCATION_CODE | VARCHAR2 | (40) | EDI location code for the ship to site. | |
SHIP_TO_CONTACT | VARCHAR2 | (330) | Ship to contact | |
SHIP_TO_CONTACT_FIRST_NAME | VARCHAR2 | (150) | Ship to contact first name | |
SHIP_TO_CONTACT_LAST_NAME | VARCHAR2 | (150) | Ship to contact last name | |
CUSTOMER_PAYMENT_TERM | VARCHAR2 | (30) | Payment term | |
CUSTOMER_JOB | VARCHAR2 | (50) | Customer job | |
CREDIT_INVOICE_LINE_ID | NUMBER | This column stores the invoice line id this return line applies credit to | ||
SHIP_TO_PROVINCE | VARCHAR2 | (60) | Province of the Ship To Customer Address. | |
INVOICE_CITY | VARCHAR2 | (60) | City of the Bill to Customer. | |
INVOICE_PROVINCE | VARCHAR2 | (60) | Province of the Bill to Customer Address. | |
REFERENCE_HEADER | VARCHAR2 | (30) | Reference header | |
REFERENCE_LINE | VARCHAR2 | (30) | Reference line | |
SHIP_TO_CONTACT_ID | NUMBER | Ship to contact id | ||
CREATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
SERVICE_TXN_REASON_CODE | VARCHAR2 | (30) | To store service transaction reason. | |
SERVICE_TXN_COMMENTS | VARCHAR2 | (2000) | Placeholder for service comments. | |
SERVICE_DURATION | NUMBER | Internal use only | ||
SERVICE_START_DATE | DATE | Start Date for the Service | ||
SERVICE_END_DATE | DATE | Internal use only | ||
SERVICE_COTERMINATE_FLAG | VARCHAR2 | (1) | To identify whether the service can be coterminated. | |
SERVICE_NUMBER | NUMBER | Unique number to identify the service lines. | ||
SERVICE_PERIOD | VARCHAR2 | (3) | Period for which service is offered. | |
SERVICE_REFERENCE_TYPE_CODE | VARCHAR2 | (30) | To identify the service reference type. Typical values are Order and Customer Product | |
SERVICE_REFERENCE_LINE_ID | NUMBER | Identifies the immediate parent line to which the service is attached. | ||
SERVICE_REFERENCE_SYSTEM_ID | NUMBER | To store system id for either reference type like order or customer product. | ||
SHIP_FROM_ADDRESS_1 | VARCHAR2 | (240) | Address Line 1 for the Ship From Address. | |
SHIP_FROM_ADDRESS_2 | VARCHAR2 | (240) | Address Line 2 for the Ship From Address. | |
SHIP_FROM_ADDRESS_3 | VARCHAR2 | (240) | Address Line 3 for the Ship From Address. | |
SHIP_FROM_CITY | VARCHAR2 | (60) | City of the Ship From Address. | |
SHIP_FROM_POSTAL_CODE | VARCHAR2 | (60) | Postal Code for the Ship From Address. | |
SHIP_FROM_COUNTRY | VARCHAR2 | (60) | Country of the Ship From Address. | |
SHIP_FROM_REGION1 | VARCHAR2 | (240) | Region 1 for the Ship From Address. | |
SHIP_FROM_REGION2 | VARCHAR2 | (240) | Region 2 for the Ship From Address. | |
SHIP_FROM_REGION3 | VARCHAR2 | (240) | Region 3 for the Ship From Address. | |
SHIP_FROM_EDI_LOCATION_CODE | VARCHAR2 | (40) | EDI Location Code for the Ship From Address. | |
SHIP_FROM_ADDRESS_ID | NUMBER | Internal Address ID of the Ship From Address. | ||
SERVICE_REFERENCE_ORDER | VARCHAR2 | (50) | Order Number for the Service Line. | |
SERVICE_REFERENCE_LINE | VARCHAR2 | (50) | Line Number for the Service Line. | |
SERVICE_REFERENCE_SYSTEM | VARCHAR2 | (50) | System Number for the Service Line. | |
DELIVER_TO_CUSTOMER | VARCHAR2 | (360) | Deliver To customer. | |
SERVICED_LINE_ID | NUMBER | Id of the Line, for which the service line. | ||
SHIP_TO_ADDRESS_ID | NUMBER | Internal Address ID of the Ship To. | ||
SHIP_TO_ADDRESS_CODE | VARCHAR2 | (240) | Address Code for the Ship To. | |
SHIP_TO_ADDRESS_NAME | VARCHAR2 | (360) | Address Name of the Ship To. | |
INVOICE_ADDRESS_CODE | VARCHAR2 | (40) | Address Code for the Invoice To. | |
INVOICE_ADDRESS_NAME | VARCHAR2 | (360) | Address Name of the Invoice To. | |
ORDER_SOURCE | VARCHAR2 | (30) | Order source | |
TP_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
TP_ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
TP_ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
USER_ITEM_DESCRIPTION | VARCHAR2 | (1000) | To store user entered item description. | |
BLANKET_NUMBER | NUMBER | Reference to a Blanket Sales Agreement | ||
BLANKET_LINE_NUMBER | NUMBER | Reference to a Blanket Sales Agreement Line | ||
ORIGINAL_INVENTORY_ITEM_ID | NUMBER | Stores the Original Inventory Item when there is a substitution. | ||
ORIGINAL_ITEM_IDENTIFIER_TYPE | VARCHAR2 | (30) | Stores the Original Item Identifier Type when there is a substitution. | |
ORIGINAL_ORDERED_ITEM_ID | NUMBER | Stores the Original Ordered Item when there is a substitution. | ||
ORIGINAL_ORDERED_ITEM | VARCHAR2 | (2000) | Stores the Original Ordered Item when there is a substitution. | |
ITEM_RELATIONSHIP_TYPE | NUMBER | Stores the Item Relationship type | ||
ORDERED_ITEM | VARCHAR2 | (2000) | Stores name of Ordered Item | |
INVOICE_INTERFACE_STATUS_CODE | VARCHAR2 | (30) | To indicate whether the invoicing activity is complete | |
PREFERRED_GRADE | VARCHAR2 | (150) | Grade requested by the customer | |
ORDERED_QUANTITY2 | NUMBER | Ordered quantity in secondary inventory unit of measure | ||
ORDERED_QUANTITY_UOM2 | VARCHAR2 | (3) | Ordered Quantity unit of measure | |
SHIPPING_QUANTITY2 | NUMBER | Shipping quantity in secondary shipping unit of measure | ||
CANCELLED_QUANTITY2 | NUMBER | Cancelled Quantity | ||
SHIPPED_QUANTITY2 | NUMBER | Shipped quantity in ordered_quantity_uom2 | ||
SHIPPING_QUANTITY_UOM2 | VARCHAR2 | (3) | Secondary unit of measure the item is shipped | |
FULFILLED_QUANTITY2 | NUMBER | Fulfilled quantity in ordered_quantity_uom2 | ||
REVENUE_AMOUNT | NUMBER | For future use | ||
FULFILLMENT_DATE | DATE | Fulfillment Date for the Line | ||
ITEM_SUBSTITUTION_TYPE_CODE | VARCHAR2 | (30) | Used to store the Item Substitution Type. It can be used to override the preferences specified in Item Substitution setup. It can also be used to turn-off substitution for the line. | |
AUTO_SELECTED_QUANTITY | NUMBER | Not used | ||
ORDERED_ITEM_ID | NUMBER | Stores Id of Ordered Item | ||
ITEM_IDENTIFIER_TYPE | VARCHAR2 | (30) | To distinguish different types of items (internal, customer. and generic items) | |
END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | Uniquely identifies which bill of material to be used for building a specific Model/Unit Number effectivity controlled item | |
SHIPPING_INSTRUCTIONS | VARCHAR2 | (2000) | Shipping instructions for Line | |
PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | Packing Instructions for Line. | |
INVOICED_QUANTITY | NUMBER | To indicate whether the invoicing activity is complete or not. | ||
REFERENCE_CUSTOMER_TRX_LINE_ID | NUMBER | This column stores the invoice line id this return line references | ||
SPLIT_BY | VARCHAR2 | (30) | Indicates whether the line is system or user level split | |
LINE_SET_ID | NUMBER | Line Set id | ||
UNIT_LIST_PERCENT | NUMBER | Price list percent of the item (percent-based pricing only) | ||
UNIT_SELLING_PERCENT | NUMBER | Percent actually charged to customer (percent based pricing only) | ||
UNIT_PERCENT_BASE_PRICE | NUMBER | Based price used for percent based pricing | ||
RE_SOURCE_FLAG | VARCHAR2 | (1) | Indicates whether user entered the warehouse or the system did | |
FLOW_STATUS_CODE | VARCHAR2 | (30) | Workflow status for the line | |
UNIT_LIST_PRICE_PER_PQTY | NUMBER | Unit list price per pricing quantity. | ||
UNIT_SELLING_PRICE_PER_PQTY | NUMBER | Unit selling price per pricing quantity. | ||
SHIP_TO_PARTY_NUMBER | VARCHAR2 | (30) | Unique identifier for the Ship To Party | |
INVOICE_TO_PARTY_NUMBER | VARCHAR2 | (30) | Unique identifier for the Invoice To Party | |
DELIVER_TO_PARTY_NUMBER | VARCHAR2 | (30) | Unique identifier for the Deliver To Party | |
END_CUSTOMER_NUMBER | VARCHAR2 | (50) | Unique identifier for the End Customer | |
END_CUSTOMER_PARTY_NUMBER | VARCHAR2 | (30) | Unique identifier for the End Customer Party | |
END_CUSTOMER_ID | NUMBER | Unique identifier for the End Customer | ||
END_CUSTOMER_CONTACT_ID | NUMBER | End Customer Contact Id | ||
END_CUSTOMER_SITE_USE_ID | NUMBER | End Customer Site Org Id | ||
END_CUSTOMER_ADDRESS1 | VARCHAR2 | (240) | Address Line 1 of End Customer Location | |
END_CUSTOMER_ADDRESS2 | VARCHAR2 | (240) | Address Line 1 of End Customer Location | |
END_CUSTOMER_ADDRESS3 | VARCHAR2 | (240) | Address Line 1 of End Customer Location | |
END_CUSTOMER_ADDRESS4 | VARCHAR2 | (240) | Address Line 1 of End Customer Location | |
END_CUSTOMER_STATE | VARCHAR2 | (60) | State of End Customer Location | |
END_CUSTOMER_COUNTY | VARCHAR2 | (60) | County of End Customer Location | |
END_CUSTOMER_PROVINCE | VARCHAR2 | (60) | Province of End Customer Location | |
END_CUSTOMER_POSTAL_CODE | VARCHAR2 | (60) | Postal Code of End Customer Location | |
END_CUSTOMER_COUNTRY | VARCHAR2 | (60) | Country of End Customer Location | |
END_CUSTOMER_CONTACT | VARCHAR2 | (360) | End Customer Contact Name | |
END_CUSTOMER_CONTACT_LAST_NAME | VARCHAR2 | (240) | End Customer Contact Last Name | |
END_CUSTOMER_CONTACT_FIRST_NAM | VARCHAR2 | (240) | End Customer Contact Last Name | |
END_CUSTOMER_NAME | VARCHAR2 | (360) | End Customer Name | |
IB_OWNER | VARCHAR2 | (60) | Default Owner | |
IB_INSTALLED_AT_LOCATION | VARCHAR2 | (60) | Default Installed At Location | |
IB_CURRENT_LOCATION | VARCHAR2 | (60) | Default Current Location | |
ORDER_FIRMED_DATE | DATE | Not used | ||
ACTUAL_FULFILLMENT_DATE | DATE | Not used | ||
COMMITMENT | VARCHAR2 | (240) | Description for contractual guarantee ID. | |
COMMITMENT_ID | NUMBER | A contractual guarantee with a customer for future purchase | ||
DELIVER_TO_ADDRESS1 | VARCHAR2 | (240) | Delivery address | |
DELIVER_TO_ADDRESS2 | VARCHAR2 | (240) | Delivery address | |
DELIVER_TO_ADDRESS3 | VARCHAR2 | (240) | Delivery address | |
DELIVER_TO_ADDRESS4 | VARCHAR2 | (240) | Delivery address | |
DELIVER_TO_CITY | VARCHAR2 | (60) | Delivery address | |
DELIVER_TO_COUNTRY | VARCHAR2 | (60) | Delivery address | |
DELIVER_TO_COUNTY | VARCHAR2 | (60) | Delivery address | |
DELIVER_TO_POSTAL_CODE | VARCHAR2 | (60) | Delivery address | |
DELIVER_TO_PROVINCE | VARCHAR2 | (60) | Delivery address | |
DELIVER_TO_STATE | VARCHAR2 | (60) | Delivery address | |
INVOICE_ADDRESS_1 | VARCHAR2 | (240) | Invoice To Address1 | |
INVOICE_ADDRESS_2 | VARCHAR2 | (240) | Invoice To Address2 | |
INVOICE_ADDRESS_3 | VARCHAR2 | (240) | Invoice To Address3 | |
INVOICE_ADDRESS_4 | VARCHAR2 | (240) | Invoice To Address4 | |
INVOICE_COUNTRY | VARCHAR2 | (60) | Invoice To Country | |
INVOICE_COUNTY | VARCHAR2 | (60) | Invoice To County | |
INVOICE_POSTAL_CODE | VARCHAR2 | (60) | Invoice To Postal Code | |
INVOICE_STATE | VARCHAR2 | (60) | Invoice To State | |
BILL_TO_EDI_LOCATION_CODE | VARCHAR2 | (40) | EDI Location Code for the Bill to Customer | |
DELIVER_TO_CUSTOMER_ID | NUMBER | Id for the Deliver to Customer | ||
DELIVER_TO_CUSTOMER_NAME | VARCHAR2 | (360) | Name for the Deliver to Customer | |
DELIVER_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | Number for the Deliver to Customer | |
END_CUSTOMER_CITY | VARCHAR2 | (60) | City of End Customer Location | |
INTMED_SHIP_TO_CONTACT_ID | NUMBER | Intmediate ship to contact id | ||
INTMED_SHIP_TO_ORG_ID | NUMBER | Intmediate ship to org id | ||
INVOICE_TO_CUSTOMER_ID | NUMBER | Id for the Bill to Customer | ||
INVOICE_TO_CUSTOMER_NAME | VARCHAR2 | (360) | Name for the Bill to Customer | |
INVOICE_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | Number for the Bill to Customer | |
SHIP_TO_CUSTOMER_ID | NUMBER | Id for the Ship to Customer | ||
SHIP_TO_CUSTOMER_NAME | VARCHAR2 | (360) | Name for the Ship to Customer | |
SHIP_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | Number for the Ship to Customer | |
IB_OWNER_CODE | VARCHAR2 | (30) | Ib Owner Code | |
IB_CURRENT_LOCATION_CODE | VARCHAR2 | (30) | Ib Current Location Code | |
IB_INSTALLED_AT_LOCATION_CODE | VARCHAR2 | (30) | Ib Installed At Location Code | |
CHARGE_PERIODICITY_CODE | VARCHAR2 | (3) | Charge Periodicity | |
CONFIG_HEADER_ID | NUMBER | Config Header Id | ||
CONFIG_REV_NBR | NUMBER | Config Rev Nbr | ||
SERVICE_BILL_PROFILE_ID | NUMBER | Stores the Billing Profile ID for Service Lines | ||
SERVICE_BILLING_PROFILE | VARCHAR2 | (240) | Stores the Billing Profile value for Service Lines | |
SERVICE_COV_TEMPLATE_ID | NUMBER | Stores Service Coverage Template ID for Extended Warranty Lines | ||
SERVICE_COVERAGE_TEMPLATE | VARCHAR2 | (240) | Stores Service Coverage Template for Extended Warranty Lines | |
SERVICE_SUBS_TEMPLATE_ID | NUMBER | Stores Subscription Template ID for Subscription Service Lines | ||
SERVICE_SUBSCRIPTION_TEMPLATE | VARCHAR2 | (240) | Stores Subscription Template for Subscription Service Lines | |
SERVICE_BILL_OPTION_CODE | VARCHAR2 | (10) | Stores the Serivce Billing Option Code that specifies how the Service Lines should be billed, should they be billed completly from Order Management, completely from Service Contracts, or first period from OM and subsequent periods from Service Contracts | |
SERVICE_BILL_OPTION | VARCHAR2 | (240) | Stores the Serivce Billing Option that specifies how the Service Lines should be billed, should they be billed completly from Order Management, completely from Service Contracts, or first period from OM and subsequent periods from Service Contracts | |
SERVICE_FIRST_PERIOD_AMOUNT | NUMBER | Stores the value for which the Service Line would get billed from Order Management in case of first period billing from Order Management | ||
SERVICE_FIRST_PERIOD_ENDDATE | DATE | Stores First Period Bill End Date when Service Lines are partially Billed from OM | ||
SUBSCRIPTION_ENABLE_FLAG | VARCHAR2 | (1) | Stores a value of either 'Y' or 'N' to indicate if the Line has to be treated as Subscription Service Line or a Standard Line |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF
, ORG_ID
, CHANGE_SEQUENCE
, CHANGE_DATE
, ORDER_NUMBER
, HEADER_ID
, ACCOUNTING_RULE
, ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, ACKNOWLEDGMENT_FLAG
, AGREEMENT
, AGREEMENT_ID
, ARRIVAL_SET_ID
, ARRIVAL_SET_NAME
, CUSTOMER_ITEM_NET_PRICE
, PRICE_LIST
, PRICE_LIST_ID
, CUSTOMER_PAYMENT_TERM_ID
, SHIP_FROM_ORG
, SHIP_FROM_ORG_ID
, SHIP_TO_ORG
, SHIP_TO_ORG_ID
, CUSTOMER_SHIPMENT_NUMBER
, DROP_SHIP_FLAG
, SOLD_FROM_ORG
, SOLD_FROM_ORG_ID
, SOLD_TO_ORG
, SOLD_TO_ORG_ID
, ATO_LINE_ID
, AUTHORIZED_TO_SHIP_FLAG
, BOOKED_FLAG
, CALCULATE_PRICE_FLAG
, CANCELLED_FLAG
, CANCELLED_QUANTITY
, CLOSED_FLAG
, COMPONENT_CODE
, COMPONENT_NUMBER
, COMPONENT_SEQUENCE_ID
, CONFIG_DISPLAY_SEQUENCE
, CONFIGURATION_ID
, CONFIG_LINE_REF
, TOP_MODEL_LINE_ID
, CONTRACT_PO_NUMBER
, CUST_PO_NUMBER
, CUSTOMER_ITEM
, CUSTOMER_ITEM_ID
, CUSTOMER_ITEM_REVISION
, CUSTOMER_LINE_NUMBER
, DELIVER_TO_CONTACT
, DELIVER_TO_CONTACT_ID
, DELIVER_TO_ORG
, DELIVER_TO_ORG_ID
, DELIVERY_LEAD_TIME
, DEMAND_BUCKET_TYPE
, DEMAND_BUCKET_TYPE_CODE
, DEMAND_CLASS
, DEMAND_CLASS_CODE
, DEMAND_STREAM
, EARLIEST_ACCEPTABLE_DATE
, FOB_POINT
, FOB_POINT_CODE
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS
, FREIGHT_TERMS_CODE
, FULFILLED_QUANTITY
, FULFILLMENT_SET_ID
, FULFILLMENT_SET_NAME
, INDUSTRY_CONTEXT
, INVENTORY_ITEM
, INVENTORY_ITEM_ID
, INVOICE_SET_ID
, INVOICE_SET_NAME
, INVOICE_NUMBER
, INVOICE_TO_CONTACT
, INVOICE_TO_CONTACT_ID
, INVOICE_TO_ORG
, INVOICE_TO_ORG_ID
, INVOICING_RULE
, INVOICING_RULE_ID
, ITEM_INPUT
, ITEM_REVISION
, ITEM_TYPE_CODE
, LATEST_ACCEPTABLE_DATE
, LINE_CATEGORY_CODE
, LINE_ID
, LINE_NUMBER
, LINE_PO_CONTEXT
, LINE_TYPE
, LINE_TYPE_ID
, LINK_TO_LINE_ID
, LINK_TO_LINE_REF
, LOAD_SEQ_NUMBER
, LOT
, MODEL_GROUP_NUMBER
, OPEN_FLAG
, OPERATION_CODE
, OPTION_FLAG
, OPTION_NUMBER
, ORDER_QUANTITY_UOM
, ORDERED_QUANTITY
, PAYMENT_TERM
, PAYMENT_TERM_ID
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_CONTEXT
, PRICING_DATE
, PRICING_QUANTITY
, PRICING_QUANTITY_UOM
, PROJECT
, PROJECT_ID
, PROMISE_DATE
, REFERENCE_HEADER_ID
, REFERENCE_LINE_ID
, REFERENCE_TYPE
, RELATED_PO_NUMBER
, REQUEST_DATE
, REQUEST_ID
, RESERVED_QUANTITY
, RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15
, RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9
, RETURN_CONTEXT
, RETURN_REASON_CODE
, SALESREP_ID
, SALESREP
, SCHEDULE_ARRIVAL_DATE
, SCHEDULE_SHIP_DATE
, SCHEDULE_ITEM_DETAIL
, SCHEDULE_STATUS_CODE
, SHIP_MODEL_COMPLETE_FLAG
, SHIP_SET_ID
, SHIP_SET_NAME
, SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SHIPMENT_NUMBER
, SHIPMENT_PRIORITY
, SHIPMENT_PRIORITY_CODE
, SHIPPED_QUANTITY
, SHIPPING_METHOD
, SHIPPING_METHOD_CODE
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY_UOM
, SORT_ORDER
, SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_LINE_ID
, SOURCE_DOCUMENT_TYPE_ID
, SOURCE_TYPE_CODE
, SPLIT_FROM_LINE_ID
, SUBINVENTORY
, SUBMISSION_DATETIME
, TASK
, TASK_ID
, TAX
, TAX_CODE
, TAX_DATE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON
, TAX_EXEMPT_REASON_CODE
, TAX_POINT
, TAX_POINT_CODE
, TAX_RATE
, TAX_VALUE
, UNIT_LIST_PRICE
, UNIT_SELLING_PRICE
, VEH_CUS_ITEM_CUM_KEY_ID
, VISIBLE_DEMAND_FLAG
, FIRST_ACK_CODE
, LAST_ACK_CODE
, FIRST_ACK_DATE
, LAST_ACK_DATE
, SPLIT_FROM_LINE_REF
, SPLIT_FROM_SHIPMENT_REF
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE2
, ATTRIBUTE20
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE30
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, INVENTORY_ITEM_SEGMENT_1
, INVENTORY_ITEM_SEGMENT_10
, INVENTORY_ITEM_SEGMENT_11
, INVENTORY_ITEM_SEGMENT_12
, INVENTORY_ITEM_SEGMENT_13
, INVENTORY_ITEM_SEGMENT_14
, INVENTORY_ITEM_SEGMENT_15
, INVENTORY_ITEM_SEGMENT_16
, INVENTORY_ITEM_SEGMENT_17
, INVENTORY_ITEM_SEGMENT_18
, INVENTORY_ITEM_SEGMENT_19
, INVENTORY_ITEM_SEGMENT_2
, INVENTORY_ITEM_SEGMENT_20
, INVENTORY_ITEM_SEGMENT_3
, INVENTORY_ITEM_SEGMENT_4
, INVENTORY_ITEM_SEGMENT_5
, INVENTORY_ITEM_SEGMENT_6
, INVENTORY_ITEM_SEGMENT_7
, INVENTORY_ITEM_SEGMENT_8
, INVENTORY_ITEM_SEGMENT_9
, CUST_MODEL_SERIAL_NUMBER
, CUSTOMER_DOCK
, CUSTOMER_DOCK_CODE
, CUST_PRODUCTION_SEQ_NUM
, CUSTOMER_PRODUCTION_LINE
, ACTUAL_SHIPMENT_DATE
, ACTUAL_ARRIVAL_DATE
, SHIP_TO_CITY
, SHIP_TO_POSTAL_CODE
, SHIP_TO_COUNTRY
, SHIP_TO_COUNTY
, SHIP_TO_STATE
, SHIP_TO_EDI_LOCATION_CODE
, SHIP_TO_CONTACT
, SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_LAST_NAME
, CUSTOMER_PAYMENT_TERM
, CUSTOMER_JOB
, CREDIT_INVOICE_LINE_ID
, SHIP_TO_PROVINCE
, INVOICE_CITY
, INVOICE_PROVINCE
, REFERENCE_HEADER
, REFERENCE_LINE
, SHIP_TO_CONTACT_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS
, SERVICE_DURATION
, SERVICE_START_DATE
, SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG
, SERVICE_NUMBER
, SERVICE_PERIOD
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID
, SHIP_FROM_ADDRESS_1
, SHIP_FROM_ADDRESS_2
, SHIP_FROM_ADDRESS_3
, SHIP_FROM_CITY
, SHIP_FROM_POSTAL_CODE
, SHIP_FROM_COUNTRY
, SHIP_FROM_REGION1
, SHIP_FROM_REGION2
, SHIP_FROM_REGION3
, SHIP_FROM_EDI_LOCATION_CODE
, SHIP_FROM_ADDRESS_ID
, SERVICE_REFERENCE_ORDER
, SERVICE_REFERENCE_LINE
, SERVICE_REFERENCE_SYSTEM
, DELIVER_TO_CUSTOMER
, SERVICED_LINE_ID
, SHIP_TO_ADDRESS_ID
, SHIP_TO_ADDRESS_CODE
, SHIP_TO_ADDRESS_NAME
, INVOICE_ADDRESS_CODE
, INVOICE_ADDRESS_NAME
, ORDER_SOURCE
, TP_CONTEXT
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, USER_ITEM_DESCRIPTION
, BLANKET_NUMBER
, BLANKET_LINE_NUMBER
, ORIGINAL_INVENTORY_ITEM_ID
, ORIGINAL_ITEM_IDENTIFIER_TYPE
, ORIGINAL_ORDERED_ITEM_ID
, ORIGINAL_ORDERED_ITEM
, ITEM_RELATIONSHIP_TYPE
, ORDERED_ITEM
, INVOICE_INTERFACE_STATUS_CODE
, PREFERRED_GRADE
, ORDERED_QUANTITY2
, ORDERED_QUANTITY_UOM2
, SHIPPING_QUANTITY2
, CANCELLED_QUANTITY2
, SHIPPED_QUANTITY2
, SHIPPING_QUANTITY_UOM2
, FULFILLED_QUANTITY2
, REVENUE_AMOUNT
, FULFILLMENT_DATE
, ITEM_SUBSTITUTION_TYPE_CODE
, AUTO_SELECTED_QUANTITY
, ORDERED_ITEM_ID
, ITEM_IDENTIFIER_TYPE
, END_ITEM_UNIT_NUMBER
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, INVOICED_QUANTITY
, REFERENCE_CUSTOMER_TRX_LINE_ID
, SPLIT_BY
, LINE_SET_ID
, UNIT_LIST_PERCENT
, UNIT_SELLING_PERCENT
, UNIT_PERCENT_BASE_PRICE
, RE_SOURCE_FLAG
, FLOW_STATUS_CODE
, UNIT_LIST_PRICE_PER_PQTY
, UNIT_SELLING_PRICE_PER_PQTY
, SHIP_TO_PARTY_NUMBER
, INVOICE_TO_PARTY_NUMBER
, DELIVER_TO_PARTY_NUMBER
, END_CUSTOMER_NUMBER
, END_CUSTOMER_PARTY_NUMBER
, END_CUSTOMER_ID
, END_CUSTOMER_CONTACT_ID
, END_CUSTOMER_SITE_USE_ID
, END_CUSTOMER_ADDRESS1
, END_CUSTOMER_ADDRESS2
, END_CUSTOMER_ADDRESS3
, END_CUSTOMER_ADDRESS4
, END_CUSTOMER_STATE
, END_CUSTOMER_COUNTY
, END_CUSTOMER_PROVINCE
, END_CUSTOMER_POSTAL_CODE
, END_CUSTOMER_COUNTRY
, END_CUSTOMER_CONTACT
, END_CUSTOMER_CONTACT_LAST_NAME
, END_CUSTOMER_CONTACT_FIRST_NAM
, END_CUSTOMER_NAME
, IB_OWNER
, IB_INSTALLED_AT_LOCATION
, IB_CURRENT_LOCATION
, ORDER_FIRMED_DATE
, ACTUAL_FULFILLMENT_DATE
, COMMITMENT
, COMMITMENT_ID
, DELIVER_TO_ADDRESS1
, DELIVER_TO_ADDRESS2
, DELIVER_TO_ADDRESS3
, DELIVER_TO_ADDRESS4
, DELIVER_TO_CITY
, DELIVER_TO_COUNTRY
, DELIVER_TO_COUNTY
, DELIVER_TO_POSTAL_CODE
, DELIVER_TO_PROVINCE
, DELIVER_TO_STATE
, INVOICE_ADDRESS_1
, INVOICE_ADDRESS_2
, INVOICE_ADDRESS_3
, INVOICE_ADDRESS_4
, INVOICE_COUNTRY
, INVOICE_COUNTY
, INVOICE_POSTAL_CODE
, INVOICE_STATE
, BILL_TO_EDI_LOCATION_CODE
, DELIVER_TO_CUSTOMER_ID
, DELIVER_TO_CUSTOMER_NAME
, DELIVER_TO_CUSTOMER_NUMBER
, END_CUSTOMER_CITY
, INTMED_SHIP_TO_CONTACT_ID
, INTMED_SHIP_TO_ORG_ID
, INVOICE_TO_CUSTOMER_ID
, INVOICE_TO_CUSTOMER_NAME
, INVOICE_TO_CUSTOMER_NUMBER
, SHIP_TO_CUSTOMER_ID
, SHIP_TO_CUSTOMER_NAME
, SHIP_TO_CUSTOMER_NUMBER
, IB_OWNER_CODE
, IB_CURRENT_LOCATION_CODE
, IB_INSTALLED_AT_LOCATION_CODE
, CHARGE_PERIODICITY_CODE
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
, SERVICE_BILL_PROFILE_ID
, SERVICE_BILLING_PROFILE
, SERVICE_COV_TEMPLATE_ID
, SERVICE_COVERAGE_TEMPLATE
, SERVICE_SUBS_TEMPLATE_ID
, SERVICE_SUBSCRIPTION_TEMPLATE
, SERVICE_BILL_OPTION_CODE
, SERVICE_BILL_OPTION
, SERVICE_FIRST_PERIOD_AMOUNT
, SERVICE_FIRST_PERIOD_ENDDATE
, SUBSCRIPTION_ENABLE_FLAG
FROM APPS.OE_LINE_ACKS_V;
APPS.OE_LINE_ACKS_V is not referenced by any database object
|
|
|