APPS.BOM_OPEN_INTERFACE_API dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 177: select * from mtl_item_revisions_interface

173:
174: orp_cmp_rec get_orphan_comps%ROWTYPE;
175:
176: cursor get_revs (cp_ass_item_name varchar2, cp_org_code varchar2) is
177: select * from mtl_item_revisions_interface
178: where process_flag = 1
179: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
180: and item_number = cp_ass_item_name
181: and organization_code = cp_org_code

Line 188: select * from mtl_item_revisions_interface

184:
185: rev_rec get_revs%ROWTYPE;
186:
187: cursor get_orphan_revs is
188: select * from mtl_item_revisions_interface
189: where process_flag = 1
190: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
191: and transaction_id is not null
192: and set_process_id = nvl(p_batch_id,0);

Line 895: Update mtl_item_revisions_interface

891: l_process_flag := 3;
892: l_ret_status := 1;
893: end if;
894:
895: Update mtl_item_revisions_interface
896: set process_flag = l_process_flag,
897: REQUEST_ID = Fnd_Global.Conc_Request_Id,
898: PROGRAM_ID = Fnd_Global.Conc_program_Id,
899: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

Line 1086: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE

1082: end loop;
1083:
1084: stmt_num := 6;
1085: loop
1086: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE
1087: WHERE PROCESS_FLAG = 7
1088: AND SET_PROCESS_ID = NVL(p_batch_id,0)
1089: AND rownum < 500;
1090: exit when SQL%NOTFOUND ;