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 672: FROM mtl_item_revisions

668: -- Promote/Demote change policy check should be done for revision creation
669: IF 'PROMOTE_DEMOTE' = rev_items.attribute_code AND rev_items.attribute_number_value = 3 THEN -- New Revision for item
670: -- Check whether a new revision is created with this change order for the item
671: SELECT count(*) INTO l_pending_changes_count
672: FROM mtl_item_revisions
673: WHERE inventory_item_id = l_inventory_item_id
674: AND organization_id = l_org_id
675: AND revised_item_sequence_id = p_change_line_id
676: AND change_notice = ( SELECT change_notice FROM eng_engineering_changes

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

1509: loginid in number, -- login id
1510: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
1511: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
1512: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
1513: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1514: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1515: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1516: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1517: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,

Line 1730: from mtl_item_revisions r

1726: unimp_rec unimplemented_rev%rowtype;
1727:
1728: Cursor get_current_rev is
1729: Select r.revision, r.effectivity_date
1730: from mtl_item_revisions r
1731: where r.inventory_item_id = item.revised_item_id
1732: and r.organization_id = item.organization_id
1733: and r.effectivity_date = (
1734: select max(cr.effectivity_date)

Line 1735: from mtl_item_revisions cr

1731: where r.inventory_item_id = item.revised_item_id
1732: and r.organization_id = item.organization_id
1733: and r.effectivity_date = (
1734: select max(cr.effectivity_date)
1735: from mtl_item_revisions cr
1736: where cr.inventory_item_id = item.revised_item_id
1737: and cr.organization_id = item.organization_id
1738: and cr.implementation_date is not null
1739: and cr.effectivity_date <= eff_date);

Line 1744: from mtl_item_revisions r

1740: current_revision get_current_rev%rowtype;
1741: ----added r.effectivity_date >= eff_date for bug 5496417
1742: Cursor check_high_date_low_rev is
1743: Select 'x'
1744: from mtl_item_revisions r
1745: where r.inventory_item_id = item.revised_item_id
1746: and r.organization_id = item.organization_id
1747: and r.effectivity_date >= eff_date
1748: and r.revision < item.new_item_revision

Line 1763: from mtl_item_revisions r

1759: common get_common_bills%rowtype;
1760: Cursor get_common_current_rev(common_assembly_item_id IN NUMBER,
1761: common_org_id IN NUMBER) is
1762: Select r.revision
1763: from mtl_item_revisions r
1764: where r.inventory_item_id = common_assembly_item_id
1765: and r.organization_id = common_org_id
1766: and r.effectivity_date = (
1767: select max(cr.effectivity_date)

Line 1768: from mtl_item_revisions cr

1764: where r.inventory_item_id = common_assembly_item_id
1765: and r.organization_id = common_org_id
1766: and r.effectivity_date = (
1767: select max(cr.effectivity_date)
1768: from mtl_item_revisions cr
1769: where cr.inventory_item_id = common_assembly_item_id
1770: and cr.organization_id = common_org_id
1771: and cr.implementation_date is not null
1772: and cr.effectivity_date <= eff_date);

Line 1773: common_current_rev mtl_item_revisions.revision%type;

1769: where cr.inventory_item_id = common_assembly_item_id
1770: and cr.organization_id = common_org_id
1771: and cr.implementation_date is not null
1772: and cr.effectivity_date <= eff_date);
1773: common_current_rev mtl_item_revisions.revision%type;
1774:
1775: --* Added for Bug 4366583
1776: Cursor revision_exists(common_assembly_item_id IN NUMBER,
1777: common_org_id IN NUMBER,

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

4075:
4076: if (( nlssort(common_current_rev) < nlssort(item.new_item_revision))
4077: and ( l_revision_exists = 0)) --* AND condition added for Bug 4366583
4078: then
4079: ENG_COPY_TABLE_ROWS_PKG.C_MTL_ITEM_REVISIONS(
4080: X_inventory_item_id => common.assembly_item_id,
4081: X_organization_id => common.organization_id,
4082: X_revision => item.new_item_revision,
4083: X_last_update_date => SYSDATE,

Line 4094: Update mtl_item_revisions_tl MIR

4090: X_implementation_date => today);
4091: --Start of changes Bug 2963301
4092: Begin
4093: SELECT userenv('LANG') INTO l_language_code FROM dual;
4094: Update mtl_item_revisions_tl MIR
4095: set description =
4096: (select MIR1.description
4097: from mtl_item_revisions_tl MIR1
4098: where revision_id IN (SELECT revision_id

Line 4097: from mtl_item_revisions_tl MIR1

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

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

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

4125: end if;
4126:
4127: end if; -- end of "if new_item_revision is not null"
4128:
4129: --- as there is no updation of description ,updation to mtl_item_revisions_tl is not required
4130: -- Moved this code here so that if new revision gets implemented rev effective structure will get implement successfully 5243333
4131: -- Added For 11510+ Enhancement
4132: -- Fetch the effectivity control of the bill
4133: Open get_bill_effectivity_control(bill_sequence_id);

Line 4452: from mtl_item_revisions

4448: l_wip_bom_revision1 := cum_job_rec.bom_revision;
4449: l_wip_routing_revision1 := cum_job_rec.routing_revision;
4450:
4451: /* select effectivity_date into l_wip_bom_revision_date1
4452: from mtl_item_revisions
4453: where inventory_item_id = item.revised_item_id
4454: and revision = l_wip_bom_revision1
4455: and organization_id = item.organization_id;
4456:

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

8817: loginid in number, -- login id
8818: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
8819: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
8820: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
8821: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
8822: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
8823: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
8824: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
8825: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,