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_RTG_ITEM_REVISIONS

Line 1586: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,

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,
1590: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,

Line 2161: FROM mtl_rtg_item_revisions r

2157: unimp_ref_rec unimplemented_rtg_rev%ROWTYPE;
2158:
2159: CURSOR check_highEffDate_lowRtgRev IS
2160: SELECT 'x'
2161: FROM mtl_rtg_item_revisions r
2162: WHERE r.inventory_item_id = item.revised_item_id
2163: AND r.organization_id = item.organization_id
2164: AND r.effectivity_date > eff_date
2165: AND r.process_revision < item.new_routing_revision --bug 3476154

Line 2182: from mtl_rtg_item_revisions r

2178:
2179: CURSOR get_common_current_routing_rev(common_assembly_item_id IN NUMBER,
2180: common_org_id IN NUMBER) is
2181: Select r.process_revision
2182: from mtl_rtg_item_revisions r
2183: where r.inventory_item_id = common_assembly_item_id
2184: and r.organization_id = common_org_id
2185: and r.effectivity_date = (
2186: select max(cr.effectivity_date)

Line 2187: from mtl_rtg_item_revisions cr

2183: where r.inventory_item_id = common_assembly_item_id
2184: and r.organization_id = common_org_id
2185: and r.effectivity_date = (
2186: select max(cr.effectivity_date)
2187: from mtl_rtg_item_revisions cr
2188: where cr.inventory_item_id = common_assembly_item_id
2189: and cr.organization_id = common_org_id
2190: and cr.implementation_date is not null
2191: and cr.effectivity_date <= eff_date);

Line 2192: common_current_rtg_rev mtl_rtg_item_revisions.process_revision%type;

2188: where cr.inventory_item_id = common_assembly_item_id
2189: and cr.organization_id = common_org_id
2190: and cr.implementation_date is not null
2191: and cr.effectivity_date <= eff_date);
2192: common_current_rtg_rev mtl_rtg_item_revisions.process_revision%type;
2193:
2194: --* Added for Bug 4366583
2195: Cursor routing_revision_exists(common_assembly_item_id IN NUMBER,
2196: common_org_id IN NUMBER,

Line 2199: from mtl_rtg_item_revisions

2195: Cursor routing_revision_exists(common_assembly_item_id IN NUMBER,
2196: common_org_id IN NUMBER,
2197: common_revision IN VARCHAR2) is
2198: select count(*)
2199: from mtl_rtg_item_revisions
2200: where inventory_item_id = common_assembly_item_id
2201: and organization_id = common_org_id
2202: and process_revision = common_revision;
2203: l_rtg_revision_exists NUMBER;

Line 2209: FROM mtl_rtg_item_revisions r

2205:
2206: CURSOR get_current_routing_rev IS
2207: SELECT r.process_revision,
2208: r.effectivity_date
2209: FROM mtl_rtg_item_revisions r
2210: WHERE r.inventory_item_id = item.revised_item_id
2211: AND r.organization_id = item.organization_id
2212: AND r.effectivity_date = (
2213: SELECT max(cr.effectivity_date)

Line 2214: FROM mtl_rtg_item_revisions cr

2210: WHERE r.inventory_item_id = item.revised_item_id
2211: AND r.organization_id = item.organization_id
2212: AND r.effectivity_date = (
2213: SELECT max(cr.effectivity_date)
2214: FROM mtl_rtg_item_revisions cr
2215: WHERE cr.inventory_item_id = item.revised_item_id
2216: AND cr.organization_id = item.organization_id
2217: AND cr.implementation_date is not null
2218: AND cr.effectivity_date <= eff_date);

Line 4716: from mtl_rtg_item_revisions

4712: and revision = l_wip_bom_revision1
4713: and organization_id = item.organization_id;
4714:
4715: select effectivity_date into l_wip_routing_revision_date1
4716: from mtl_rtg_item_revisions
4717: where inventory_item_id = item.revised_item_id
4718: and process_revision = l_wip_routing_revision1
4719: and organization_id = item.organization_id;
4720: */

Line 4980: UPDATE mtl_rtg_item_revisions

4976: This is done to prevent the updation of the effectivity_date of the current rtg rev.*/
4977:
4978: ELSIF nlssort(l_current_rtg_revision) < nlssort(item.new_routing_revision) THEN
4979: -- implement the new routing revision
4980: UPDATE mtl_rtg_item_revisions
4981: SET implementation_date = today,
4982: effectivity_date = eff_date,
4983: last_update_date = sysdate,
4984: last_updated_by = userid,

Line 5001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in mtl_rtg_item_revisions... bERES_Flag_for_Routing=TRUE');

4997: -- ERES flag to be set for triggering Routing Event:
4998: bERES_Flag_for_Routing := TRUE;
4999: -- Bug 4455543: Set l_WIP_Flag_for_Routing when routing revision is being updated by revised item
5000: l_WIP_Flag_for_Routing := 'Y';
5001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in mtl_rtg_item_revisions... bERES_Flag_for_Routing=TRUE');
5002: END IF;
5003: -- ERES changes end.
5004:
5005: END IF; -- end of nlssort(current_routing_revision)

Line 5045: ENG_COPY_TABLE_ROWS_PKG.C_MTL_RTG_ITEM_REVISIONS(

5041: --- 2809431 NULL;
5042: -- 2809431 ( added the below API to Populate common routing revision)
5043:
5044:
5045: ENG_COPY_TABLE_ROWS_PKG.C_MTL_RTG_ITEM_REVISIONS(
5046: X_inventory_item_id => common_routing.assembly_item_id,
5047: X_organization_id => common_routing.organization_id,
5048: X_process_revision => item.new_routing_revision,
5049: X_last_update_date => SYSDATE,

Line 9081: -- DELETE FROM mtl_rtg_item_revisions

9077: END IF;
9078:
9079:
9080: --Delete the related routing revision record
9081: -- DELETE FROM mtl_rtg_item_revisions
9082: -- WHERE inventory_item_id = p_revised_item
9083: -- AND organization_id = p_organization_id
9084: -- AND process_revision = p_new_routing_revision;
9085:

Line 9167: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,

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,
9171: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,