Skip to content

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

TABLE: POS.POS_MFG_CAPACITY_TEMP

Object Details
Object Name: POS_MFG_CAPACITY_TEMP
Object Type: TABLE
Owner: POS
FND Design Data: TablePOS.POS_MFG_CAPACITY_TEMP
Subobject Name:
Status: VALID


This Table is used to Store Cange in Capacity for Orders


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
MFG_CAPACITY_ID NUMBER
Yes Manufacturing Capacity Id
ASL_ID NUMBER
Yes Asl Id
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
STATUS VARCHAR2 (20)
Status
FROM_DATE DATE

From Date
TO_DATE DATE

To Date
CAPACITY_PER_DAY NUMBER

Capacity Per Day
CAPACITY_ID NUMBER

Capacity Id
Query Text

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


SELECT MFG_CAPACITY_ID
,      ASL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      STATUS
,      FROM_DATE
,      TO_DATE
,      CAPACITY_PER_DAY
,      CAPACITY_ID
FROM POS.POS_MFG_CAPACITY_TEMP;

Dependencies

[top of page]

POS.POS_MFG_CAPACITY_TEMP does not reference any database object

POS.POS_MFG_CAPACITY_TEMP is referenced by following:

SchemaPOS
ViewPOS_MFG_CAPACITY_TEMP#