APPS.BOMPXINQ dependencies on BOM_SMALL_EXPL_TEMP

Line 18: | use value from sequence bom_small_expl_temp_s

14: | Parameters: org_id organization_id
15: | order_by 1 - Op seq, item seq
16: | 2 - Item seq, op seq
17: | grp_id unique value to identify current explosion
18: | use value from sequence bom_small_expl_temp_s
19: | session_id unique value to identify current session
20: | use value from bom_small_expl_temp_session_s
21: | levels_to_explode
22: | bom_or_eng 1 - BOM

Line 20: | use value from bom_small_expl_temp_session_s

16: | 2 - Item seq, op seq
17: | grp_id unique value to identify current explosion
18: | use value from sequence bom_small_expl_temp_s
19: | session_id unique value to identify current session
20: | use value from bom_small_expl_temp_session_s
21: | levels_to_explode
22: | bom_or_eng 1 - BOM
23: | 2 - ENG
24: | impl_flag 1 - implemented only

Line 245: FROM BOM_SMALL_EXPL_TEMP

241: SELECT
242: COMPONENT_CODE,
243: LOOP_FLAG,
244: PLAN_LEVEL
245: FROM BOM_SMALL_EXPL_TEMP
246: WHERE GROUP_ID = c_group_id
247: AND LOOP_FLAG = 1;
248: BEGIN
249:

Line 252: FROM BOM_SMALL_EXPL_TEMP

248: BEGIN
249:
250: SELECT NVL( TOP_ALTERNATE_DESIGNATOR, 'none' ), ORGANIZATION_ID
251: INTO top_alt, org_id
252: FROM BOM_SMALL_EXPL_TEMP
253: WHERE GROUP_ID = grp_id
254: AND ROWNUM = 1
255: AND PLAN_LEVEL = 0;
256:

Line 369: from BOM_SMALL_EXPL_TEMP BET

365: BET.component_item_id curCII,
366: BET.common_bill_sequence_id curCBSI,
367: BET.group_id curGI,
368: BET.primary_uom_code curPUC
369: from BOM_SMALL_EXPL_TEMP BET
370: where BET.bill_sequence_id <> BET.common_bill_sequence_id
371: and BET.group_id = grp_id;
372: --Bug 2088686
373:

Line 400: insert into bom_small_expl_temp

396: raise parameter_error;
397: end if;
398:
399: stmt_num := 2;
400: insert into bom_small_expl_temp
401: (
402: group_id,
403: bill_sequence_id,
404: component_sequence_id,

Line 558: UPDATE BOM_SMALL_EXPL_TEMP

554: -- If cost_organization is Master organization then the item cost should be
555: -- calculated by multiplying the conversion_rate.
556:
557: if is_cost_organization <> 'Y' then
558: UPDATE BOM_SMALL_EXPL_TEMP
559: SET item_cost = item_cost*t_conversion_rate
560: WHERE group_id = cr.curGI and
561: component_sequence_id = cr.curCSI and
562: bill_sequence_id = cr.curBSI and

Line 567: UPDATE BOM_SMALL_EXPL_TEMP

563: common_bill_sequence_id = cr.curCBSI;
564: end if;
565: --Bug 2157325 End
566:
567: UPDATE BOM_SMALL_EXPL_TEMP
568: SET component_quantity = component_quantity/t_conversion_rate,
569: extended_quantity = extended_quantity/t_conversion_rate,
570: -- item_cost = item_cost*t_conversion_rate,
571: primary_uom_code = cr.curPUC

Line 665: -- cursor to obtain exploded bom from bom_small_expl_temp table

661: no_level_access EXCEPTION;
662: no_assy EXCEPTION;
663: no_list EXCEPTION;
664:
665: -- cursor to obtain exploded bom from bom_small_expl_temp table
666: CURSOR export_tab (l_organization_id NUMBER, l_group_id NUMBER) IS
667: SELECT
668: TOP_BILL_SEQUENCE_ID ,
669: BILL_SEQUENCE_ID ,

Line 731: FROM bom_small_expl_temp

727: ATTRIBUTE14 ,
728: ATTRIBUTE15 ,
729: ITEM_COST ,
730: EXTEND_COST_FLAG
731: FROM bom_small_expl_temp
732: WHERE
733: Organization_id = l_organization_id
734: AND GROUP_ID = l_group_id;
735:

Line 825: DELETE from bom_small_expl_temp where group_id =l_group_id;

821:
822: SELECT bom_explosion_temp_s.nextval
823: INTO l_group_id from dual;
824:
825: DELETE from bom_small_expl_temp where group_id =l_group_id;
826:
827: --dbms_output.put_line('calling explosion . . . ');
828:
829: exploder_userexit (

Line 963: DELETE from bom_small_expl_temp where group_id =l_group_id;

959: bom_export_tab(i_count).EXTEND_COST_FLAG :=
960: loop_tab.EXTEND_COST_FLAG ;
961: i_count := i_count +1;
962: end loop ;
963: DELETE from bom_small_expl_temp where group_id =l_group_id;
964: end if;
965: end if;
966: l_assembly_found := TRUE;
967: END LOOP;