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

VIEW: APPS.M4R_3A6_OE_LINE_ACKS

Object Details
Object Name: M4R_3A6_OE_LINE_ACKS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCLN.M4R_3A6_OE_LINE_ACKS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ITEM VARCHAR2 (2000)
CHANGE_SEQUENCE VARCHAR2 (50)
FIRST_ACK_CODE VARCHAR2 (30)
LINE_NUMBER NUMBER

ORDERED_QUANTITY NUMBER

ORDER_QUANTITY_UOM VARCHAR2 (3)
ORIG_SYS_LINE_REF VARCHAR2 (50)
ORIG_SYS_SHIPMENT_REF VARCHAR2 (50)
REQUEST_DATE DATE

SCHEDULE_ARRIVAL_DATE DATE

SHIPMENT_NUMBER NUMBER

UNIT_SELLING_PRICE NUMBER

USER_ITEM_DESCRIPTION VARCHAR2 (1000)
CUSTOMER_LINE_NUMBER VARCHAR2 (50)
CUSTOMER_SHIPMENT_NUMBER VARCHAR2 (50)
SPLIT_FROM_LINE_REF VARCHAR2 (50)
LINK_TO_LINE_ID NUMBER

TOP_MODEL_LINE_ID NUMBER

ORIG_SYS_DOCUMENT_REF VARCHAR2 (50)
ACKNOWLEDGMENT_TYPE VARCHAR2 (30)
REQUEST_ID NUMBER

SOLD_TO_ORG_ID NUMBER

MODEL_REFERENCE_TEXT VARCHAR2 (124)
Query Text

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


SELECT CUSTOMER_ITEM
,      CHANGE_SEQUENCE
,      FIRST_ACK_CODE
,      LINE_NUMBER
,      ORDERED_QUANTITY
,      ORDER_QUANTITY_UOM
,      ORIG_SYS_LINE_REF
,      ORIG_SYS_SHIPMENT_REF
,      REQUEST_DATE
,      SCHEDULE_ARRIVAL_DATE
,      SHIPMENT_NUMBER
,      UNIT_SELLING_PRICE
,      USER_ITEM_DESCRIPTION
,      CUSTOMER_LINE_NUMBER
,      CUSTOMER_SHIPMENT_NUMBER
,      SPLIT_FROM_LINE_REF
,      LINK_TO_LINE_ID
,      TOP_MODEL_LINE_ID
,      ORIG_SYS_DOCUMENT_REF
,      ACKNOWLEDGMENT_TYPE
,      REQUEST_ID
,      SOLD_TO_ORG_ID
,      MODEL_REFERENCE_TEXT
FROM APPS.M4R_3A6_OE_LINE_ACKS;

Dependencies

[top of page]

APPS.M4R_3A6_OE_LINE_ACKS references the following:

SchemaAPPS
SynonymOE_LINE_ACKS
SynonymOE_ORDER_LINES_ALL

APPS.M4R_3A6_OE_LINE_ACKS is not referenced by any database object