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

VIEW: APPS.MRP_ATP_BACKLOG_TEMP_V

Object Details
Object Name: MRP_ATP_BACKLOG_TEMP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_ATP_BACKLOG_TEMP_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
SESSION_ID NUMBER

Session Id
OVERRIDE_FLAG VARCHAR2 (1)
Override Flag
SEQUENCE_NUMBER NUMBER

Sequence Number
ORDER_NUMBER NUMBER

Order Number
ORDER_LINE_NUMBER NUMBER

Order Line Number
ORDER_LINE_ID NUMBER

Order Line Id
SHIPMENT_NUMBER NUMBER

Shipment Number
OPTION_NUMBER NUMBER

SHIP_SET_NAME VARCHAR2 (30)
Ship Set Name
SHIP_SET_ID NUMBER

Ship Set Id
ARRIVAL_SET_NAME VARCHAR2 (30)
Arrival Set Name
ARRIVAL_SET_ID NUMBER

Arrival Set Id
INVENTORY_ITEM_NAME VARCHAR2 (250)
Inventory Item Name
SOURCE_ORGANIZATION_CODE VARCHAR2 (7)
Source Organization Code
SOURCE_ORGANIZATION_ID NUMBER

Source Organization Id
QUANTITY_ORDERED NUMBER

Quantity Ordered
UOM_CODE VARCHAR2 (3)
Uom Code
REQUESTED_SHIP_DATE DATE

Requested Ship Date
REQUESTED_ARRIVAL_DATE DATE

Requested Arrival Date
SCHEDULED_SHIP_DATE DATE

Scheduled Ship Date
SCHEDULED_ARRIVAL_DATE DATE

Scheduled Arrival Date
PROMISE_DATE DATE

Promise Date
FIRM_SOURCE_ORG_ID NUMBER

Firm Source Org Id
FIRM_SOURCE_ORG_CODE VARCHAR2 (7)
Firm Source Org Code
FIRM_SHIP_DATE DATE

Firm Ship Date
FIRM_ARRIVAL_DATE DATE

Firm Arrival Date
CUSTOMER_NAME VARCHAR2 (255)
CUSTOMER_LOCATION VARCHAR2 (40)
SHIP_METHOD VARCHAR2 (30)
DEMAND_CLASS VARCHAR2 (30)
LATEST_ACCEPTABLE_DATE DATE

Query Text

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


SELECT SESSION_ID
,      OVERRIDE_FLAG
,      SEQUENCE_NUMBER
,      ORDER_NUMBER
,      ORDER_LINE_NUMBER
,      ORDER_LINE_ID
,      SHIPMENT_NUMBER
,      OPTION_NUMBER
,      SHIP_SET_NAME
,      SHIP_SET_ID
,      ARRIVAL_SET_NAME
,      ARRIVAL_SET_ID
,      INVENTORY_ITEM_NAME
,      SOURCE_ORGANIZATION_CODE
,      SOURCE_ORGANIZATION_ID
,      QUANTITY_ORDERED
,      UOM_CODE
,      REQUESTED_SHIP_DATE
,      REQUESTED_ARRIVAL_DATE
,      SCHEDULED_SHIP_DATE
,      SCHEDULED_ARRIVAL_DATE
,      PROMISE_DATE
,      FIRM_SOURCE_ORG_ID
,      FIRM_SOURCE_ORG_CODE
,      FIRM_SHIP_DATE
,      FIRM_ARRIVAL_DATE
,      CUSTOMER_NAME
,      CUSTOMER_LOCATION
,      SHIP_METHOD
,      DEMAND_CLASS
,      LATEST_ACCEPTABLE_DATE
FROM APPS.MRP_ATP_BACKLOG_TEMP_V;

Dependencies

[top of page]

APPS.MRP_ATP_BACKLOG_TEMP_V references the following:

SchemaAPPS
SynonymMRP_ATP_SCHEDULE_TEMP

APPS.MRP_ATP_BACKLOG_TEMP_V is not referenced by any database object