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.ENGPKIMP dependencies on MTL_ITEM_REVISIONS_B

Line 1870: from mtl_item_revisions_b

1866: Cursor revision_exists(common_assembly_item_id IN NUMBER,
1867: common_org_id IN NUMBER,
1868: common_revision IN VARCHAR2) is
1869: select count(*)
1870: from mtl_item_revisions_b
1871: where inventory_item_id = common_assembly_item_id
1872: and organization_id = common_org_id
1873: and revision = common_revision;
1874: l_revision_exists NUMBER;

Line 2948: from mtl_item_revisions_b

2944: , cp_item_id NUMBER
2945: , cp_org_id NUMBER)
2946: Is
2947: select effectivity_date, revision
2948: from mtl_item_revisions_b
2949: where revision_id = cp_revision_id
2950: and inventory_item_id = cp_item_id
2951: and organization_id = cp_org_id
2952: and implementation_date is not null;

Line 2960: AND cp_from_rev_eff >= (SELECT mirb1.effectivity_date FROM mtl_item_revisions_b mirb1

2956: Is
2957: SELECT -1
2958: FROM bom_components_b bcb
2959: where bcb.component_sequence_id = cp_comp_sequence_id
2960: AND cp_from_rev_eff >= (SELECT mirb1.effectivity_date FROM mtl_item_revisions_b mirb1
2961: WHERE mirb1.revision_id = bcb.from_end_item_rev_id)
2962: AND (bcb.to_end_item_rev_id is null
2963: OR cp_from_rev_eff <= (SELECT mirb2.effectivity_date FROM mtl_item_revisions_b mirb2
2964: WHERE mirb2.revision_id = bcb.to_end_item_rev_id)

Line 2963: OR cp_from_rev_eff <= (SELECT mirb2.effectivity_date FROM mtl_item_revisions_b mirb2

2959: where bcb.component_sequence_id = cp_comp_sequence_id
2960: AND cp_from_rev_eff >= (SELECT mirb1.effectivity_date FROM mtl_item_revisions_b mirb1
2961: WHERE mirb1.revision_id = bcb.from_end_item_rev_id)
2962: AND (bcb.to_end_item_rev_id is null
2963: OR cp_from_rev_eff <= (SELECT mirb2.effectivity_date FROM mtl_item_revisions_b mirb2
2964: WHERE mirb2.revision_id = bcb.to_end_item_rev_id)
2965: );
2966:
2967: Cursor get_prev_impl_revision ( cp_item_id NUMBER

Line 2972: from mtl_item_revisions_b mirb1

2968: , cp_org_id NUMBER
2969: , cp_effec_date DATE)
2970: Is
2971: Select mirb1.revision_id, mirb1.effectivity_date
2972: from mtl_item_revisions_b mirb1
2973: where mirb1.inventory_item_id = cp_item_id
2974: and mirb1.organization_id = cp_org_id
2975: and mirb1.effectivity_date < cp_effec_date
2976: and mirb1.implementation_date is not null

Line 2995: AND EXISTS (SELECT null FROM mtl_item_revisions_b mirb1 WHERE

2991: and bcb.component_item_id = cp_component_item_id
2992: and bcb.operation_seq_num = cp_operation_seq_num
2993: and bcb.implementation_date is not null
2994: and bcb.disable_date is NULL
2995: AND EXISTS (SELECT null FROM mtl_item_revisions_b mirb1 WHERE
2996: mirb1.inventory_item_id = cp_end_item_id AND mirb1.organization_id = cp_org_id
2997: AND mirb1.revision_id = bcb.from_end_item_rev_id)
2998: AND ( cp_to_rev_eff IS NULL
2999: OR cp_to_rev_eff >= (SELECT mirb2.effectivity_date FROM mtl_item_revisions_b mirb2

Line 2999: OR cp_to_rev_eff >= (SELECT mirb2.effectivity_date FROM mtl_item_revisions_b mirb2

2995: AND EXISTS (SELECT null FROM mtl_item_revisions_b mirb1 WHERE
2996: mirb1.inventory_item_id = cp_end_item_id AND mirb1.organization_id = cp_org_id
2997: AND mirb1.revision_id = bcb.from_end_item_rev_id)
2998: AND ( cp_to_rev_eff IS NULL
2999: OR cp_to_rev_eff >= (SELECT mirb2.effectivity_date FROM mtl_item_revisions_b mirb2
3000: WHERE mirb2.revision_id = bcb.from_end_item_rev_id)
3001: )
3002: AND ( bcb.to_end_item_rev_id IS NULL
3003: OR cp_from_rev_eff <= (SELECT mirb3.effectivity_date FROM mtl_item_revisions_b mirb3

Line 3003: OR cp_from_rev_eff <= (SELECT mirb3.effectivity_date FROM mtl_item_revisions_b mirb3

2999: OR cp_to_rev_eff >= (SELECT mirb2.effectivity_date FROM mtl_item_revisions_b mirb2
3000: WHERE mirb2.revision_id = bcb.from_end_item_rev_id)
3001: )
3002: AND ( bcb.to_end_item_rev_id IS NULL
3003: OR cp_from_rev_eff <= (SELECT mirb3.effectivity_date FROM mtl_item_revisions_b mirb3
3004: WHERE mirb3.revision_id = bcb.to_end_item_rev_id)
3005: );
3006: -- End Changes: 11510+ Enhancement
3007:

Line 3013: from mtl_item_revisions_b

3009: -- Cusrsor to fetch the revision given the revision id.
3010: Cursor c_get_revision (cp_revision_id NUMBER)
3011: Is
3012: select revision, implementation_date
3013: from mtl_item_revisions_b
3014: where revision_id = cp_revision_id;
3015:
3016: l_revitem_from_rev mtl_item_revisions_b.revision%TYPE;
3017: l_rev_impl_date DATE;

Line 3016: l_revitem_from_rev mtl_item_revisions_b.revision%TYPE;

3012: select revision, implementation_date
3013: from mtl_item_revisions_b
3014: where revision_id = cp_revision_id;
3015:
3016: l_revitem_from_rev mtl_item_revisions_b.revision%TYPE;
3017: l_rev_impl_date DATE;
3018: -- End Changes For bug 4150069
3019: -- Bug 4213886
3020: l_compitem_rev mtl_item_revisions_b.revision%TYPE;

Line 3020: l_compitem_rev mtl_item_revisions_b.revision%TYPE;

3016: l_revitem_from_rev mtl_item_revisions_b.revision%TYPE;
3017: l_rev_impl_date DATE;
3018: -- End Changes For bug 4150069
3019: -- Bug 4213886
3020: l_compitem_rev mtl_item_revisions_b.revision%TYPE;
3021: l_compitem_rev_impldate DATE;
3022:
3023: -- R12 : Changes for common BOM
3024: CURSOR check_if_commoned_bom( cp_bill_id IN NUMBER) IS

Line 4279: Update mtl_item_revisions_b --changed mtl_item_revisions to mtl_item_revisions_b

4275:
4276: --
4277: -- Implement the new revision.
4278: --
4279: Update mtl_item_revisions_b --changed mtl_item_revisions to mtl_item_revisions_b
4280: set implementation_date = today,
4281: effectivity_date = eff_date,
4282: last_update_date = sysdate,
4283: last_updated_by = userid,

Line 4357: FROM MTL_ITEM_REVISIONS_B

4353: set description =
4354: (select MIR1.description
4355: from mtl_item_revisions_tl MIR1
4356: where revision_id IN (SELECT revision_id
4357: FROM MTL_ITEM_REVISIONS_B
4358: WHERE
4359: inventory_item_id = item.revised_item_id
4360: and organization_id = item.organization_id
4361: and revision = item.new_item_revision)

Line 4367: FROM MTL_ITEM_REVISIONS_B

4363: )
4364: where inventory_item_id = common.assembly_item_id
4365: and organization_id = common.organization_id
4366: and revision_id in (SELECT revision_id
4367: FROM MTL_ITEM_REVISIONS_B
4368: WHERE
4369: inventory_item_id = common.assembly_item_id
4370: and organization_id = common.organization_id
4371: and revision = item.new_item_revision);