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_IMPLODER_PUB dependencies on BOM_STRUCTURES_B

Line 281: BOM_STRUCTURES_B BBM

277: BBM.EFFECTIVITY_CONTROL EFFECTIVITY_CONTROL
278: FROM
279: BOM_SMALL_IMPL_TEMP BITT,
280: BOM_COMPONENTS_B BIC,
281: BOM_STRUCTURES_B BBM
282: where
283: bitt.current_level = c_current_level
284: and bitt.organization_id = c_org_id
285: and bitt.sequence_id = c_sequence_id

Line 314: from BOM_STRUCTURES_B bbm2

310: or bbm.alternate_bom_designator = bitt.lowest_alternate_designator
311: or ( bitt.lowest_alternate_designator is null
312: and bbm.alternate_bom_designator is not null
313: and not exists (select NULL /*for current item */
314: from BOM_STRUCTURES_B bbm2
315: where bbm2.organization_id = c_org_id
316: and (bitt.parent_obj_name = G_EGO_OBJ_NAME
317: and (bbm2.assembly_item_id = bitt.parent_pk1_value
318: and bitt.parent_obj_name = nvl(bbm2.obj_name,G_EGO_OBJ_NAME)

Line 330: from BOM_STRUCTURES_B bbm2

326: null and bill for .. */
327: (bitt.lowest_alternate_designator is not null
328: and bbm.alternate_bom_designator is null
329: and not exists (select NULL
330: from BOM_STRUCTURES_B bbm2
331: where bbm2.organization_id = c_org_id
332: and (bitt.parent_obj_name = G_EGO_OBJ_NAME
333: and (bbm2.assembly_item_id = bbm.assembly_item_id
334: and nvl(bbm2.obj_name,G_EGO_OBJ_NAME) = nvl(bbm.obj_name,G_EGO_OBJ_NAME)

Line 1497: FROM BOM_STRUCTURES_B

1493: BEGIN
1494: IF (l_parents_for_pk1 = 0)
1495: THEN
1496: SELECT ALTERNATE_BOM_DESIGNATOR INTO l_preferred_structure_name
1497: FROM BOM_STRUCTURES_B
1498: WHERE ASSEMBLY_ITEM_ID = pk1_value
1499: AND ORGANIZATION_ID = pk2_value
1500: AND STRUCTURE_TYPE_ID = structure_type_id
1501: AND IS_PREFERRED = 'Y';

Line 1673: SELECT 1 from bom_structures_b

1669: OR
1670: (STRUCTURE_TYPE_ID = l_str_type_id
1671: AND not exists
1672: (
1673: SELECT 1 from bom_structures_b
1674: where assembly_item_id = l_pk1_value
1675: and organization_id = org_id
1676: and structure_type_id = l_str_type_id
1677: and is_preferred = 'Y'

Line 1694: FROM BOM_STRUCTURES_B BST1

1690:
1691: l_structure_count := 0;
1692: begin
1693: SELECT 1 into l_structure_count
1694: FROM BOM_STRUCTURES_B BST1
1695: WHERE BST1.ASSEMBLY_ITEM_ID = l_pk1_value
1696: AND BST1.ORGANIZATION_ID = org_id
1697: AND BST1.STRUCTURE_TYPE_ID = l_str_type_id
1698: AND exists