[Home] [Help]
View: MRP_AP_UNIT_NUMBERS_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT X.UNIT_NUMBER
, X.END_ITEM_ID
, X.MASTER_ORGANIZATION_ID
, X.COMMENTS
, X.RN RN3
, Y.RN2 RN2
, Y.RN1 RN1
FROM MRP_AP_UNIT_NUMS_SN X
, ( SELECT INVENTORY_ITEM_ID
, MASTER_ORGANIZATION_ID
, MAX( MSI.RN) RN2
, MAX( ORG.RN) RN1
FROM MRP_AP_SYS_ITEMS_SN MSI
, MRP_AP_MTL_PARAS_SN MP
, MRP_AP_MRP_PARAS_SN ORG
WHERE MSI.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND MP.ORGANIZATION_ID= ORG.ORGANIZATION_ID GROUP BY INVENTORY_ITEM_ID
, MASTER_ORGANIZATION_ID ) Y
WHERE X.END_ITEM_ID= Y.INVENTORY_ITEM_ID
AND X.MASTER_ORGANIZATION_ID= Y.MASTER_ORGANIZATION_ID
Columns
Name |
UNIT_NUMBER |
END_ITEM_ID |
MASTER_ORGANIZATION_ID |
COMMENTS |
RN3 |
RN2 |
RN1 |