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_SMALL_IMPL_TEMP

Line 17: | use value from sequence bom_small_impl_temp_s

Line 279: BOM_SMALL_IMPL_TEMP BITT,

275: WHERE mirb.REVISION_ID = BIC.TO_END_ITEM_REV_ID
276: ) ) TO_END_ITEM_REVISION ,
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

Line 910: INSERT INTO BOM_SMALL_IMPL_TEMP

906:
907: -- Insert the Second table values using FORALL.
908:
909: FORALL i IN 1..loop_Count_Val
910: INSERT INTO BOM_SMALL_IMPL_TEMP
911: (LOWEST_ITEM_ID,
912: CURRENT_ITEM_ID,
913: PARENT_ITEM_ID,
914: LOWEST_PK1_VALUE,

Line 1030: /* Set the top item flag for which parent item row is not present in bom_small_impl_temp */

1026:
1027:
1028: <>
1029:
1030: /* Set the top item flag for which parent item row is not present in bom_small_impl_temp */
1031: UPDATE BOM_SMALL_IMPL_TEMP bsit_child
1032: SET
1033: bsit_child.TOP_ITEM_FLAG = 'Y'
1034: WHERE

Line 1031: UPDATE BOM_SMALL_IMPL_TEMP bsit_child

1027:
1028: <>
1029:
1030: /* Set the top item flag for which parent item row is not present in bom_small_impl_temp */
1031: UPDATE BOM_SMALL_IMPL_TEMP bsit_child
1032: SET
1033: bsit_child.TOP_ITEM_FLAG = 'Y'
1034: WHERE
1035: (

Line 1042: FROM BOM_SMALL_IMPL_TEMP bsit_parent

1038: (
1039: NOT EXISTS
1040: (
1041: SELECT 1
1042: FROM BOM_SMALL_IMPL_TEMP bsit_parent
1043: WHERE
1044: bsit_parent.CURRENT_ITEM_ID = bsit_child.PARENT_ITEM_ID
1045: AND bsit_parent.ORGANIZATION_ID = bsit_child.ORGANIZATION_ID
1046: AND bsit_parent.CURRENT_LEVEL = (bsit_child.CURRENT_LEVEL + 1)

Line 1055: UPDATE BOM_SMALL_IMPL_TEMP bsit_source

1051: AND bsit_child.CURRENT_LEVEL > 0 -- top item page shows parents only
1052: AND bsit_child.SEQUENCE_ID = sequence_id;
1053:
1054: /* Set the is_excluded_by_rule to 'Y' for parent item from which implosion item is excluded */
1055: UPDATE BOM_SMALL_IMPL_TEMP bsit_source
1056: SET IS_EXCLUDED_BY_RULE = 'Y'
1057: WHERE
1058: EXISTS
1059: (

Line 1063: BOM_SMALL_IMPL_TEMP bsit,

1059: (
1060: SELECT
1061: *
1062: FROM
1063: BOM_SMALL_IMPL_TEMP bsit,
1064: BOM_EXCLUSION_RULE_DEF berd,
1065: BOM_RULES_B brb
1066: WHERE
1067: (

Line 1375: INSERT INTO BOM_SMALL_IMPL_TEMP

1371: --dbms_output.put_line('trying to insert ');
1372: --bug:4204847 Store the component path with each parent with respect to item to be imploded.
1373: --bug:4218468 Store the component revision id to get the revision label in View
1374: if item_found then
1375: INSERT INTO BOM_SMALL_IMPL_TEMP
1376: (SEQUENCE_ID,
1377: LOWEST_ITEM_ID,
1378: CURRENT_ITEM_ID,
1379: PARENT_ITEM_ID,

Line 1496: from BOM_SMALL_IMPL_TEMP

1492: IF (structure_type_id IS NOT NULL)
1493: THEN
1494:
1495: SELECT COUNT(COMPONENT_SEQUENCE_ID) INTO l_parents_for_pk1
1496: from BOM_SMALL_IMPL_TEMP
1497: WHERE
1498: LOWEST_ITEM_ID = pk1_value AND ORGANIZATION_ID = t_org_code_list(I)
1499: AND CURRENT_LEVEL = 1 AND SEQUENCE_ID = l_seq_id;
1500:

Line 1511: UPDATE BOM_SMALL_IMPL_TEMP

1507: AND ORGANIZATION_ID = pk2_value
1508: AND STRUCTURE_TYPE_ID = structure_type_id
1509: AND IS_PREFERRED = 'Y';
1510:
1511: UPDATE BOM_SMALL_IMPL_TEMP
1512: SET TOP_ITEM_FLAG ='Y',
1513: ALTERNATE_DESIGNATOR = l_preferred_structure_name,
1514: STRUCTURE_TYPE_ID = structure_type_id
1515: WHERE CURRENT_LEVEL = 0 AND SEQUENCE_ID = l_seq_id

Line 1559: EXECUTE IMMEDIATE 'UPDATE bom_small_impl_temp BI SET BI.access_flag = ''F'' WHERE NOT '|| l_predicate;

1555:
1556: IF l_predicate IS NOT NULL
1557: THEN
1558:
1559: EXECUTE IMMEDIATE 'UPDATE bom_small_impl_temp BI SET BI.access_flag = ''F'' WHERE NOT '|| l_predicate;
1560:
1561: END IF;
1562:
1563: --DBMS_PROFILER.STOP_PROFILER;

Line 1572: FROM BOM_SMALL_IMPL_TEMP

1568: IF ( struct_name <> 'PIM_PBOM_S' )
1569: THEN
1570: -- Normal implosion without packs
1571: DELETE
1572: FROM BOM_SMALL_IMPL_TEMP
1573: WHERE
1574: ALTERNATE_DESIGNATOR = 'PIM_PBOM_S'
1575: AND SEQUENCE_ID = sequence_id;
1576:

Line 1666: --Delete those records from bom_small_impl_temp

1662: select structure_type_id into l_str_type_id
1663: from bom_structure_types_b
1664: where structure_type_name = struct_type;
1665:
1666: --Delete those records from bom_small_impl_temp
1667: --which do not have the structure type id
1668: --user wants
1669:
1670: IF ( preferred_only = 2) THEN

Line 1671: DELETE FROM BOM_SMALL_IMPL_TEMP

1667: --which do not have the structure type id
1668: --user wants
1669:
1670: IF ( preferred_only = 2) THEN
1671: DELETE FROM BOM_SMALL_IMPL_TEMP
1672: WHERE STRUCTURE_TYPE_ID <> l_str_type_id;
1673: ELSE
1674: /* Look only for preferred structures */
1675: DELETE FROM BOM_SMALL_IMPL_TEMP

Line 1675: DELETE FROM BOM_SMALL_IMPL_TEMP

1671: DELETE FROM BOM_SMALL_IMPL_TEMP
1672: WHERE STRUCTURE_TYPE_ID <> l_str_type_id;
1673: ELSE
1674: /* Look only for preferred structures */
1675: DELETE FROM BOM_SMALL_IMPL_TEMP
1676: WHERE STRUCTURE_TYPE_ID <> l_str_type_id
1677: OR
1678: (STRUCTURE_TYPE_ID = l_str_type_id
1679: AND not exists

Line 1692: from bom_small_impl_temp

1688: END IF;
1689:
1690: --Check if any records apart from the item record exist.
1691: SELECT count(*) into l_row_count
1692: from bom_small_impl_temp
1693: where SEQUENCE_ID = l_sequence_id;
1694: --Check if the item itself has a structure header of given str type defined
1695: --Fix for Bug 5943195
1696: --If an item has structure header only without components , then it won't