DBA Data[Home] [Help]

APPS.WSMPWROT dependencies on BOM_EXPLOSION_TEMP

Line 205: BOM_EXPLOSION_TEMP BE

201: FROM
202: WIP_OPERATIONS O,
203: BOM_INVENTORY_COMPONENTS A,
204: MTL_SYSTEM_ITEMS C,
205: BOM_EXPLOSION_TEMP BE
206: WHERE
207: BE.GROUP_ID=WSMPWROT.EXPLOSION_GROUP_ID
208: AND BE.TOP_BILL_SEQUENCE_ID=x_bill_sequence_id
209: AND A.COMPONENT_SEQUENCE_ID=BE.COMPONENT_SEQUENCE_ID

Line 408: SELECT BOM_EXPLOSION_TEMP_S.nextval INTO WSMPWROT.EXPLOSION_GROUP_ID

404: x_explode_phantoms := TRUE;
405:
406: l_stmt_num := 46;
407:
408: SELECT BOM_EXPLOSION_TEMP_S.nextval INTO WSMPWROT.EXPLOSION_GROUP_ID
409: FROM DUAL;
410: end if;
411:
412: x_explode_phantoms:=TRUE;

Line 613: select max(plan_level) into no_of_levels from bom_explosion_temp

609: l_level NUMBER := 1;
610: BEGIN
611:
612: l_stmt_num := 70;
613: select max(plan_level) into no_of_levels from bom_explosion_temp
614: where top_bill_sequence_id=x_bill_sequence_id;
615:
616: FOR l_level in 1..no_of_levels LOOP
617: l_stmt_num := 80;

Line 618: update bom_explosion_temp be set be.primary_path_flag=1

614: where top_bill_sequence_id=x_bill_sequence_id;
615:
616: FOR l_level in 1..no_of_levels LOOP
617: l_stmt_num := 80;
618: update bom_explosion_temp be set be.primary_path_flag=1
619: where
620: be.top_bill_sequence_id=x_bill_sequence_id
621: and be.group_id=WSMPWROT.EXPLOSION_GROUP_ID
622: and ((be.operation_seq_num=1)

Line 657: from bom_explosion_temp be1

653: and plan_level=l_level
654: and ((plan_level=1)
655: OR (exists (
656: select 'x'
657: from bom_explosion_temp be1
658: where be1.top_bill_sequence_id=x_bill_sequence_id
659: and be1.group_id=WSMPWROT.EXPLOSION_GROUP_ID
660: and be1.component_item_id=be.assembly_item_id
661: and be1.sort_order=SUBSTR(BE.SORT_ORDER, 1, l_level*(WSMPWROT.X_SortWidth))

Line 668: update bom_explosion_temp be set be.primary_path_flag=1

664: END;
665: else --if ((x_routing_sequence_id is not null) and (x_use_phantom_routings=1) and (x_bill_sequence_id is not null)) then
666:
667: l_stmt_num := 90;
668: update bom_explosion_temp be set be.primary_path_flag=1
669: where be.top_bill_sequence_id=x_bill_sequence_id;
670:
671: t_comp_details.delete(i);
672: end if; --if ((x_routing_sequence_id is not null) and (x_use_phantom_routings=1) and (x_bill_sequence_id is not null)) then

Line 757: BOM_EXPLOSION_TEMP BE

753: x_department_id department_id
754: FROM
755: BOM_INVENTORY_COMPONENTS A,
756: MTL_SYSTEM_ITEMS C,
757: BOM_EXPLOSION_TEMP BE
758: WHERE BE.GROUP_ID = WSMPWROT.EXPLOSION_GROUP_ID
759: AND A.COMPONENT_SEQUENCE_ID = BE.COMPONENT_SEQUENCE_ID
760: AND C.INVENTORY_ITEM_ID = BE.COMPONENT_ITEM_ID
761: AND C.ORGANIZATION_ID = P_ORGANIZATION_ID