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 902: INSERT INTO BOM_SMALL_IMPL_TEMP

898:
899: -- Insert the Second table values using FORALL.
900:
901: FORALL i IN 1..loop_Count_Val
902: INSERT INTO BOM_SMALL_IMPL_TEMP
903: (LOWEST_ITEM_ID,
904: CURRENT_ITEM_ID,
905: PARENT_ITEM_ID,
906: LOWEST_PK1_VALUE,

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

1018:
1019:
1020: <>
1021:
1022: /* Set the top item flag for which parent item row is not present in bom_small_impl_temp */
1023: UPDATE BOM_SMALL_IMPL_TEMP bsit_child
1024: SET
1025: bsit_child.TOP_ITEM_FLAG = 'Y'
1026: WHERE

Line 1023: UPDATE BOM_SMALL_IMPL_TEMP bsit_child

1019:
1020: <>
1021:
1022: /* Set the top item flag for which parent item row is not present in bom_small_impl_temp */
1023: UPDATE BOM_SMALL_IMPL_TEMP bsit_child
1024: SET
1025: bsit_child.TOP_ITEM_FLAG = 'Y'
1026: WHERE
1027: (

Line 1034: FROM BOM_SMALL_IMPL_TEMP bsit_parent

1030: (
1031: NOT EXISTS
1032: (
1033: SELECT 1
1034: FROM BOM_SMALL_IMPL_TEMP bsit_parent
1035: WHERE
1036: bsit_parent.CURRENT_ITEM_ID = bsit_child.PARENT_ITEM_ID
1037: AND bsit_parent.ORGANIZATION_ID = bsit_child.ORGANIZATION_ID
1038: AND bsit_parent.CURRENT_LEVEL = (bsit_child.CURRENT_LEVEL + 1)

Line 1047: UPDATE BOM_SMALL_IMPL_TEMP bsit_source

1043: AND bsit_child.CURRENT_LEVEL > 0 -- top item page shows parents only
1044: AND bsit_child.SEQUENCE_ID = sequence_id;
1045:
1046: /* Set the is_excluded_by_rule to 'Y' for parent item from which implosion item is excluded */
1047: UPDATE BOM_SMALL_IMPL_TEMP bsit_source
1048: SET IS_EXCLUDED_BY_RULE = 'Y'
1049: WHERE
1050: EXISTS
1051: (

Line 1055: BOM_SMALL_IMPL_TEMP bsit,

1051: (
1052: SELECT
1053: *
1054: FROM
1055: BOM_SMALL_IMPL_TEMP bsit,
1056: BOM_EXCLUSION_RULE_DEF berd,
1057: BOM_RULES_B brb
1058: WHERE
1059: (

Line 1367: INSERT INTO BOM_SMALL_IMPL_TEMP

1363: --dbms_output.put_line('trying to insert ');
1364: --bug:4204847 Store the component path with each parent with respect to item to be imploded.
1365: --bug:4218468 Store the component revision id to get the revision label in View
1366: if item_found then
1367: INSERT INTO BOM_SMALL_IMPL_TEMP
1368: (SEQUENCE_ID,
1369: LOWEST_ITEM_ID,
1370: CURRENT_ITEM_ID,
1371: PARENT_ITEM_ID,

Line 1488: from BOM_SMALL_IMPL_TEMP

1484: IF (structure_type_id IS NOT NULL)
1485: THEN
1486:
1487: SELECT COUNT(COMPONENT_SEQUENCE_ID) INTO l_parents_for_pk1
1488: from BOM_SMALL_IMPL_TEMP
1489: WHERE
1490: LOWEST_ITEM_ID = pk1_value AND ORGANIZATION_ID = t_org_code_list(I)
1491: AND CURRENT_LEVEL = 1 AND SEQUENCE_ID = l_seq_id;
1492:

Line 1503: UPDATE BOM_SMALL_IMPL_TEMP

1499: AND ORGANIZATION_ID = pk2_value
1500: AND STRUCTURE_TYPE_ID = structure_type_id
1501: AND IS_PREFERRED = 'Y';
1502:
1503: UPDATE BOM_SMALL_IMPL_TEMP
1504: SET TOP_ITEM_FLAG ='Y',
1505: ALTERNATE_DESIGNATOR = l_preferred_structure_name,
1506: STRUCTURE_TYPE_ID = structure_type_id
1507: WHERE CURRENT_LEVEL = 0 AND SEQUENCE_ID = l_seq_id

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

1547:
1548: IF l_predicate IS NOT NULL
1549: THEN
1550:
1551: EXECUTE IMMEDIATE 'UPDATE bom_small_impl_temp BI SET BI.access_flag = ''F'' WHERE NOT '|| l_predicate;
1552:
1553: END IF;
1554:
1555: --DBMS_PROFILER.STOP_PROFILER;

Line 1564: FROM BOM_SMALL_IMPL_TEMP

1560: IF ( struct_name <> 'PIM_PBOM_S' )
1561: THEN
1562: -- Normal implosion without packs
1563: DELETE
1564: FROM BOM_SMALL_IMPL_TEMP
1565: WHERE
1566: ALTERNATE_DESIGNATOR = 'PIM_PBOM_S'
1567: AND SEQUENCE_ID = sequence_id;
1568:

Line 1658: --Delete those records from bom_small_impl_temp

1654: select structure_type_id into l_str_type_id
1655: from bom_structure_types_b
1656: where structure_type_name = struct_type;
1657:
1658: --Delete those records from bom_small_impl_temp
1659: --which do not have the structure type id
1660: --user wants
1661:
1662: IF ( preferred_only = 2) THEN

Line 1663: DELETE FROM BOM_SMALL_IMPL_TEMP

1659: --which do not have the structure type id
1660: --user wants
1661:
1662: IF ( preferred_only = 2) THEN
1663: DELETE FROM BOM_SMALL_IMPL_TEMP
1664: WHERE STRUCTURE_TYPE_ID <> l_str_type_id;
1665: ELSE
1666: /* Look only for preferred structures */
1667: DELETE FROM BOM_SMALL_IMPL_TEMP

Line 1667: DELETE FROM BOM_SMALL_IMPL_TEMP

1663: DELETE FROM BOM_SMALL_IMPL_TEMP
1664: WHERE STRUCTURE_TYPE_ID <> l_str_type_id;
1665: ELSE
1666: /* Look only for preferred structures */
1667: DELETE FROM BOM_SMALL_IMPL_TEMP
1668: WHERE STRUCTURE_TYPE_ID <> l_str_type_id
1669: OR
1670: (STRUCTURE_TYPE_ID = l_str_type_id
1671: AND not exists

Line 1684: from bom_small_impl_temp

1680: END IF;
1681:
1682: --Check if any records apart from the item record exist.
1683: SELECT count(*) into l_row_count
1684: from bom_small_impl_temp
1685: where SEQUENCE_ID = l_sequence_id;
1686: --Check if the item itself has a structure header of given str type defined
1687: --Fix for Bug 5943195
1688: --If an item has structure header only without components , then it won't