[Home] [Help]
View: MRP_AP_BOMS_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT BBOM.BILL_SEQUENCE_ID
, BBOM.ORGANIZATION_ID
, BBOM.ASSEMBLY_ITEM_ID
, BBOM.ASSEMBLY_TYPE
, BBOM.ALTERNATE_BOM_DESIGNATOR
, BBOM.SPECIFIC_ASSEMBLY_COMMENT
, BBOM.PENDING_FROM_ECN
, BBOM.COMMON_BILL_SEQUENCE_ID
, MP.RN RN3
, MSIK.RN RN2
, BBOM.RN RN1
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSIK
, MRP_AP_BOMS_SN BBOM
WHERE BBOM.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND BBOM.ASSEMBLY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND BBOM.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
Columns
Name |
BILL_SEQUENCE_ID |
ORGANIZATION_ID |
ASSEMBLY_ITEM_ID |
ASSEMBLY_TYPE |
ALTERNATE_BOM_DESIGNATOR |
SPECIFIC_ASSEMBLY_COMMENT |
PENDING_FROM_ECN |
COMMON_BILL_SEQUENCE_ID |
RN3 |
RN2 |
RN1 |