APPS.BOMPPRCB dependencies on ENG_ENG_CHANGES_INTERFACE

Line 1090: from ENG_ENG_CHANGES_INTERFACE

1086: CHANGE_ORDER_TYPE_ID,
1087: RESPONSIBLE_ORGANIZATION_ID,
1088: APPROVAL_REQUEST_DATE,
1089: DDF_CONTEXT
1090: from ENG_ENG_CHANGES_INTERFACE
1091: where set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1092:
1093: /*
1094: ** Process revised items interface table

Line 1193: ENG_ENG_CHANGES_INTERFACE e1

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;
1197:

Line 1420: from ENG_ENG_CHANGES_INTERFACE e,

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')))
1423: and e.organization_id = e1.organization_id
1424: and e.change_notice = e1.change_notice);

Line 1427: table_name := 'ENG_ENG_CHANGES_INTERFACE';

1423: and e.organization_id = e1.organization_id
1424: and e.change_notice = e1.change_notice);
1425:
1426: stmt_num := 260;
1427: table_name := 'ENG_ENG_CHANGES_INTERFACE';
1428: delete from ENG_ENG_CHANGES_INTERFACE
1429: where set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1430:
1431: */

Line 1428: delete from ENG_ENG_CHANGES_INTERFACE

1424: and e.change_notice = e1.change_notice);
1425:
1426: stmt_num := 260;
1427: table_name := 'ENG_ENG_CHANGES_INTERFACE';
1428: delete from ENG_ENG_CHANGES_INTERFACE
1429: where set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1430:
1431: */
1432: end if;