eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_EXPLODER_PUB dependencies on MTL_SYSTEM_ITEMS

Line 326: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb

322:
323: SELECT
324: ecp.policy_char_value INTO l_change_policy_char_val
325: FROM
326: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb
327: WHERE
328: ecp.policy_object_pk1_value =
329: (SELECT TO_CHAR(ic.item_catalog_group_id)
330: FROM mtl_item_catalog_groups_b ic

Line 452: AND ( ( ATDOCS.ENTITY_NAME = 'MTL_SYSTEM_ITEMS'

448: FND_ATTACHED_DOCUMENTS ATDOCS,
449: FND_DOCUMENTS_TL DOCTL
450: WHERE ATDOCS.DOCUMENT_ID = DOCTL.DOCUMENT_ID
451: AND DOCTL.LANGUAGE = USERENV('LANG')
452: AND ( ( ATDOCS.ENTITY_NAME = 'MTL_SYSTEM_ITEMS'
453: AND ATDOCS.PK1_VALUE = TO_CHAR(BET.ORGANIZATION_ID)
454: AND ATDOCS.PK2_VALUE = TO_CHAR(BET.COMPONENT_ITEM_ID) )
455: OR
456: ( ATDOCS.ENTITY_NAME = 'MTL_ITEM_REVISIONS'

Line 1132: From mtl_system_items_b msi

1128: trunc(rev_date);
1129:
1130: Cursor Calculate_Offset(P_ParentItem in number, P_Percent in number) is
1131: Select P_Percent/100 * msi.full_lead_time offset
1132: From mtl_system_items_b msi
1133: Where msi.inventory_item_id = P_ParentItem
1134: And msi.organization_id = Org_Id;
1135:
1136: No_Revision_Found exception;

Line 1142: From mtl_system_items_b_kfv msi,

1138:
1139: Cursor l_TopBill_csr is
1140: Select msi.concatenated_segments,
1141: bom.alternate_bom_designator
1142: From mtl_system_items_b_kfv msi,
1143: bom_structures_b bom,
1144: BOM_EXPLOSIONS_ALL bet
1145: Where msi.inventory_item_id = bom.assembly_item_id
1146: And msi.organization_id = bom.organization_id

Line 1867: FROM mtl_system_items_b msi

1863: , mum.description
1864: INTO primary_uom_code_tbl(i)
1865: , eng_item_flag_tbl(i)
1866: , primary_uom_desc_tbl(i)
1867: FROM mtl_system_items_b msi
1868: --, mtl_units_of_measure mum
1869: , mtl_units_of_measure_tl mum
1870: WHERE msi.inventory_item_id = component_item_id_tbl(i)
1871: AND msi.organization_id = nvl(common_organization_id_tbl(i),

Line 2284: FROM mtl_system_items_b msi

2280: UPDATE BOM_EXPLOSIONS_ALL bet SET (bet.primary_uom_code, bet.eng_item_flag, bet.primary_unit_of_measure) =
2281: (SELECT msi.primary_uom_code
2282: , msi.eng_item_flag
2283: , mum.unit_of_measure
2284: FROM mtl_system_items_b msi
2285: , mtl_units_of_measure_tl mum
2286: WHERE msi.inventory_item_id = bet.component_item_id
2287: AND msi.organization_id = bet.common_organization_id
2288: AND msi.primary_uom_code = mum.uom_code

Line 2848: FROM bom_explosions_all bet, mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi

2844: NVL(mirb.current_phase_id , msi.current_phase_id) AS phase_id,
2845: msi.item_catalog_group_id item_catalog_group_id,
2846: msi.inventory_item_id, msi.organization_id , mirb.revision_id,
2847: bet.component_sequence_id, bet.structure_type_id
2848: FROM bom_explosions_all bet, mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi
2849: WHERE bet.group_id = p_group_id AND bet.comp_bill_seq_id IS NOT NULL
2850: AND bet.component_item_id = msi.INVENTORY_ITEM_ID AND
2851: bet.organization_id = msi.ORGANIZATION_ID AND
2852: mirb.revision_id = BOM_EXPLODER_PUB.Get_Component_Revision_Id(NVL(BET.component_sequence_id,0))

Line 3699: mtl_system_items_b msi WHERE msi.inventory_item_id = item_id AND msi.organization_id = org_id)

3695: UPDATE BOM_EXPLOSIONS_ALL
3696: SET access_flag = l_access_flag,
3697: (bom_item_type, parent_bom_item_type, primary_uom_code, eng_item_flag, primary_unit_of_measure) = (SELECT msi.bom_item_type, msi.bom_item_type, msi.primary_uom_code,
3698: msi.eng_item_flag, (select description from mtl_units_of_measure where uom_code = msi.primary_uom_code) FROM
3699: mtl_system_items_b msi WHERE msi.inventory_item_id = item_id AND msi.organization_id = org_id)
3700: WHERE group_id = grp_id
3701: AND sort_order = '0000001';
3702: */
3703:

Line 3707: msi.eng_item_flag, muom.unit_of_measure FROM mtl_system_items_b msi, mtl_units_of_measure muom

3703:
3704: UPDATE BOM_EXPLOSIONS_ALL
3705: SET access_flag = l_access_flag,
3706: (bom_item_type, parent_bom_item_type, primary_uom_code, eng_item_flag, primary_unit_of_measure) = (SELECT msi.bom_item_type, msi.bom_item_type, msi.primary_uom_code,
3707: msi.eng_item_flag, muom.unit_of_measure FROM mtl_system_items_b msi, mtl_units_of_measure muom
3708: WHERE msi.inventory_item_id = item_id AND msi.organization_id = org_id AND muom.uom_code = msi.primary_uom_code)
3709: WHERE group_id = grp_id
3710: AND sort_order = '0000001';
3711:

Line 3820: FROM mtl_system_items_b msi, bom_structures_b bbm

3816: FOR cr IN cur(grp_id) LOOP
3817:
3818: SELECT msi.primary_uom_code, msi.organization_id into
3819: t_master_uom, t_master_org_id
3820: FROM mtl_system_items_b msi, bom_structures_b bbm
3821: WHERE cr.curCBSI = bbm.bill_sequence_id and
3822: bbm.organization_id = msi.organization_id and
3823: msi.inventory_item_id = cr.curCII;
3824:

Line 3826: FROM mtl_system_items_b msi

3822: bbm.organization_id = msi.organization_id and
3823: msi.inventory_item_id = cr.curCII;
3824:
3825: SELECT msi.primary_uom_code INTO t_child_uom
3826: FROM mtl_system_items_b msi
3827: WHERE msi.inventory_item_id = cr.curCII and
3828: msi.organization_id = cr.curOI;
3829:
3830: OPEN conv(t_master_uom, t_child_uom, cr.curCII, t_master_org_id);