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.EGO_ITEM_WS_PVT dependencies on BOM_EXPLODER_PUB

Line 1787: bom_exploder_pub.exploder_userexit

1783: top_bill_seq_id NUMBER;
1784:
1785: BEGIN
1786:
1787: bom_exploder_pub.exploder_userexit
1788: ( org_id => to_number(pk2_value)
1789: , rev_date => rev_date
1790: ,order_by => 1
1791: ,levels_to_explode => levels_explode

Line 1880: ,bom_exploder_pub.get_component_revision_id(nvl(be.component_sequence_id, 0)) AS rev_id

1876: IS
1877: SELECT
1878: ego.inventory_item_id AS inventory_item_id
1879: ,ego.organization_id AS org_id
1880: ,bom_exploder_pub.get_component_revision_id(nvl(be.component_sequence_id, 0)) AS rev_id
1881: , bom_exploder_pub.get_component_revision_label(nvl(be.component_sequence_id, 0)) AS rev_label
1882: , be.plan_level AS plan_level
1883: FROM bom_explosions_all be , mtl_system_items_b_kfv ego
1884: WHERE be.group_id = grp_id

Line 1881: , bom_exploder_pub.get_component_revision_label(nvl(be.component_sequence_id, 0)) AS rev_label

1877: SELECT
1878: ego.inventory_item_id AS inventory_item_id
1879: ,ego.organization_id AS org_id
1880: ,bom_exploder_pub.get_component_revision_id(nvl(be.component_sequence_id, 0)) AS rev_id
1881: , bom_exploder_pub.get_component_revision_label(nvl(be.component_sequence_id, 0)) AS rev_label
1882: , be.plan_level AS plan_level
1883: FROM bom_explosions_all be , mtl_system_items_b_kfv ego
1884: WHERE be.group_id = grp_id
1885: AND ego.inventory_item_id = be.component_item_id

Line 1890: ( bom_exploder_pub.get_explode_option = 1 OR

1886: AND ego.organization_id = be.organization_id
1887: AND be.plan_level <= levels
1888: AND be.plan_level > 0
1889: AND /* This whereclause for filter criteria: Start */
1890: ( bom_exploder_pub.get_explode_option = 1 OR
1891: be.plan_level = 0 OR
1892: /* Date Effectivity */
1893: ( nvl(be.effectivity_control,1) = 1 AND
1894: ( ( be.implementation_date IS NULL AND

Line 1897: NULL,bom_exploder_pub.get_explosion_date,

1893: ( nvl(be.effectivity_control,1) = 1 AND
1894: ( ( be.implementation_date IS NULL AND
1895: be.acd_type = 3 AND
1896: decode(be.comp_fixed_revision_id,
1897: NULL,bom_exploder_pub.get_explosion_date,
1898: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) >= be.trimmed_effectivity_date
1899: ) OR
1900: ( bom_exploder_pub.get_explode_option = 2 AND
1901: decode(be.comp_fixed_revision_id,

Line 1898: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) >= be.trimmed_effectivity_date

1894: ( ( be.implementation_date IS NULL AND
1895: be.acd_type = 3 AND
1896: decode(be.comp_fixed_revision_id,
1897: NULL,bom_exploder_pub.get_explosion_date,
1898: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) >= be.trimmed_effectivity_date
1899: ) OR
1900: ( bom_exploder_pub.get_explode_option = 2 AND
1901: decode(be.comp_fixed_revision_id,
1902: NULL,bom_exploder_pub.get_explosion_date,

Line 1900: ( bom_exploder_pub.get_explode_option = 2 AND

1896: decode(be.comp_fixed_revision_id,
1897: NULL,bom_exploder_pub.get_explosion_date,
1898: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) >= be.trimmed_effectivity_date
1899: ) OR
1900: ( bom_exploder_pub.get_explode_option = 2 AND
1901: decode(be.comp_fixed_revision_id,
1902: NULL,bom_exploder_pub.get_explosion_date,
1903: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) >= be.trimmed_effectivity_date AND
1904: decode(be.comp_fixed_revision_id,

Line 1902: NULL,bom_exploder_pub.get_explosion_date,

1898: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) >= be.trimmed_effectivity_date
1899: ) OR
1900: ( bom_exploder_pub.get_explode_option = 2 AND
1901: decode(be.comp_fixed_revision_id,
1902: NULL,bom_exploder_pub.get_explosion_date,
1903: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) >= be.trimmed_effectivity_date AND
1904: decode(be.comp_fixed_revision_id,
1905: NULL,bom_exploder_pub.get_explosion_date,
1906: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) < nvl(be.trimmed_disable_date,to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'))

Line 1903: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) >= be.trimmed_effectivity_date AND

1899: ) OR
1900: ( bom_exploder_pub.get_explode_option = 2 AND
1901: decode(be.comp_fixed_revision_id,
1902: NULL,bom_exploder_pub.get_explosion_date,
1903: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) >= be.trimmed_effectivity_date AND
1904: decode(be.comp_fixed_revision_id,
1905: NULL,bom_exploder_pub.get_explosion_date,
1906: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) < nvl(be.trimmed_disable_date,to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'))
1907: ) OR

Line 1905: NULL,bom_exploder_pub.get_explosion_date,

1901: decode(be.comp_fixed_revision_id,
1902: NULL,bom_exploder_pub.get_explosion_date,
1903: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) >= be.trimmed_effectivity_date AND
1904: decode(be.comp_fixed_revision_id,
1905: NULL,bom_exploder_pub.get_explosion_date,
1906: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) < nvl(be.trimmed_disable_date,to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'))
1907: ) OR
1908: ( bom_exploder_pub.get_explode_option = 3 AND
1909: decode(be.comp_fixed_revision_id,

Line 1906: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) < nvl(be.trimmed_disable_date,to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'))

1902: NULL,bom_exploder_pub.get_explosion_date,
1903: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) >= be.trimmed_effectivity_date AND
1904: decode(be.comp_fixed_revision_id,
1905: NULL,bom_exploder_pub.get_explosion_date,
1906: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) < nvl(be.trimmed_disable_date,to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'))
1907: ) OR
1908: ( bom_exploder_pub.get_explode_option = 3 AND
1909: decode(be.comp_fixed_revision_id,
1910: NULL,bom_exploder_pub.get_explosion_date,

Line 1908: ( bom_exploder_pub.get_explode_option = 3 AND

1904: decode(be.comp_fixed_revision_id,
1905: NULL,bom_exploder_pub.get_explosion_date,
1906: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) < nvl(be.trimmed_disable_date,to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'))
1907: ) OR
1908: ( bom_exploder_pub.get_explode_option = 3 AND
1909: decode(be.comp_fixed_revision_id,
1910: NULL,bom_exploder_pub.get_explosion_date,
1911: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) < nvl(be.trimmed_disable_date,to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'))
1912: )

Line 1910: NULL,bom_exploder_pub.get_explosion_date,

1906: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) < nvl(be.trimmed_disable_date,to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'))
1907: ) OR
1908: ( bom_exploder_pub.get_explode_option = 3 AND
1909: decode(be.comp_fixed_revision_id,
1910: NULL,bom_exploder_pub.get_explosion_date,
1911: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) < nvl(be.trimmed_disable_date,to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'))
1912: )
1913: )
1914: ) OR

Line 1911: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) < nvl(be.trimmed_disable_date,to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'))

1907: ) OR
1908: ( bom_exploder_pub.get_explode_option = 3 AND
1909: decode(be.comp_fixed_revision_id,
1910: NULL,bom_exploder_pub.get_explosion_date,
1911: bom_exploder_pub.get_revision_highdate(be.comp_fixed_revision_id)) < nvl(be.trimmed_disable_date,to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'))
1912: )
1913: )
1914: ) OR
1915: /* Rev Effectivity */

Line 1917: ( ( bom_exploder_pub.get_explode_option = 2 AND

1913: )
1914: ) OR
1915: /* Rev Effectivity */
1916: ( nvl(be.effectivity_control,1) = 4 AND
1917: ( ( bom_exploder_pub.get_explode_option = 2 AND
1918: ( ( bom_exploder_pub.get_expl_end_item_rev_code >= (SELECT revision FROM mtl_item_revisions_b
1919: WHERE inventory_item_id = be.end_item_id
1920: AND organization_id = be.end_item_org_id
1921: AND revision_id = be.from_end_item_rev_id) AND

Line 1918: ( ( bom_exploder_pub.get_expl_end_item_rev_code >= (SELECT revision FROM mtl_item_revisions_b

1914: ) OR
1915: /* Rev Effectivity */
1916: ( nvl(be.effectivity_control,1) = 4 AND
1917: ( ( bom_exploder_pub.get_explode_option = 2 AND
1918: ( ( bom_exploder_pub.get_expl_end_item_rev_code >= (SELECT revision FROM mtl_item_revisions_b
1919: WHERE inventory_item_id = be.end_item_id
1920: AND organization_id = be.end_item_org_id
1921: AND revision_id = be.from_end_item_rev_id) AND
1922: ( be.to_end_item_rev_id IS NULL OR

Line 1923: bom_exploder_pub.get_expl_end_item_rev_code <= (SELECT revision FROM mtl_item_revisions_b

1919: WHERE inventory_item_id = be.end_item_id
1920: AND organization_id = be.end_item_org_id
1921: AND revision_id = be.from_end_item_rev_id) AND
1922: ( be.to_end_item_rev_id IS NULL OR
1923: bom_exploder_pub.get_expl_end_item_rev_code <= (SELECT revision FROM mtl_item_revisions_b
1924: WHERE inventory_item_id = be.end_item_id
1925: AND organization_id = be.end_item_org_id
1926: AND revision_id = be.to_end_item_rev_id)
1927: )

Line 1930: bom_exploder_pub.get_component_revision(nvl(be.parent_comp_seq_id,0)) >= (SELECT revision FROM mtl_item_revisions_b

1926: AND revision_id = be.to_end_item_rev_id)
1927: )
1928: ) OR
1929: ( be.plan_level > 1 AND
1930: bom_exploder_pub.get_component_revision(nvl(be.parent_comp_seq_id,0)) >= (SELECT revision FROM mtl_item_revisions_b
1931: WHERE inventory_item_id = be.assembly_item_id
1932: AND organization_id = be.organization_id
1933: AND revision_id = be.from_end_item_rev_id) AND
1934: ( be.to_end_item_rev_id IS NULL OR

Line 1935: bom_exploder_pub.get_component_revision(nvl(be.parent_comp_seq_id,0)) <= (SELECT revision FROM mtl_item_revisions_b

1931: WHERE inventory_item_id = be.assembly_item_id
1932: AND organization_id = be.organization_id
1933: AND revision_id = be.from_end_item_rev_id) AND
1934: ( be.to_end_item_rev_id IS NULL OR
1935: bom_exploder_pub.get_component_revision(nvl(be.parent_comp_seq_id,0)) <= (SELECT revision FROM mtl_item_revisions_b
1936: WHERE inventory_item_id = be.assembly_item_id
1937: AND organization_id = be.organization_id
1938: AND revision_id = be.to_end_item_rev_id)
1939:

Line 1944: ( bom_exploder_pub.get_explode_option = 3 AND

1940: )
1941: )
1942: )
1943: ) OR
1944: ( bom_exploder_pub.get_explode_option = 3 AND
1945: ( ( be.to_end_item_rev_id IS NULL
1946: ) OR
1947: ( bom_exploder_pub.get_expl_end_item_rev_code <= (SELECT revision FROM mtl_item_revisions_b
1948: WHERE inventory_item_id = be.end_item_id

Line 1947: ( bom_exploder_pub.get_expl_end_item_rev_code <= (SELECT revision FROM mtl_item_revisions_b

1943: ) OR
1944: ( bom_exploder_pub.get_explode_option = 3 AND
1945: ( ( be.to_end_item_rev_id IS NULL
1946: ) OR
1947: ( bom_exploder_pub.get_expl_end_item_rev_code <= (SELECT revision FROM mtl_item_revisions_b
1948: WHERE inventory_item_id = be.end_item_id
1949: AND organization_id = be.end_item_org_id
1950: AND revision_id = be.to_end_item_rev_id)
1951: ) OR

Line 1953: bom_exploder_pub.get_component_revision(nvl(be.parent_comp_seq_id,0)) <= (SELECT revision FROM mtl_item_revisions_b

1949: AND organization_id = be.end_item_org_id
1950: AND revision_id = be.to_end_item_rev_id)
1951: ) OR
1952: ( be.plan_level > 1 AND
1953: bom_exploder_pub.get_component_revision(nvl(be.parent_comp_seq_id,0)) <= (SELECT revision FROM mtl_item_revisions_b
1954: WHERE inventory_item_id = be.assembly_item_id
1955: AND organization_id = be.organization_id
1956: AND revision_id = be.to_end_item_rev_id)
1957: )

Line 1964: ( ( bom_exploder_pub.get_explode_option = 2 AND

1960: )
1961: ) OR
1962: /* Unit/Serial Effectivity */
1963: ( nvl(be.effectivity_control,1) = 2 AND
1964: ( ( bom_exploder_pub.get_explode_option = 2 AND
1965: bom_exploder_pub.get_expl_unit_number BETWEEN be.trimmed_from_unit_number AND nvl(be.trimmed_to_unit_number,bom_exploder_pub.get_expl_unit_number)
1966: ) OR
1967: ( bom_exploder_pub.get_explode_option = 3 AND
1968: bom_exploder_pub.get_expl_unit_number <= nvl(be.trimmed_to_unit_number,bom_exploder_pub.get_expl_unit_number)

Line 1965: bom_exploder_pub.get_expl_unit_number BETWEEN be.trimmed_from_unit_number AND nvl(be.trimmed_to_unit_number,bom_exploder_pub.get_expl_unit_number)

1961: ) OR
1962: /* Unit/Serial Effectivity */
1963: ( nvl(be.effectivity_control,1) = 2 AND
1964: ( ( bom_exploder_pub.get_explode_option = 2 AND
1965: bom_exploder_pub.get_expl_unit_number BETWEEN be.trimmed_from_unit_number AND nvl(be.trimmed_to_unit_number,bom_exploder_pub.get_expl_unit_number)
1966: ) OR
1967: ( bom_exploder_pub.get_explode_option = 3 AND
1968: bom_exploder_pub.get_expl_unit_number <= nvl(be.trimmed_to_unit_number,bom_exploder_pub.get_expl_unit_number)
1969: )

Line 1967: ( bom_exploder_pub.get_explode_option = 3 AND

1963: ( nvl(be.effectivity_control,1) = 2 AND
1964: ( ( bom_exploder_pub.get_explode_option = 2 AND
1965: bom_exploder_pub.get_expl_unit_number BETWEEN be.trimmed_from_unit_number AND nvl(be.trimmed_to_unit_number,bom_exploder_pub.get_expl_unit_number)
1966: ) OR
1967: ( bom_exploder_pub.get_explode_option = 3 AND
1968: bom_exploder_pub.get_expl_unit_number <= nvl(be.trimmed_to_unit_number,bom_exploder_pub.get_expl_unit_number)
1969: )
1970: )
1971: )

Line 1968: bom_exploder_pub.get_expl_unit_number <= nvl(be.trimmed_to_unit_number,bom_exploder_pub.get_expl_unit_number)

1964: ( ( bom_exploder_pub.get_explode_option = 2 AND
1965: bom_exploder_pub.get_expl_unit_number BETWEEN be.trimmed_from_unit_number AND nvl(be.trimmed_to_unit_number,bom_exploder_pub.get_expl_unit_number)
1966: ) OR
1967: ( bom_exploder_pub.get_explode_option = 3 AND
1968: bom_exploder_pub.get_expl_unit_number <= nvl(be.trimmed_to_unit_number,bom_exploder_pub.get_expl_unit_number)
1969: )
1970: )
1971: )
1972: );