[Home] [Help]
View: MRP_AP_SUB_INVENTORIES_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT X.ORGANIZATION_ID
, X.SECONDARY_INVENTORY_NAME
, X.DESCRIPTION
, X.DISABLE_DATE
, X.NETTING_TYPE
, X.DEMAND_CLASS
, X.PROJECT_ID
, X.TASK_ID
, X.RN RN2
, MP.RN RN1
FROM MRP_AP_SCND_INVS_SN X
, MRP_AP_MRP_PARAS_SN MP
WHERE X.ORGANIZATION_ID= MP.ORGANIZATION_ID
Columns
Name |
ORGANIZATION_ID |
SECONDARY_INVENTORY_NAME |
DESCRIPTION |
DISABLE_DATE |
NETTING_TYPE |
DEMAND_CLASS |
PROJECT_ID |
TASK_ID |
RN2 |
RN1 |