[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 |