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 338: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb

334:
335: SELECT
336: ecp.policy_char_value INTO l_change_policy_char_val
337: FROM
338: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb
339: WHERE
340: ecp.policy_object_pk1_value =
341: (SELECT TO_CHAR(ic.item_catalog_group_id)
342: FROM mtl_item_catalog_groups_b ic

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

460: FND_ATTACHED_DOCUMENTS ATDOCS,
461: FND_DOCUMENTS_TL DOCTL
462: WHERE ATDOCS.DOCUMENT_ID = DOCTL.DOCUMENT_ID
463: AND DOCTL.LANGUAGE = USERENV('LANG')
464: AND ( ( ATDOCS.ENTITY_NAME = 'MTL_SYSTEM_ITEMS'
465: AND ATDOCS.PK1_VALUE = TO_CHAR(BET.ORGANIZATION_ID)
466: AND ATDOCS.PK2_VALUE = TO_CHAR(BET.COMPONENT_ITEM_ID) )
467: OR
468: ( ATDOCS.ENTITY_NAME = 'MTL_ITEM_REVISIONS'

Line 1212: From mtl_system_items_b msi

1208: trunc(rev_date);
1209:
1210: Cursor Calculate_Offset(P_ParentItem in number, P_Percent in number) is
1211: Select P_Percent/100 * msi.full_lead_time offset
1212: From mtl_system_items_b msi
1213: Where msi.inventory_item_id = P_ParentItem
1214: And msi.organization_id = Org_Id;
1215:
1216: No_Revision_Found exception;

Line 1222: From mtl_system_items_b_kfv msi,

1218:
1219: Cursor l_TopBill_csr is
1220: Select msi.concatenated_segments,
1221: bom.alternate_bom_designator
1222: From mtl_system_items_b_kfv msi,
1223: bom_structures_b bom,
1224: BOM_EXPLOSIONS_ALL bet
1225: Where msi.inventory_item_id = bom.assembly_item_id
1226: And msi.organization_id = bom.organization_id

Line 1948: FROM mtl_system_items_b msi

1944: , mum.description
1945: INTO primary_uom_code_tbl(i)
1946: , eng_item_flag_tbl(i)
1947: , primary_uom_desc_tbl(i)
1948: FROM mtl_system_items_b msi
1949: --, mtl_units_of_measure mum
1950: , mtl_units_of_measure_tl mum
1951: WHERE msi.inventory_item_id = component_item_id_tbl(i)
1952: AND msi.organization_id = nvl(common_organization_id_tbl(i),

Line 2365: FROM mtl_system_items_b msi

2361: UPDATE BOM_EXPLOSIONS_ALL bet SET (bet.primary_uom_code, bet.eng_item_flag, bet.primary_unit_of_measure) =
2362: (SELECT msi.primary_uom_code
2363: , msi.eng_item_flag
2364: , mum.unit_of_measure
2365: FROM mtl_system_items_b msi
2366: , mtl_units_of_measure_tl mum
2367: WHERE msi.inventory_item_id = bet.component_item_id
2368: AND msi.organization_id = bet.common_organization_id
2369: AND msi.primary_uom_code = mum.uom_code

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

2934: NVL(mirb.current_phase_id , msi.current_phase_id) AS phase_id,
2935: msi.item_catalog_group_id item_catalog_group_id,
2936: msi.inventory_item_id, msi.organization_id , mirb.revision_id,
2937: bet.component_sequence_id, bet.structure_type_id
2938: FROM bom_explosions_all bet, mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi
2939: WHERE bet.group_id = p_group_id AND bet.comp_bill_seq_id IS NOT NULL
2940: AND bet.component_item_id = msi.INVENTORY_ITEM_ID AND
2941: bet.organization_id = msi.ORGANIZATION_ID AND
2942: mirb.revision_id = BOM_EXPLODER_PUB.Get_Component_Revision_Id(NVL(BET.component_sequence_id,0))

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

3810: UPDATE BOM_EXPLOSIONS_ALL
3811: SET access_flag = l_access_flag,
3812: (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,
3813: msi.eng_item_flag, (select description from mtl_units_of_measure where uom_code = msi.primary_uom_code) FROM
3814: mtl_system_items_b msi WHERE msi.inventory_item_id = item_id AND msi.organization_id = org_id)
3815: WHERE group_id = grp_id
3816: AND sort_order = '0000001';
3817: */
3818:

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

3818:
3819: UPDATE BOM_EXPLOSIONS_ALL
3820: SET access_flag = l_access_flag,
3821: (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,
3822: msi.eng_item_flag, muom.unit_of_measure FROM mtl_system_items_b msi, mtl_units_of_measure muom
3823: WHERE msi.inventory_item_id = item_id AND msi.organization_id = org_id AND muom.uom_code = msi.primary_uom_code)
3824: WHERE group_id = grp_id
3825: AND sort_order = '0000001';
3826:

Line 3943: FROM mtl_system_items_b msi, bom_structures_b bbm

3939: BEGIN
3940:
3941: SELECT msi.primary_uom_code, msi.organization_id into
3942: t_master_uom, t_master_org_id
3943: FROM mtl_system_items_b msi, bom_structures_b bbm
3944: WHERE cr.curCBSI = bbm.bill_sequence_id and
3945: bbm.organization_id = msi.organization_id and
3946: msi.inventory_item_id = cr.curCII;
3947:

Line 3949: FROM mtl_system_items_b msi

3945: bbm.organization_id = msi.organization_id and
3946: msi.inventory_item_id = cr.curCII;
3947:
3948: SELECT msi.primary_uom_code INTO t_child_uom
3949: FROM mtl_system_items_b msi
3950: WHERE msi.inventory_item_id = cr.curCII and
3951: msi.organization_id = cr.curOI;
3952:
3953: OPEN conv(t_master_uom, t_child_uom, cr.curCII, t_master_org_id);