DBA Data[Home] [Help]

APPS.EAM_EXPLODE_ACTIVITY_PVT dependencies on BOM_EXPLOSION_TEMP

Line 383: FROM BOM_EXPLOSION_TEMP BE

379: , null PROGRAM_ID
380: , null PROGRAM_UPDATE_DATE
381: , null RETURN_STATUS
382: , 1 TRANSACTION_TYPE
383: FROM BOM_EXPLOSION_TEMP BE
384: , BOM_INVENTORY_COMPONENTS BIC
385: , MTL_SYSTEM_ITEMS MSI
386: WHERE BE.GROUP_ID = v_grpID
387: AND BE.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID

Line 446: FROM BOM_EXPLOSION_TEMP BE

442: , null PROGRAM_ID
443: , null PROGRAM_UPDATE_DATE
444: , null RETURN_STATUS
445: , 1 TRANSACTION_TYPE
446: FROM BOM_EXPLOSION_TEMP BE
447: , BOM_INVENTORY_COMPONENTS BIC
448: , BOM_OPERATIONAL_ROUTINGS BORT
449: , BOM_OPERATION_SEQUENCES BOS
450: , MTL_SYSTEM_ITEMS MSI

Line 627: bom_explosion_temp_s.nextval

623: --make sure the records are not locked.
624:
625:
626: select
627: bom_explosion_temp_s.nextval
628: into l_group_id
629: from dual;
630:
631:

Line 717: delete bom_explosion_temp

713: l_eam_mat_req_tbl(n).TRANSACTION_TYPE := matreqrec.TRANSACTION_TYPE;
714:
715: end loop;
716:
717: delete bom_explosion_temp
718: where group_id = l_group_id;
719:
720: declare
721: l_owning_department number;