APPS.EGO_MASS_UPDATE_PVT dependencies on EGO_MASSUPDATE_ITEM_TMP

Line 83: FROM ego_massupdate_item_tmp

79:
80: --In Context org - For primary uom defaulting
81: SELECT DISTINCT organization_id
82: INTO l_in_context_organization_id
83: FROM ego_massupdate_item_tmp
84: WHERE batch_id = p_batch_id;
85:
86: -- =====================================================================
87: -- Insert all Item-Org pairs into Item Open Interface Table - MSII with

Line 155: FROM ego_massupdate_item_tmp emit,

151: FND_GLOBAL.conc_request_id,
152: FND_GLOBAL.prog_appl_id,
153: FND_GLOBAL.conc_program_id,
154: SYSDATE
155: FROM ego_massupdate_item_tmp emit,
156: ego_massupdate_org_tmp emot,
157: mtl_parameters mp
158: WHERE NOT EXISTS
159: (SELECT '1'

Line 347: DELETE ego_massupdate_item_tmp where to_date(to_char (creation_date,'hh24:mi:ss

343: FND_FILE.put_line(FND_FILE.log,errbuf);
344: RETURN;
345: END IF;
346:
347: DELETE ego_massupdate_item_tmp where to_date(to_char (creation_date,'hh24:mi:ss
348: dd-mm-yyyy'),'hh24:mi:ss dd-mm-yyyy') < to_date(to_char (sysdate-hours/24,'hh24:mi:ss
349: dd-mm-yyyy'),'hh24:mi:ss dd-mm-yyyy');
350:
351: DELETE ego_massupdate_org_tmp where to_date(to_char (creation_date,'hh24:mi:ss