APPS.BOM_OPEN_INTERFACE_API dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 134: select * from BOM_INVENTORY_COMPS_INTERFACE A

130:
131: bill_rec get_bills%ROWTYPE;
132:
133: cursor get_comps (cp_ass_item_name varchar2, cp_org_code varchar2, cp_alt_des varchar2) is
134: select * from BOM_INVENTORY_COMPS_INTERFACE A
135: where process_flag = 1
136: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
137: and assembly_item_number = cp_ass_item_name
138: and organization_code = cp_org_code

Line 152: select * from BOM_INVENTORY_COMPS_INTERFACE

148:
149: comp_rec get_comps%ROWTYPE;
150:
151: cursor get_orphan_comps is
152: select * from BOM_INVENTORY_COMPS_INTERFACE
153: where process_flag = 1
154: and all_org = 1
155: and transaction_id is not null
156: and

Line 163: SELECT * FROM BOM_INVENTORY_COMPS_INTERFACE

159: or ( p_batch_id = batch_id )
160: )
161: and rownum = 1
162: UNION ALL
163: SELECT * FROM BOM_INVENTORY_COMPS_INTERFACE
164: WHERE process_flag = 1
165: AND all_org = 2 and organization_id = org_id
166: AND transaction_id is not null
167: AND rownum =1

Line 918: Update bom_inventory_comps_interface

914: l_process_flag := 3;
915: l_ret_status := 1;
916: end if;
917:
918: Update bom_inventory_comps_interface
919: set process_flag = l_process_flag,
920: REQUEST_ID = Fnd_Global.Conc_Request_Id,
921: PROGRAM_ID = Fnd_Global.Conc_program_Id,
922: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

Line 1030: DELETE FROM BOM_INVENTORY_COMPS_INTERFACE

1026: end loop;
1027:
1028: stmt_num := 2;
1029: loop
1030: DELETE FROM BOM_INVENTORY_COMPS_INTERFACE
1031: WHERE PROCESS_FLAG = 7
1032: AND
1033: (
1034: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )