eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on BOM_EXPLOSION_TEMP

Line 113: | row from bom_explosion_temp

109: | 03/26/02 Refai Farook Operation sequence number inheritance lo
110: gic has been changed
111: | 03/27/02 Refai Farook Club component quantitites will be using
112: rowid to identify the unique
113: | row from bom_explosion_temp
114: |
115: |************************************************************************
116: |
117: |

Line 475: FROM bom_explosion_temp be

471: SYSDATE, /* Implementation Date */
472: be.wip_supply_type, /* wip_supply_type */
473: substr(be.pricing_attribute1,1,30), /* Used for From_Unit_Number */
474: substr(be.pricing_attribute2,1,30) /* Used for To_Unit_Number */
475: FROM bom_explosion_temp be
476: WHERE be.bill_sequence_id = p_Bill_Sequence_id;
477:
478: -- dbms_output.put_line('Transfer Complete . . .No. Of Comps Transfered: ' || sql%rowcount);
479:

Line 505: FROM bom_explosion_temp bet

501: , bet.operation_seq_num
502: , bet.component_sequence_id
503: , round( bet.component_quantity, 7 ) component_quantity /* Support Decimal-Qty for Option Items */
504: , rowid /* Sushant added on 19-Aug-2002 */
505: FROM bom_explosion_temp bet
506: WHERE bill_sequence_id = p_bill_sequence_id
507: ORDER BY bet.bill_sequence_id,
508: bet.component_item_id,
509: bet.operation_seq_num;

Line 519: from bom_explosion_temp

515: l_rowid VARCHAR2(50); /* Added by Sushant on 19-Aug-2002*/
516:
517: cursor bill_list is
518: select component_item_id, operation_seq_num, component_sequence_id
519: from bom_explosion_temp
520: where bill_sequence_id = p_bill_sequence_id
521: order by component_item_id;
522: BEGIN
523:

Line 533: DELETE FROM Bom_Explosion_Temp

529: l_quantity := l_quantity + c_components.component_quantity;
530: -- dbms_output.put_line('Found ' || l_component_item_id);
531:
532: -- And then delete the component
533: DELETE FROM Bom_Explosion_Temp
534: WHERE rowid = c_components.rowid; /* changed by Sushant on 19-AUG-2002 */
535: /*
536: WHERE component_sequence_id = c_components.component_sequence_id
537: AND bill_sequence_id = p_bill_sequence_id;

Line 549: UPDATE BOM_EXPLOSION_TEMP

545: l_operation_seq_num <> c_components.operation_seq_num
546: THEN
547:
548: -- Update the Component and then reset the local variables
549: UPDATE BOM_EXPLOSION_TEMP
550: SET component_quantity = l_quantity
551: WHERE rowid = l_rowid; /* Changed by Sushant on 19-Aug-2002 */
552: /*
553: WHERE component_sequence_id = l_component_seq_id;

Line 587: UPDATE BOM_EXPLOSION_TEMP

583: END LOOP; /* Changed by Sushant on 20-Aug-2002 */
584:
585: /* Update the last component which will be left out in the loop */
586: /* Added by Sushant on 19-Aug-2002 */
587: UPDATE BOM_EXPLOSION_TEMP
588: SET component_quantity = l_quantity
589: WHERE rowid = l_rowid;
590:
591:

Line 651: UPDATE bom_explosion_temp

647: );
648:
649: IF c_comps_of_options.operation_seq_num = 1 THEN /* Added by sushant on 19-Aug-2002 */
650: BEGIN
651: UPDATE bom_explosion_temp
652: SET operation_seq_num = l_operation_seq_num /* Changed by Sushant on 19-Aug-2002 */
653: WHERE component_sequence_id =
654: c_comps_of_options.component_sequence_id;
655:

Line 3018: Additional table used here is bom_explosion_temp and the join to cz_config_details_v

3014: AND nvl(bic.disable_date,SYSDATE+1) > SYSDATE;
3015:
3016: /* Mandatory Components for the all the options classes in which user has chosen
3017: atleast 1 option (this is used for operation sequence inheritance from the parent)
3018: Additional table used here is bom_explosion_temp and the join to cz_config_details_v
3019: has been made using the component_code
3020: */
3021:
3022: CURSOR c_cz_req_items_with_Inherit IS

Line 3076: , bom_explosion_temp bet

3072: FROM bom_inventory_components bic
3073: , bom_inventory_components mod_oc
3074: , bom_bill_of_materials bom
3075: , cz_config_details_v cz
3076: , bom_explosion_temp bet
3077: WHERE cz.config_hdr_id = x_cz_config_hdr_id
3078: AND cz.config_rev_nbr = x_cz_config_rev_num
3079: AND cz.component_code = bet.component_code
3080: AND mod_oc.component_sequence_id = cz.component_sequence_id

Line 3098: SELECT * from bom_explosion_temp WHERE component_code IS NOT NULL

3094: for the records that are from cz_config_details_v (i.e all the option classes for the
3095: configured item and all the choosen options) */
3096:
3097: CURSOR c_Comps_With_ComponentCode IS
3098: SELECT * from bom_explosion_temp WHERE component_code IS NOT NULL
3099: ORDER BY component_code;
3100:
3101: /* Option classes that are under the top model */
3102:

Line 3122: FROM bom_explosion_temp bet

3118: SELECT bet.bill_sequence_id
3119: , bet.component_item_id
3120: , bet.operation_seq_num
3121: , bet.component_sequence_id
3122: FROM bom_explosion_temp bet
3123: WHERE bill_sequence_id = x_bill_sequence_id
3124: ORDER BY bet.bill_sequence_id,
3125: bet.component_item_id,
3126: bet.operation_seq_num,

Line 3151: DELETE from bom_explosion_temp;

3147: X_Stmt_Num := 10;
3148:
3149: /* Flush the temp table before starting the process */
3150:
3151: DELETE from bom_explosion_temp;
3152:
3153: /* Insert Model */
3154:
3155: INSERT INTO BOM_INVENTORY_COMPONENTS

Line 3259: INSERT INTO BOM_EXPLOSION_TEMP

3255: AND be.plan_level = 0;
3256:
3257: /* Insert the Mandatory Components of the Model */
3258:
3259: INSERT INTO BOM_EXPLOSION_TEMP
3260: ( top_bill_sequence_id,
3261: organization_id,
3262: plan_level,
3263: sort_order,

Line 3369: INSERT INTO BOM_EXPLOSION_TEMP

3365:
3366: /* Insert the Option Classes from which user has chosen atleast one option item along with
3367: the component code*/
3368:
3369: INSERT INTO BOM_EXPLOSION_TEMP
3370: ( top_bill_sequence_id,
3371: organization_id,
3372: plan_level,
3373: sort_order,

Line 3489: INSERT INTO bom_explosion_temp(

3485: IF l_op_seq_profile <> 1 THEN
3486:
3487: FOR cz_mandatory_items IN c_cz_required_items
3488: LOOP
3489: INSERT INTO bom_explosion_temp(
3490: top_bill_sequence_id,
3491: organization_id,
3492: plan_level,
3493: sort_order,

Line 3597: INSERT INTO bom_explosion_temp(

3593: /* Insert all the selected Options along with the component code */
3594:
3595: FOR cz_options IN cz_options_chosen
3596: LOOP
3597: INSERT INTO bom_explosion_temp(
3598: top_bill_sequence_id,
3599: organization_id,
3600: plan_level,
3601: sort_order,

Line 3732: UPDATE bom_explosion_temp btemp

3728: IF r1.operation_seq_num = 1 AND Instr(r1.component_code,'-',1,2) <> 0
3729: /* If operation seq number is 1 and the component is not the first level comp. under the top model */
3730: THEN
3731: /* Get the op.seq number from it's immediate parent */
3732: UPDATE bom_explosion_temp btemp
3733: SET btemp.operation_seq_num = (SELECT operation_seq_num FROM
3734: bom_explosion_temp WHERE component_code =
3735: substr(btemp.component_code,1,to_number(instr(btemp.component_code,'-',-1,1))-1))
3736: WHERE component_code = r1.component_code;

Line 3734: bom_explosion_temp WHERE component_code =

3730: THEN
3731: /* Get the op.seq number from it's immediate parent */
3732: UPDATE bom_explosion_temp btemp
3733: SET btemp.operation_seq_num = (SELECT operation_seq_num FROM
3734: bom_explosion_temp WHERE component_code =
3735: substr(btemp.component_code,1,to_number(instr(btemp.component_code,'-',-1,1))-1))
3736: WHERE component_code = r1.component_code;
3737: END IF;
3738:

Line 3749: INSERT INTO bom_explosion_temp(

3745: IF l_op_seq_profile = 1 THEN
3746:
3747: FOR cz_mandatory_items IN c_cz_req_items_with_Inherit
3748: LOOP
3749: INSERT INTO bom_explosion_temp(
3750: top_bill_sequence_id,
3751: organization_id,
3752: plan_level,
3753: sort_order,

Line 3885: DELETE from bom_explosion_temp;

3881: ( p_bill_sequence_id => x_bill_sequence_id );
3882:
3883: /* Flush the temp table after the process */
3884:
3885: DELETE from bom_explosion_temp;
3886:
3887: IF (X_Return_Val <> 0 ) THEN
3888: return;
3889: END IF;

Line 3893: DELETE from bom_explosion_temp;

3889: END IF;
3890: -- Commit;
3891: EXCEPTION
3892: WHEN OTHERS THEN
3893: DELETE from bom_explosion_temp;
3894: x_message := 'BOM_CONFIG_EXPLOSIONS_PKG.Insert_Mandatory_Components('
3895: || to_char(X_Stmt_Num) || '):';
3896: FND_MESSAGE.Set_Name('BOM','CZ_PLSQL_ERROR');
3897: FND_MESSAGE.Set_Token('PACKAGE',x_message);