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

Line 744: FROM mtl_item_revisions

740: -- Promote/Demote change policy check should be done for revision creation
741: IF 'PROMOTE_DEMOTE' = rev_items.attribute_code AND rev_items.attribute_number_value = 3 THEN -- New Revision for item
742: -- Check whether a new revision is created with this change order for the item
743: SELECT count(*) INTO l_pending_changes_count
744: FROM mtl_item_revisions
745: WHERE inventory_item_id = l_inventory_item_id
746: AND organization_id = l_org_id
747: AND revised_item_sequence_id = p_change_line_id
748: AND change_notice = ( SELECT change_notice FROM eng_engineering_changes

Line 1585: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,

1581: loginid in number, -- login id
1582: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
1583: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
1584: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
1585: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1586: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1587: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1588: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1589: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,

Line 1808: from mtl_item_revisions r

1804: unimp_rec unimplemented_rev%rowtype;
1805:
1806: Cursor get_current_rev is
1807: Select r.revision, r.effectivity_date
1808: from mtl_item_revisions r
1809: where r.inventory_item_id = item.revised_item_id
1810: and r.organization_id = item.organization_id
1811: and r.effectivity_date = (
1812: select max(cr.effectivity_date)

Line 1813: from mtl_item_revisions cr

1809: where r.inventory_item_id = item.revised_item_id
1810: and r.organization_id = item.organization_id
1811: and r.effectivity_date = (
1812: select max(cr.effectivity_date)
1813: from mtl_item_revisions cr
1814: where cr.inventory_item_id = item.revised_item_id
1815: and cr.organization_id = item.organization_id
1816: and cr.implementation_date is not null
1817: and cr.effectivity_date <= eff_date

Line 1823: from mtl_item_revisions r

1819: current_revision get_current_rev%rowtype;
1820: ----added r.effectivity_date >= eff_date for bug 5496417
1821: Cursor check_high_date_low_rev is
1822: Select 'x'
1823: from mtl_item_revisions r
1824: where r.inventory_item_id = item.revised_item_id
1825: and r.organization_id = item.organization_id
1826: and r.effectivity_date >= eff_date
1827: and r.revision < item.new_item_revision

Line 1853: from mtl_item_revisions r

1849: common get_common_bills%rowtype;
1850: Cursor get_common_current_rev(common_assembly_item_id IN NUMBER,
1851: common_org_id IN NUMBER) is
1852: Select r.revision
1853: from mtl_item_revisions r
1854: where r.inventory_item_id = common_assembly_item_id
1855: and r.organization_id = common_org_id
1856: and r.effectivity_date = (
1857: select max(cr.effectivity_date)

Line 1858: from mtl_item_revisions cr

1854: where r.inventory_item_id = common_assembly_item_id
1855: and r.organization_id = common_org_id
1856: and r.effectivity_date = (
1857: select max(cr.effectivity_date)
1858: from mtl_item_revisions cr
1859: where cr.inventory_item_id = common_assembly_item_id
1860: and cr.organization_id = common_org_id
1861: and cr.implementation_date is not null
1862: and cr.effectivity_date <= eff_date);

Line 1863: common_current_rev mtl_item_revisions.revision%type;

1859: where cr.inventory_item_id = common_assembly_item_id
1860: and cr.organization_id = common_org_id
1861: and cr.implementation_date is not null
1862: and cr.effectivity_date <= eff_date);
1863: common_current_rev mtl_item_revisions.revision%type;
1864:
1865: --* Added for Bug 4366583
1866: Cursor revision_exists(common_assembly_item_id IN NUMBER,
1867: common_org_id IN NUMBER,

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 4337: ENG_COPY_TABLE_ROWS_PKG.C_MTL_ITEM_REVISIONS(

4333:
4334: if (( nlssort(common_current_rev) < nlssort(item.new_item_revision))
4335: and ( l_revision_exists = 0)) --* AND condition added for Bug 4366583
4336: then
4337: ENG_COPY_TABLE_ROWS_PKG.C_MTL_ITEM_REVISIONS(
4338: X_inventory_item_id => common.assembly_item_id,
4339: X_organization_id => common.organization_id,
4340: X_revision => item.new_item_revision,
4341: X_last_update_date => SYSDATE,

Line 4352: Update mtl_item_revisions_tl MIR

4348: X_implementation_date => today);
4349: --Start of changes Bug 2963301
4350: Begin
4351: SELECT userenv('LANG') INTO l_language_code FROM dual;
4352: Update mtl_item_revisions_tl MIR
4353: set description =
4354: (select MIR1.description
4355: from mtl_item_revisions_tl MIR1
4356: where revision_id IN (SELECT revision_id

Line 4355: from mtl_item_revisions_tl MIR1

4351: SELECT userenv('LANG') INTO l_language_code FROM dual;
4352: Update mtl_item_revisions_tl MIR
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

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);

Line 4387: --- as there is no updation of description ,updation to mtl_item_revisions_tl is not required

4383: end if;
4384:
4385: end if; -- end of "if new_item_revision is not null"
4386:
4387: --- as there is no updation of description ,updation to mtl_item_revisions_tl is not required
4388: -- Moved this code here so that if new revision gets implemented rev effective structure will get implement successfully 5243333
4389: -- Added For 11510+ Enhancement
4390: -- Fetch the effectivity control of the bill
4391: Open get_bill_effectivity_control(bill_sequence_id);

Line 4710: from mtl_item_revisions

4706: l_wip_bom_revision1 := cum_job_rec.bom_revision;
4707: l_wip_routing_revision1 := cum_job_rec.routing_revision;
4708:
4709: /* select effectivity_date into l_wip_bom_revision_date1
4710: from mtl_item_revisions
4711: where inventory_item_id = item.revised_item_id
4712: and revision = l_wip_bom_revision1
4713: and organization_id = item.organization_id;
4714:

Line 9166: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,

9162: loginid in number, -- login id
9163: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
9164: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
9165: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
9166: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
9167: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
9168: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
9169: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
9170: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,