[Home] [Help]
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
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)
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)
1501: BEGIN
1502: IF (l_parents_for_pk1 = 0)
1503: THEN
1504: SELECT ALTERNATE_BOM_DESIGNATOR INTO l_preferred_structure_name
1505: FROM BOM_STRUCTURES_B
1506: WHERE ASSEMBLY_ITEM_ID = pk1_value
1507: AND ORGANIZATION_ID = pk2_value
1508: AND STRUCTURE_TYPE_ID = structure_type_id
1509: AND IS_PREFERRED = 'Y';
1677: OR
1678: (STRUCTURE_TYPE_ID = l_str_type_id
1679: AND not exists
1680: (
1681: SELECT 1 from bom_structures_b
1682: where assembly_item_id = l_pk1_value
1683: and organization_id = org_id
1684: and structure_type_id = l_str_type_id
1685: and is_preferred = 'Y'
1698:
1699: l_structure_count := 0;
1700: begin
1701: SELECT 1 into l_structure_count
1702: FROM BOM_STRUCTURES_B BST1
1703: WHERE BST1.ASSEMBLY_ITEM_ID = l_pk1_value
1704: AND BST1.ORGANIZATION_ID = org_id
1705: AND BST1.STRUCTURE_TYPE_ID = l_str_type_id
1706: AND exists