APPS.BOM_RTG_OPEN_INTERFACE dependencies on MTL_RTG_ITEM_REVS_INTERFACE

Line 95: select * from MTL_RTG_ITEM_REVS_INTERFACE

91: order by alternate_routing_designator desc; -- bug 3684819, we need primary routings to be processed first
92: rtg_header_rec get_rtg_header%ROWTYPE;
93:
94: cursor get_rtg_revs (cp_ass_item_name varchar2, cp_org_code varchar2) is
95: select * from MTL_RTG_ITEM_REVS_INTERFACE
96: Where process_flag = 1
97: and (p_all_org = 1 or (p_all_org = 2 and organization_id = p_organization_id))
98: and inventory_item_number = cp_ass_item_name
99: and organization_code = cp_org_code

Line 111: select * from MTL_RTG_ITEM_REVS_INTERFACE

107:
108: rtg_revs_rec get_rtg_revs%ROWTYPE;
109:
110: cursor get_orphan_revs is
111: select * from MTL_RTG_ITEM_REVS_INTERFACE
112: Where process_flag = 1
113: and (p_all_org = 1 or (p_all_org = 2 and organization_id = p_organization_id))
114: and transaction_id is not null
115: and

Line 897: Update MTL_RTG_ITEM_REVS_INTERFACE

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

Line 1085: DELETE FROM MTL_RTG_ITEM_REVS_INTERFACE

1081: end loop;
1082:
1083: stmt_num := 6;
1084: loop
1085: DELETE FROM MTL_RTG_ITEM_REVS_INTERFACE
1086: WHERE PROCESS_FLAG = 7
1087: AND
1088: (
1089: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )