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_GLOBALS dependencies on MTL_ITEM_REVISIONS_B

Line 1722: mtl_item_revisions_B mir,

1718: IS
1719: SELECT
1720: revision_id
1721: FROM
1722: mtl_item_revisions_B mir,
1723: bom_bill_of_materials bom
1724: WHERE
1725: mir.inventory_item_id = bom.assembly_item_id
1726: AND mir.organization_id = bom.organization_id

Line 1730: FROM mtl_item_revisions_b mir1

1726: AND mir.organization_id = bom.organization_id
1727: AND bom.bill_sequence_id = p_bill_sequence_id
1728: AND effectivity_date =
1729: (SELECT max(mir1.effectivity_date)
1730: FROM mtl_item_revisions_b mir1
1731: WHERE mir1.inventory_item_id = mir.inventory_item_id
1732: AND mir1.organization_id = mir.organization_id
1733: AND mir1.effectivity_date <= p_effectivity_date
1734: AND ROWNUM = 1);

Line 1746: mtl_item_revisions_B mir,

1742: IS
1743: SELECT
1744: revision_id
1745: FROM
1746: mtl_item_revisions_B mir,
1747: bom_bill_of_materials bom
1748: WHERE
1749: mir.inventory_item_id = p_component_item_id
1750: AND mir.organization_id = bom.organization_id

Line 1753: FROM mtl_item_revisions_b mir1

1749: mir.inventory_item_id = p_component_item_id
1750: AND mir.organization_id = bom.organization_id
1751: AND bom.bill_sequence_id = p_bill_sequence_id
1752: AND effectivity_date = (SELECT max(mir1.effectivity_date)
1753: FROM mtl_item_revisions_b mir1
1754: WHERE mir1.inventory_item_id = mir.inventory_item_id
1755: AND mir1.organization_id = mir.organization_id
1756: AND mir1.effectivity_date <= p_effectivity_date
1757: AND ROWNUM = 1);

Line 2180: FROM mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi

2176: (SELECT NVL(mirb.lifecycle_id, msi.lifecycle_id) AS lifecycle_id,
2177: NVL(mirb.current_phase_id , msi.current_phase_id) AS phase_id,
2178: msi.item_catalog_group_id item_catalog_group_id,
2179: msi.inventory_item_id, msi.organization_id , mirb.revision_id
2180: FROM mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi
2181: WHERE msi.INVENTORY_ITEM_ID = p_item_id
2182: AND msi.ORGANIZATION_ID = p_org_id
2183: AND mirb.revision_id = nvl(p_rev_id,BOM_Revisions.Get_Item_Revision_Id_Fn('ALL','ALL',p_org_id, p_item_id, p_rev_date) )
2184: AND (mirb.current_phase_id IS NOT NULL OR msi.current_phase_id IS NOT NULL)) ITEM_DTLS,

Line 2223: l_rev_code MTL_ITEM_REVISIONS_B.REVISION%TYPE;

2219:
2220: FUNCTION getItemRevCode(p_rev_id IN NUMBER)
2221: RETURN VARCHAR2
2222: IS
2223: l_rev_code MTL_ITEM_REVISIONS_B.REVISION%TYPE;
2224: BEGIN
2225: SELECT revision
2226: INTO l_rev_code
2227: FROM mtl_item_revisions_b

Line 2227: FROM mtl_item_revisions_b

2223: l_rev_code MTL_ITEM_REVISIONS_B.REVISION%TYPE;
2224: BEGIN
2225: SELECT revision
2226: INTO l_rev_code
2227: FROM mtl_item_revisions_b
2228: WHERE revision_id = p_rev_id;
2229:
2230: RETURN l_rev_code;
2231: END;

Line 2257: FROM mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi

