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.BOMPPRCB dependencies on ENG_REVISED_ITEMS

Line 1097: table_name := 'ENG_REVISED_ITEMS';

1093: /*
1094: ** Process revised items interface table
1095: */
1096: stmt_num := 120;
1097: table_name := 'ENG_REVISED_ITEMS';
1098: insert into ENG_REVISED_ITEMS
1099: (
1100: CHANGE_NOTICE,
1101: ORGANIZATION_ID,

Line 1098: insert into ENG_REVISED_ITEMS

1094: ** Process revised items interface table
1095: */
1096: stmt_num := 120;
1097: table_name := 'ENG_REVISED_ITEMS';
1098: insert into ENG_REVISED_ITEMS
1099: (
1100: CHANGE_NOTICE,
1101: ORGANIZATION_ID,
1102: REVISED_ITEM_ID,

Line 1192: from ENG_REVISED_ITEMS_INTERFACE e,

1188: e.USE_UP ,
1189: e.USE_UP_ITEM_ID ,
1190: e.REVISED_ITEM_SEQUENCE_ID,
1191: e.USE_UP_PLAN_NAME
1192: from ENG_REVISED_ITEMS_INTERFACE e,
1193: ENG_ENG_CHANGES_INTERFACE e1
1194: where e1.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1195: and e.change_notice = e1.change_notice
1196: and e.organization_id = e1.organization_id;

Line 1417: table_name := 'ENG_REVISED_ITEMS_INTERFACE';

1413:
1414: /*
1415: This is commented out since we do not insert into these tables anyway
1416: stmt_num := 250;
1417: table_name := 'ENG_REVISED_ITEMS_INTERFACE';
1418: delete from ENG_REVISED_ITEMS_INTERFACE
1419: where exists ( select 1
1420: from ENG_ENG_CHANGES_INTERFACE e,
1421: ENG_REVISED_ITEMS_INTERFACE e1

Line 1418: delete from ENG_REVISED_ITEMS_INTERFACE

1414: /*
1415: This is commented out since we do not insert into these tables anyway
1416: stmt_num := 250;
1417: table_name := 'ENG_REVISED_ITEMS_INTERFACE';
1418: delete from ENG_REVISED_ITEMS_INTERFACE
1419: where exists ( select 1
1420: from ENG_ENG_CHANGES_INTERFACE e,
1421: ENG_REVISED_ITEMS_INTERFACE e1
1422: where e.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))

Line 1421: ENG_REVISED_ITEMS_INTERFACE e1

1417: table_name := 'ENG_REVISED_ITEMS_INTERFACE';
1418: delete from ENG_REVISED_ITEMS_INTERFACE
1419: where exists ( select 1
1420: from ENG_ENG_CHANGES_INTERFACE e,
1421: ENG_REVISED_ITEMS_INTERFACE e1
1422: where e.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1423: and e.organization_id = e1.organization_id
1424: and e.change_notice = e1.change_notice);
1425: