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 1780: from mtl_item_revisions_b

1776: Cursor revision_exists(common_assembly_item_id IN NUMBER,
1777: common_org_id IN NUMBER,
1778: common_revision IN VARCHAR2) is
1779: select count(*)
1780: from mtl_item_revisions_b
1781: where inventory_item_id = common_assembly_item_id
1782: and organization_id = common_org_id
1783: and revision = common_revision;
1784: l_revision_exists NUMBER;

Line 2817: from mtl_item_revisions_b

2813: , cp_item_id NUMBER
2814: , cp_org_id NUMBER)
2815: Is
2816: select effectivity_date, revision
2817: from mtl_item_revisions_b
2818: where revision_id = cp_revision_id
2819: and inventory_item_id = cp_item_id
2820: and organization_id = cp_org_id
2821: and implementation_date is not null;

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

2825: Is
2826: SELECT -1
2827: FROM bom_components_b bcb
2828: where bcb.component_sequence_id = cp_comp_sequence_id
2829: AND cp_from_rev_eff >= (SELECT mirb1.effectivity_date FROM mtl_item_revisions_b mirb1
2830: WHERE mirb1.revision_id = bcb.from_end_item_rev_id)
2831: AND (bcb.to_end_item_rev_id is null
2832: OR cp_from_rev_eff <= (SELECT mirb2.effectivity_date FROM mtl_item_revisions_b mirb2
2833: WHERE mirb2.revision_id = bcb.to_end_item_rev_id)

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

2828: where bcb.component_sequence_id = cp_comp_sequence_id
2829: AND cp_from_rev_eff >= (SELECT mirb1.effectivity_date FROM mtl_item_revisions_b mirb1
2830: WHERE mirb1.revision_id = bcb.from_end_item_rev_id)
2831: AND (bcb.to_end_item_rev_id is null
2832: OR cp_from_rev_eff <= (SELECT mirb2.effectivity_date FROM mtl_item_revisions_b mirb2
2833: WHERE mirb2.revision_id = bcb.to_end_item_rev_id)
2834: );
2835:
2836: Cursor get_prev_impl_revision ( cp_item_id NUMBER

Line 2841: from mtl_item_revisions_b mirb1

2837: , cp_org_id NUMBER
2838: , cp_effec_date DATE)
2839: Is
2840: Select mirb1.revision_id, mirb1.effectivity_date
2841: from mtl_item_revisions_b mirb1
2842: where mirb1.inventory_item_id = cp_item_id
2843: and mirb1.organization_id = cp_org_id
2844: and mirb1.effectivity_date < cp_effec_date
2845: and mirb1.implementation_date is not null

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

2860: and bcb.component_item_id = cp_component_item_id
2861: and bcb.operation_seq_num = cp_operation_seq_num
2862: and bcb.implementation_date is not null
2863: and bcb.disable_date is NULL
2864: AND EXISTS (SELECT null FROM mtl_item_revisions_b mirb1 WHERE
2865: mirb1.inventory_item_id = cp_end_item_id AND mirb1.organization_id = cp_org_id
2866: AND mirb1.revision_id = bcb.from_end_item_rev_id)
2867: AND ( cp_to_rev_eff IS NULL
2868: OR cp_to_rev_eff >= (SELECT mirb2.effectivity_date FROM mtl_item_revisions_b mirb2

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

2864: AND EXISTS (SELECT null FROM mtl_item_revisions_b mirb1 WHERE
2865: mirb1.inventory_item_id = cp_end_item_id AND mirb1.organization_id = cp_org_id
2866: AND mirb1.revision_id = bcb.from_end_item_rev_id)
2867: AND ( cp_to_rev_eff IS NULL
2868: OR cp_to_rev_eff >= (SELECT mirb2.effectivity_date FROM mtl_item_revisions_b mirb2
2869: WHERE mirb2.revision_id = bcb.from_end_item_rev_id)
2870: )
2871: AND ( bcb.to_end_item_rev_id IS NULL
2872: OR cp_from_rev_eff <= (SELECT mirb3.effectivity_date FROM mtl_item_revisions_b mirb3

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

2868: OR cp_to_rev_eff >= (SELECT mirb2.effectivity_date FROM mtl_item_revisions_b mirb2
2869: WHERE mirb2.revision_id = bcb.from_end_item_rev_id)
2870: )
2871: AND ( bcb.to_end_item_rev_id IS NULL
2872: OR cp_from_rev_eff <= (SELECT mirb3.effectivity_date FROM mtl_item_revisions_b mirb3
2873: WHERE mirb3.revision_id = bcb.to_end_item_rev_id)
2874: );
2875: -- End Changes: 11510+ Enhancement
2876:

Line 2882: from mtl_item_revisions_b

2878: -- Cusrsor to fetch the revision given the revision id.
2879: Cursor c_get_revision (cp_revision_id NUMBER)
2880: Is
2881: select revision, implementation_date
2882: from mtl_item_revisions_b
2883: where revision_id = cp_revision_id;
2884:
2885: l_revitem_from_rev mtl_item_revisions_b.revision%TYPE;
2886: l_rev_impl_date DATE;

Line 2885: l_revitem_from_rev mtl_item_revisions_b.revision%TYPE;

2881: select revision, implementation_date
2882: from mtl_item_revisions_b
2883: where revision_id = cp_revision_id;
2884:
2885: l_revitem_from_rev mtl_item_revisions_b.revision%TYPE;
2886: l_rev_impl_date DATE;
2887: -- End Changes For bug 4150069
2888: -- Bug 4213886
2889: l_compitem_rev mtl_item_revisions_b.revision%TYPE;

Line 2889: l_compitem_rev mtl_item_revisions_b.revision%TYPE;

2885: l_revitem_from_rev mtl_item_revisions_b.revision%TYPE;
2886: l_rev_impl_date DATE;
2887: -- End Changes For bug 4150069
2888: -- Bug 4213886
2889: l_compitem_rev mtl_item_revisions_b.revision%TYPE;
2890: l_compitem_rev_impldate DATE;
2891:
2892: -- R12 : Changes for common BOM
2893: CURSOR check_if_commoned_bom( cp_bill_id IN NUMBER) IS

Line 4021: Update mtl_item_revisions_b --changed mtl_item_revisions to mtl_item_revisions_b

4017:
4018: --
4019: -- Implement the new revision.
4020: --
4021: Update mtl_item_revisions_b --changed mtl_item_revisions to mtl_item_revisions_b
4022: set implementation_date = today,
4023: effectivity_date = eff_date,
4024: last_update_date = sysdate,
4025: last_updated_by = userid,

Line 4099: FROM MTL_ITEM_REVISIONS_B

4095: set description =
4096: (select MIR1.description
4097: from mtl_item_revisions_tl MIR1
4098: where revision_id IN (SELECT revision_id
4099: FROM MTL_ITEM_REVISIONS_B
4100: WHERE
4101: inventory_item_id = item.revised_item_id
4102: and organization_id = item.organization_id
4103: and revision = item.new_item_revision)

Line 4109: FROM MTL_ITEM_REVISIONS_B

4105: )
4106: where inventory_item_id = common.assembly_item_id
4107: and organization_id = common.organization_id
4108: and revision_id in (SELECT revision_id
4109: FROM MTL_ITEM_REVISIONS_B
4110: WHERE
4111: inventory_item_id = common.assembly_item_id
4112: and organization_id = common.organization_id
4113: and revision = item.new_item_revision);