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 MTL_ITEM_REVISIONS_B

Line 1354: FROM MTL_ITEM_REVISIONS_B MIR

1350: A.ITEM_NUMBER AS "PackItemNumber" ,
1351: EgoGtinEO.DESCRIPTION AS "GTINDescription" ,
1352: EgoGtinEO.UOM_CODE AS "UnitOfMeasure" ,
1353: (SELECT MIR.REVISION
1354: FROM MTL_ITEM_REVISIONS_B MIR
1355: WHERE EgoGtinEO.REVISION_ID = MIR.REVISION_ID
1356: ) AS "Revision" ,
1357: EgoGtinEO.CROSS_REFERENCE_ID AS "CrossReferenceId" ,
1358: EgoGtinEO.EPC_GTIN_SERIAL AS "EpcGtinSerial"

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 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 4428: FROM mtl_item_revisions_b b

4424: FROM
4425: (SELECT revision_id ,
4426: effectivity_date ,
4427: (SELECT NVL( MIN(b.effectivity_date)-(1/86400),to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss')) end_date
4428: FROM mtl_item_revisions_b b
4429: WHERE b.inventory_item_id = a.inventory_item_id
4430: AND b.organization_id = a.organization_id
4431: AND b.effectivity_date > a.effectivity_date
4432: ) end_date,

Line 4434: from mtl_item_revisions_b a

4430: AND b.organization_id = a.organization_id
4431: AND b.effectivity_date > a.effectivity_date
4432: ) end_date,
4433: implementation_date
4434: from mtl_item_revisions_b a
4435: WHERE organization_id = p_org_id
4436: AND inventory_item_id = p_inv_id
4437: AND effectivity_date < p_rev_date
4438: AND implementation_date IS NOT NULL

Line 4453: FROM mtl_item_revisions_b b

4449: IF (p_rev_id <> -1) THEN
4450: SELECT revision_id ,
4451: effectivity_date ,
4452: (SELECT NVL( MIN(b.effectivity_date)-(1/86400),to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss')) end_date
4453: FROM mtl_item_revisions_b b
4454: WHERE b.inventory_item_id = a.inventory_item_id
4455: AND b.organization_id = a.organization_id
4456: AND b.effectivity_date > a.effectivity_date
4457: ) end_date,

Line 4460: from mtl_item_revisions_b a

4456: AND b.effectivity_date > a.effectivity_date
4457: ) end_date,
4458: implementation_date
4459: INTO p_revision_id, v_effectivity_date, v_end_date, v_impl_date
4460: from mtl_item_revisions_b a
4461: WHERE organization_id = p_org_id
4462: AND inventory_item_id = p_inv_id
4463: AND revision_id = p_rev_id;
4464: ELSIF (p_revision IS NOT NULL) THEN

Line 4468: FROM mtl_item_revisions_b b

4464: ELSIF (p_revision IS NOT NULL) THEN
4465: SELECT revision_id ,
4466: effectivity_date ,
4467: (SELECT NVL( MIN(b.effectivity_date)-(1/86400),to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss')) end_date
4468: FROM mtl_item_revisions_b b
4469: WHERE b.inventory_item_id = a.inventory_item_id
4470: AND b.organization_id = a.organization_id
4471: AND b.effectivity_date > a.effectivity_date
4472: ) end_date,

Line 4475: from mtl_item_revisions_b a

4471: AND b.effectivity_date > a.effectivity_date
4472: ) end_date,
4473: implementation_date
4474: INTO p_revision_id, v_effectivity_date, v_end_date, v_impl_date
4475: from mtl_item_revisions_b a
4476: WHERE organization_id = p_org_id
4477: AND inventory_item_id = p_inv_id
4478: AND revision = p_revision;
4479: ELSE

Line 4489: FROM mtl_item_revisions_b b

4485: FROM
4486: (SELECT revision_id ,
4487: effectivity_date ,
4488: (SELECT NVL( MIN(b.effectivity_date)-(1/86400),to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss')) end_date
4489: FROM mtl_item_revisions_b b
4490: WHERE b.inventory_item_id = a.inventory_item_id
4491: AND b.organization_id = a.organization_id
4492: AND b.effectivity_date > a.effectivity_date
4493: ) end_date,

Line 4495: from mtl_item_revisions_b a

4491: AND b.organization_id = a.organization_id
4492: AND b.effectivity_date > a.effectivity_date
4493: ) end_date,
4494: implementation_date
4495: from mtl_item_revisions_b a
4496: WHERE organization_id = p_org_id
4497: AND inventory_item_id = p_inv_id
4498: AND effectivity_date < SYSDATE
4499: AND implementation_date IS NOT NULL