2253: (SELECT NVL(mirb.lifecycle_id, msi.lifecycle_id) AS lifecycle_id,
2254: NVL(mirb.current_phase_id , msi.current_phase_id) AS phase_id,
2255: msi.item_catalog_group_id item_catalog_group_id,
2256: msi.inventory_item_id, msi.organization_id , mirb.revision
2257: FROM mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi
2258: WHERE msi.INVENTORY_ITEM_ID = p_item_id
2259: AND msi.ORGANIZATION_ID = p_org_id
2260: AND mirb.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID
2261: AND mirb.ORGANIZATION_ID = msi.ORGANIZATION_ID

Line 2290: l_start_rev mtl_item_revisions_b.revision%TYPE;

2286: AND ecp.attribute_number_value = p_structure_type_id
2287: AND ecp.policy_char_value <> p_current_chg_pol
2288: ORDER BY item_dtls.revision;
2289:
2290: l_start_rev mtl_item_revisions_b.revision%TYPE;
2291: l_end_rev mtl_item_revisions_b.revision%TYPE;
2292:
2293: BEGIN
2294: l_start_rev := p_start_revision;

Line 2291: l_end_rev mtl_item_revisions_b.revision%TYPE;

2287: AND ecp.policy_char_value <> p_current_chg_pol
2288: ORDER BY item_dtls.revision;
2289:
2290: l_start_rev mtl_item_revisions_b.revision%TYPE;
2291: l_end_rev mtl_item_revisions_b.revision%TYPE;
2292:
2293: BEGIN
2294: l_start_rev := p_start_revision;
2295: l_end_rev := p_end_revision;

Line 2321: l_rev_date MTL_ITEM_REVISIONS_B.EFFECTIVITY_DATE%TYPE;

2317:
2318: FUNCTION getRevDate(p_rev_id IN NUMBER)
2319: RETURN VARCHAR2
2320: IS
2321: l_rev_date MTL_ITEM_REVISIONS_B.EFFECTIVITY_DATE%TYPE;
2322: BEGIN
2323:
2324: SELECT effectivity_date
2325: INTO l_rev_date

Line 2326: FROM mtl_item_revisions_b

2322: BEGIN
2323:
2324: SELECT effectivity_date
2325: INTO l_rev_date
2326: FROM mtl_item_revisions_b
2327: where revision_id = p_rev_id;
2328:
2329: RETURN l_rev_date;
2330: END;

Line 2360: FROM mtl_item_revisions_b

2356: IF p_context_rev_id IS NOT NULL
2357: THEN
2358: SELECT effectivity_date
2359: INTO l_start_date
2360: FROM mtl_item_revisions_b
2361: WHERE revision_id = p_context_rev_id;
2362:
2363: SELECT effectivity_control
2364: INTO l_eff_ctrl

Line 2552: SELECT Effectivity_Date INTO l_start_effectivity_date FROM MTL_ITEM_REVISIONS_B WHERE REVISION_ID = p_rev_id;

2548: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);
2549:
2550: -- IF the effectivity is not of date or rev return
2551: IF l_effectivity_control = 1 THEN
2552: SELECT Effectivity_Date INTO l_start_effectivity_date FROM MTL_ITEM_REVISIONS_B WHERE REVISION_ID = p_rev_id;
2553: SELECT Disable_date INTO l_disable_date FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id;
2554: l_start_rev_id := null;
2555: l_end_rev_id := null;
2556: ELSIF l_effectivity_control = 4 THEN

Line 2999: SELECT Effectivity_Date INTO l_start_effectivity_date FROM MTL_ITEM_REVISIONS_B WHERE REVISION_ID = p_rev_id;

2995: -- IF the effectivity is not of date or rev return
2996: BEGIN
2997: IF l_effectivity_control = 1 THEN -- DATE
2998: IF p_explosion_date IS NULL THEN
2999: SELECT Effectivity_Date INTO l_start_effectivity_date FROM MTL_ITEM_REVISIONS_B WHERE REVISION_ID = p_rev_id;
3000: IF(l_start_effectivity_date < SYSDATE) THEN
3001: l_start_effectivity_date := SYSDATE;
3002: END IF;
3003: ELSE

Line 3021: SELECT Revision INTO l_rev_code FROM MTL_ITEM_REVISIONS_B WHERE REVISION_ID = p_rev_id;

3017: AND bcb2.effectivity_date <= l_start_effectivity_date
3018: AND (bcb2.disable_date IS NULL OR bcb2.disable_date > l_start_effectivity_date);
3019:
3020: ELSIF l_effectivity_control = 4 THEN -- REVISION
3021: SELECT Revision INTO l_rev_code FROM MTL_ITEM_REVISIONS_B WHERE REVISION_ID = p_rev_id;
3022: SELECT
3023: bcb2.component_sequence_id INTO l_component_seqeunce_id
3024: FROM
3025: bom_components_b bcb1, bom_components_b bcb2, mtl_item_revisions_b mirb1, mtl_item_revisions_b mirb2

Line 3025: bom_components_b bcb1, bom_components_b bcb2, mtl_item_revisions_b mirb1, mtl_item_revisions_b mirb2

3021: SELECT Revision INTO l_rev_code FROM MTL_ITEM_REVISIONS_B WHERE REVISION_ID = p_rev_id;
3022: SELECT
3023: bcb2.component_sequence_id INTO l_component_seqeunce_id
3024: FROM
3025: bom_components_b bcb1, bom_components_b bcb2, mtl_item_revisions_b mirb1, mtl_item_revisions_b mirb2
3026: WHERE
3027: bcb1.component_sequence_id = p_comp_seq_id
3028: AND bcb1.bill_sequence_id = bcb2.bill_sequence_id
3029: AND nvl(bcb1.obj_name,'EGO_ITEM') = nvl(bcb2.obj_name,'EGO_ITEM')

Line 3330: l_initial_rev mtl_item_revisions_b.revision%TYPE;

3326: IS
3327: l_item_id NUMBER;
3328: l_org_id NUMBER;
3329: l_str_type_id NUMBER;
3330: l_initial_rev mtl_item_revisions_b.revision%TYPE;
3331: BEGIN
3332:
3333: SELECT assembly_item_id, organization_id, structure_type_id
3334: INTO l_item_id, l_org_id, l_str_type_id

Line 3351: FROM mtl_item_revisions_b

3347: ELSE --structure delete
3348: SELECT revision
3349: INTO l_initial_rev
3350: FROM (SELECT revision
3351: FROM mtl_item_revisions_b
3352: WHERE inventory_item_id = l_item_id
3353: AND organization_id = l_org_id
3354: AND implementation_date IS NOT NULL
3355: ORDER BY effectivity_date)