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.CSTPPWAS dependencies on WIP_PAC_PERIOD_BALANCES

Line 125: FROM WIP_PAC_PERIOD_BALANCES wppb

121:
122: /* Check if any assembly units were relieved before this period */
123: SELECT COUNT(wppb.PAC_PERIOD_ID), Max(Nvl(relieved_assembly_units,0))
124: INTO l_job, l_prior_completed_units
125: FROM WIP_PAC_PERIOD_BALANCES wppb
126: WHERE wppb.WIP_ENTITY_ID = p_entity_id
127: AND wppb.PAC_PERIOD_ID = p_prior_period_id
128: AND NVL(wppb.line_id,-99) = decode(wppb.wip_entity_type, 4, -99, NVL(p_line_id,-99));
129:

Line 522: FROM wip_pac_period_balances wppb

518: p_login_id p_login,
519: p_request_id p_request,
520: p_prog_app_id p_prog_app,
521: p_prog_id p_prog
522: FROM wip_pac_period_balances wppb
523: WHERE wppb.pac_period_id = p_prior_period_id
524: AND wppb.cost_group_id = p_cost_group_id
525: AND wppb.wip_entity_id = p_entity_id
526: AND NVL(wppb.line_id,-99) = decode(wppb.wip_entity_type, 4, -99, NVL(p_line_id,-99));

Line 950: FROM wip_pac_period_balances wppb

946: p_login_id p_login,
947: p_request_id p_request,
948: p_prog_app_id p_prog_app,
949: p_prog_id p_prog
950: FROM wip_pac_period_balances wppb
951: WHERE wppb.pac_period_id = p_pac_period_id
952: AND wppb.cost_group_id = p_cost_group_id
953: AND wppb.wip_entity_id = p_entity_id
954: AND NVL(wppb.line_id,-99) = decode(wppb.wip_entity_type, 4, -99, NVL(p_line_id,-99));

Line 1347: FROM wip_pac_period_balances wppb

1343: p_login_id p_login,
1344: p_request_id p_request,
1345: p_prog_app_id p_prog_app,
1346: p_prog_id p_prog
1347: FROM wip_pac_period_balances wppb
1348: WHERE wppb.pac_period_id = p_pac_period_id
1349: AND wppb.cost_group_id = p_cost_group_id
1350: AND wppb.wip_entity_id = p_entity_id
1351: AND NVL(wppb.line_id,-99) = decode(wppb.wip_entity_type, 4, -99, NVL(p_line_id,-99));

Line 1404: | UPDATE table WIP_PAC_PERIOD_BALANCES (wppb) |

1400: | END of Third cursor |
1401: | END IF; |
1402: | END of Second Cursor |
1403: | End of First Cursor |
1404: | UPDATE table WIP_PAC_PERIOD_BALANCES (wppb) |
1405: | Check the job balance in this period for each cost element. |
1406: | If the value is negative then put these values in VAR columns |
1407: | END; |
1408: *----------------------------------------------------------------------------*/

Line 1439: FROM WIP_PAC_PERIOD_BALANCES wppb

1435: l_repetitive_schedule_id NUMBER;
1436:
1437: CURSOR c_wip_opseq IS
1438: SELECT wppb.operation_seq_num operation_seq_num
1439: FROM WIP_PAC_PERIOD_BALANCES wppb
1440: WHERE wppb.pac_period_id = p_pac_period_id
1441: AND wppb.cost_group_id = p_cost_group_id
1442: AND wppb.wip_entity_id = p_entity_id
1443: AND NVL(wppb.line_id, -99) = nvl(p_line_id,-99)

Line 1847: FROM wip_pac_period_balances wppb

1843:
1844: /* Check if any assembly units were relieved before this period */
1845: SELECT Max(Nvl(relieved_assembly_units,0))
1846: INTO l_prior_completed_units
1847: FROM wip_pac_period_balances wppb
1848: WHERE wppb.wip_entity_id = p_entity_id
1849: AND wppb.pac_period_id = p_pac_period_id
1850: AND wppb.cost_type_id = p_cost_type_id
1851: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99)

Line 2270: -- Update the wip_pac_period_balances with relieved values

2266:
2267: END LOOP; -- End of Component Loop
2268:
2269: -----------------------------------------------------------------------------------
2270: -- Update the wip_pac_period_balances with relieved values
2271: -----------------------------------------------------------------------------------
2272: -- OUT columns will not be updated if p_net_qty = 0 and p_final_completion_flag <>1
2273: -- In this case only TEMP columns are updated
2274: ------------------------------------------------------------------------------------

Line 2276: UPDATE wip_pac_period_balances wppb

2272: -- OUT columns will not be updated if p_net_qty = 0 and p_final_completion_flag <>1
2273: -- In this case only TEMP columns are updated
2274: ------------------------------------------------------------------------------------
2275: l_stmt_num := 270;
2276: UPDATE wip_pac_period_balances wppb
2277: SET wppb.pl_material_out = wppb.pl_material_out + decode(p_net_qty,0,
2278: decode(p_final_completion_flag,
2279: 0,0,
2280: NULL,0,

Line 2384: UPDATE WIP_PAC_PERIOD_BALANCES wppb

2380: AND nvl(cprocd.line_id, -99) = nvl(p_line_id,-99)
2381: AND cprocd.cost_element_id = 1; -- Material Cost Element
2382:
2383: l_stmt_num := 290;
2384: UPDATE WIP_PAC_PERIOD_BALANCES wppb
2385: -- New column to store the variance in case if total job balance is negative
2386: -- This column is not storing accumlated value
2387: SET wppb.pl_material_temp_var = wppb.pl_material_temp,
2388: -- This column is storing accumlated values of variance

Line 2436: UPDATE wip_pac_period_balances wppb

2432: AND nvl(cprocd.line_id, -99) = nvl(p_line_id,-99)
2433: AND cprocd.cost_element_id = 2; -- Material Overhead Cost Element
2434:
2435: l_stmt_num := 310;
2436: UPDATE wip_pac_period_balances wppb
2437: -- New column to store the variance in case total job balance is negative
2438: SET wppb.pl_material_overhead_temp_var = wppb.pl_material_overhead_temp,
2439: -- This column is storing accumlated values of variance
2440: wppb.pl_material_overhead_var = nvl(wppb.pl_material_overhead_var,0) + nvl(wppb.pl_material_overhead_temp,0),

Line 2486: UPDATE wip_pac_period_balances wppb

2482: AND nvl(cprocd.line_id, -99) = nvl(p_line_id,-99)
2483: AND cprocd.cost_element_id = 3; -- Resource Cost Element
2484:
2485: l_stmt_num := 330;
2486: UPDATE wip_pac_period_balances wppb
2487: -- New column to store the variance in case if total job balance is negative
2488: SET wppb.pl_resource_temp_var = wppb.pl_resource_temp,
2489: -- This column is storing accumlated values of variance
2490: wppb.pl_resource_var = nvl(wppb.pl_resource_var,0) + nvl(wppb.pl_resource_temp,0),

Line 2536: UPDATE wip_pac_period_balances wppb

2532: AND nvl(cprocd.line_id, -99) = nvl(p_line_id,-99)
2533: AND cprocd.cost_element_id = 4; -- Outside Processing Cost Element
2534:
2535: l_stmt_num := 350;
2536: UPDATE wip_pac_period_balances wppb
2537: -- New column to store the varaince in case total job balance is negative
2538: SET wppb.pl_outside_processing_temp_var = wppb.pl_outside_processing_temp,
2539: -- This column is storing accumlated values of variance
2540: wppb.pl_outside_processing_var = nvl(wppb.pl_outside_processing_var,0) + nvl(wppb.pl_outside_processing_temp,0),

Line 2586: UPDATE wip_pac_period_balances wppb

2582: AND nvl(cprocd.line_id, -99) = nvl(p_line_id,-99)
2583: AND cprocd.cost_element_id = 5; -- Overhead Processing Cost Element
2584:
2585: l_stmt_num := 370;
2586: UPDATE wip_pac_period_balances wppb
2587: -- New column to store the varaince in case total job balance is negative
2588: SET wppb.pl_overhead_temp_var = wppb.pl_overhead_temp,
2589: -- This column is storing accumlated values of variance
2590: wppb.pl_overhead_var = nvl(wppb.pl_overhead_var,0) + nvl(wppb.pl_overhead_temp,0),

Line 2817: UPDATE wip_pac_period_balances wppb

2813: ----------------------------------------------------------------------
2814:
2815: l_stmt_num := 0;
2816:
2817: UPDATE wip_pac_period_balances wppb
2818: SET tl_resource_temp = 0,
2819: tl_overhead_temp = 0,
2820: tl_outside_processing_temp = 0,
2821: pl_material_temp = 0,

Line 2850: UPDATE wip_pac_period_balances wppb

2846: IF (p_entity_type = 4) THEN
2847:
2848: l_stmt_num := 10;
2849:
2850: UPDATE wip_pac_period_balances wppb
2851: SET (tl_resource_out,
2852: tl_resource_temp,
2853: tl_outside_processing_out,
2854: tl_outside_processing_temp,

Line 2907: FROM wip_pac_period_balances wppb2,

2903: (NVL(wppb.pl_overhead_in,0)-NVL(wppb.pl_overhead_out,0)
2904: - NVL(wppb.pl_overhead_var,0)),
2905: (NVL(wppb.pl_overhead_in,0)-NVL(wppb.pl_overhead_out,0)
2906: - NVL(wppb.pl_overhead_var,0))
2907: FROM wip_pac_period_balances wppb2,
2908: wip_flow_schedules wfs
2909: WHERE wppb2.pac_period_id = p_pac_period_id
2910: AND wppb2.cost_group_id = p_cost_group_id
2911: AND wppb2.wip_entity_id = p_entity_id

Line 2965: FROM wip_pac_period_balances wppb

2961: INTO
2962: l_net_tl_resource_value,
2963: l_net_tl_overhead_value,
2964: l_net_tl_osp_value
2965: FROM wip_pac_period_balances wppb
2966: WHERE wppb.pac_period_id = p_pac_period_id
2967: AND wppb.cost_group_id = p_cost_group_id
2968: AND wppb.wip_entity_id = p_entity_id
2969: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)

Line 2976: UPDATE wip_pac_period_balances wppb

2972:
2973: /* Final completion exists */
2974: IF p_final_completion_flag = 1 THEN
2975:
2976: UPDATE wip_pac_period_balances wppb
2977: SET (tl_resource_out,
2978: tl_resource_temp,
2979: tl_outside_processing_out,
2980: tl_outside_processing_temp,

Line 3056: FROM wip_pac_period_balances wppb2

3052: (NVL(wppb.tl_overhead_in,0)-NVL(wppb.tl_overhead_out,0)
3053: - NVL(wppb.tl_overhead_var,0)),
3054: 0
3055: )
3056: FROM wip_pac_period_balances wppb2
3057: WHERE wppb2.pac_period_id =p_pac_period_id
3058: AND wppb2.cost_group_id = p_cost_group_id
3059: AND wppb2.wip_entity_id = p_entity_id
3060: AND NVL(wppb2.line_id,-99) = NVL(p_line_id,-99)

Line 3069: UPDATE wip_pac_period_balances wppb

3065: AND wppb.wip_entity_id = p_entity_id
3066: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)
3067: AND wppb.operation_seq_num <= wppb.operation_seq_num;
3068: ELSE /* No Final completion exists */
3069: UPDATE wip_pac_period_balances wppb
3070: SET (tl_resource_out,
3071: tl_resource_temp,
3072: tl_outside_processing_out,
3073: tl_outside_processing_temp,

Line 3193: FROM wip_pac_period_balances wppb2

3189: NVL(wppb2.relieved_assembly_units,0) - nvl(wppb2.unrelieved_scrap_quantity,0))
3190: ),
3191: 0
3192: )
3193: FROM wip_pac_period_balances wppb2
3194: WHERE wppb2.pac_period_id = p_pac_period_id
3195: AND wppb2.cost_group_id = p_cost_group_id
3196: AND wppb2.wip_entity_id = p_entity_id
3197: AND NVL(wppb2.line_id,-99) = NVL(p_line_id,-99)

Line 3218: FROM wip_pac_period_balances wppb

3214: INTO
3215: l_net_tl_resource_value,
3216: l_net_tl_overhead_value,
3217: l_net_tl_osp_value
3218: FROM wip_pac_period_balances wppb
3219: WHERE wppb.pac_period_id = p_prior_period_id
3220: AND wppb.cost_group_id = p_cost_group_id
3221: AND wppb.wip_entity_id = p_entity_id
3222: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)

Line 3226: UPDATE wip_pac_period_balances wppb

3222: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)
3223: AND wppb.operation_seq_num <=
3224: decode(p_scrap,1,p_op_seq,wppb.operation_seq_num);
3225:
3226: UPDATE wip_pac_period_balances wppb
3227: SET (tl_resource_out,
3228: tl_resource_temp,
3229: tl_outside_processing_out,
3230: tl_outside_processing_temp,

Line 3291: FROM wip_pac_period_balances wppb2

3287: NVL(wppb2.tl_overhead_out,0) *
3288: p_net_qty/decode(NVL(wppb2.relieved_assembly_units,0),
3289: 0,1,wppb2.relieved_assembly_units),
3290: 0)
3291: FROM wip_pac_period_balances wppb2
3292: WHERE wppb2.pac_period_id = p_prior_period_id
3293: AND wppb2.cost_group_id = p_cost_group_id
3294: AND wppb2.wip_entity_id = p_entity_id
3295: AND NVL(wppb2.line_id,-99) = NVL(p_line_id,-99)

Line 3316: FROM wip_pac_period_balances wppb

3312: INTO
3313: l_net_tl_resource_value,
3314: l_net_tl_overhead_value,
3315: l_net_tl_osp_value
3316: FROM wip_pac_period_balances wppb
3317: WHERE wppb.pac_period_id = p_prior_period_id
3318: AND wppb.cost_group_id = p_cost_group_id
3319: AND wppb.wip_entity_id = p_entity_id
3320: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)

Line 3338: FROM wip_pac_period_balances wppb

3334:
3335: IF l_assembly_return_cnt <> 0 THEN
3336: SELECT Max(Nvl(relieved_assembly_units,0))
3337: INTO l_prior_completed_units
3338: FROM wip_pac_period_balances wppb
3339: WHERE wppb.wip_entity_id = p_entity_id
3340: AND wppb.pac_period_id = p_pac_period_id
3341: AND wppb.cost_type_id = p_cost_type_id
3342: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99)

Line 3350: UPDATE wip_pac_period_balances wppb

3346: -- If this period is not the first period
3347: IF p_prior_period_id <> -1 AND l_prior_completed_units <> 0 then
3348:
3349: l_stmt_num := 32;
3350: UPDATE wip_pac_period_balances wppb
3351: SET (tl_resource_out,
3352: tl_resource_temp,
3353: tl_outside_processing_out,
3354: tl_outside_processing_temp,

Line 3415: FROM wip_pac_period_balances wppb2

3411: NVL(wppb2.tl_overhead_out,0) *
3412: l_assembly_return_cnt/decode(NVL(wppb2.relieved_assembly_units,0),
3413: 0,1,wppb2.relieved_assembly_units),
3414: 0)
3415: FROM wip_pac_period_balances wppb2
3416: WHERE wppb2.pac_period_id = p_prior_period_id
3417: AND wppb2.cost_group_id = p_cost_group_id
3418: AND wppb2.wip_entity_id = p_entity_id
3419: AND NVL(wppb2.line_id,-99) = NVL(p_line_id,-99)

Line 3432: UPDATE wip_pac_period_balances wppb

3428: decode(p_scrap,1,p_op_seq,wppb.operation_seq_num);
3429:
3430: END IF; /* p_prior_period_id <> -1 AND l_prior_completed_unit <> 0 */
3431: l_stmt_num := 34;
3432: UPDATE wip_pac_period_balances wppb
3433: SET (tl_resource_out,
3434: tl_resource_temp,
3435: tl_outside_processing_out,
3436: tl_outside_processing_temp,

Line 3515: FROM wip_pac_period_balances wppb2

3511: (NVL(wppb2.tl_overhead_in,0)-NVL(wppb2.tl_overhead_out,0)
3512: - NVL(wppb2.tl_overhead_var,0)),
3513: 0
3514: )
3515: FROM wip_pac_period_balances wppb2
3516: WHERE wppb2.pac_period_id = p_pac_period_id
3517: AND wppb2.cost_group_id = p_cost_group_id
3518: AND wppb2.wip_entity_id = p_entity_id
3519: AND NVL(wppb2.line_id,-99) = NVL(p_line_id,-99)

Line 3532: UPDATE wip_pac_period_balances wppb

3528: decode(p_scrap,1,p_op_seq,wppb.operation_seq_num);
3529:
3530: ELSE /* No Final Completion */
3531: l_stmt_num := 36;
3532: UPDATE wip_pac_period_balances wppb
3533: SET (
3534: tl_resource_temp,
3535: tl_outside_processing_temp,
3536: tl_overhead_temp

Line 3569: FROM wip_pac_period_balances

3565: NVL(tl_overhead_out,0) /
3566: DECODE(NVL(relieved_assembly_units,0),0,1,relieved_assembly_units),
3567: 0
3568: )
3569: FROM wip_pac_period_balances
3570: WHERE pac_period_id = p_prior_period_id
3571: AND cost_group_id = p_cost_group_id
3572: AND wip_entity_id = p_entity_id
3573: AND NVL(line_id,-99) = NVL(p_line_id,-99)

Line 3621: FROM wip_pac_period_balances wppb

3617: l_net_pl_moh_value,
3618: l_net_pl_resource_value,
3619: l_net_pl_osp_value,
3620: l_net_pl_overhead_value
3621: FROM wip_pac_period_balances wppb
3622: WHERE wppb.pac_period_id = p_pac_period_id
3623: AND wppb.cost_group_id = p_cost_group_id
3624: AND wppb.wip_entity_id = p_entity_id
3625: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)

Line 3631: UPDATE wip_pac_period_balances wppb

3627: decode(p_scrap,1,p_op_seq,wppb.operation_seq_num);
3628:
3629: IF p_final_completion_flag = 1 THEN /* Final completion exists */
3630: l_stmt_num := 40;
3631: UPDATE wip_pac_period_balances wppb
3632: SET (tl_resource_out,
3633: tl_resource_temp,
3634: tl_outside_processing_out,
3635: tl_outside_processing_temp,

Line 3840: FROM wip_pac_period_balances wppb2

3836: (NVL(wppb.pl_overhead_in,0)-NVL(wppb.pl_overhead_out,0)-nvl(wppb.pl_overhead_in_apull,0)
3837: - NVL(wppb.pl_overhead_var,0)) + nvl(wppb.pl_overhead_in_apull,0),
3838: 0
3839: )
3840: FROM wip_pac_period_balances wppb2
3841: WHERE wppb2.pac_period_id = p_pac_period_id
3842: AND wppb2.cost_group_id = p_cost_group_id
3843: AND wppb2.wip_entity_id = p_entity_id
3844: AND NVL(wppb2.line_id,-99) = NVL(p_line_id,-99)

Line 3854: UPDATE wip_pac_period_balances wppb

3850: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)
3851: AND wppb.operation_seq_num <= wppb.operation_seq_num;
3852: ELSE /* No Final completion exists */
3853: l_stmt_num := 42;
3854: UPDATE wip_pac_period_balances wppb
3855: SET (tl_resource_out,
3856: tl_resource_temp,
3857: tl_outside_processing_out,
3858: tl_outside_processing_temp,

Line 4268: FROM wip_pac_period_balances wppb2

4264: 0,1,
4265: -1,1,
4266: p_net_qty/(nvl(wppb2.relieved_scrap_qty,0) + nvl(l_net_completion,0))) * nvl(wppb2.pl_overhead_in_apull,0),
4267: 0)
4268: FROM wip_pac_period_balances wppb2
4269: WHERE wppb2.pac_period_id = p_pac_period_id
4270: AND wppb2.cost_group_id = p_cost_group_id
4271: AND wppb2.wip_entity_id = p_entity_id
4272: AND NVL(wppb2.line_id,-99) = NVL(p_line_id,-99)

Line 4303: FROM wip_pac_period_balances wppb

4299: l_net_pl_moh_value,
4300: l_net_pl_resource_value,
4301: l_net_pl_osp_value,
4302: l_net_pl_overhead_value
4303: FROM wip_pac_period_balances wppb
4304: WHERE wppb.pac_period_id = p_prior_period_id
4305: AND wppb.cost_group_id = p_cost_group_id
4306: AND wppb.wip_entity_id = p_entity_id
4307: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)

Line 4311: UPDATE wip_pac_period_balances wppb

4307: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)
4308: AND wppb.operation_seq_num <=
4309: decode(p_scrap,1,p_op_seq,wppb.operation_seq_num);
4310:
4311: UPDATE wip_pac_period_balances wppb
4312: SET (tl_resource_out,
4313: tl_resource_temp,
4314: tl_outside_processing_out,
4315: tl_outside_processing_temp,

Line 4482: FROM wip_pac_period_balances wppb2

4478: NVL(wppb2.pl_overhead_out,0) *
4479: p_net_qty/decode(NVL(wppb2.relieved_assembly_units,0),
4480: 0,1,wppb2.relieved_assembly_units),
4481: 0)
4482: FROM wip_pac_period_balances wppb2
4483: WHERE wppb2.pac_period_id = p_prior_period_id
4484: AND wppb2.cost_group_id = p_cost_group_id
4485: AND wppb2.wip_entity_id = p_entity_id
4486: AND NVL(wppb2.line_id,-99) = NVL(p_line_id,-99)

Line 4519: FROM wip_pac_period_balances wppb

4515: l_net_pl_resource_value,
4516: l_net_pl_osp_value,
4517: l_net_pl_overhead_value,
4518: l_prior_completed_units
4519: FROM wip_pac_period_balances wppb
4520: WHERE wppb.pac_period_id = p_prior_period_id
4521: AND wppb.cost_group_id = p_cost_group_id
4522: AND wppb.wip_entity_id = p_entity_id
4523: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)

Line 4542: UPDATE wip_pac_period_balances wppb

4538:
4539: IF (p_prior_period_id <> -1 AND l_prior_completed_units <> 0) then
4540:
4541: l_stmt_num := 50;
4542: UPDATE wip_pac_period_balances wppb
4543: SET ( tl_resource_out,
4544: tl_outside_processing_out,
4545: tl_overhead_out,
4546: pl_material_out,

Line 4633: FROM wip_pac_period_balances wppb2

4629: NVL(wppb2.pl_overhead_out,0) *
4630: l_assembly_return_cnt/decode(NVL(wppb2.relieved_assembly_units,0),
4631: 0,1,wppb2.relieved_assembly_units),
4632: 0)
4633: FROM wip_pac_period_balances wppb2
4634: WHERE wppb2.pac_period_id = p_prior_period_id
4635: AND wppb2.cost_group_id = p_cost_group_id
4636: AND wppb2.wip_entity_id = p_entity_id
4637: AND NVL(wppb2.line_id,-99) = NVL(p_line_id,-99)

Line 4649: UPDATE wip_pac_period_balances wppb

4645: decode(p_scrap,1,p_op_seq,wppb.operation_seq_num);
4646:
4647: END IF; /* end of p_prior_period_id <> -1 AND l_prior_completed_units <> 0 */
4648: l_stmt_num := 52;
4649: UPDATE wip_pac_period_balances wppb
4650: SET ( tl_resource_out,
4651: tl_resource_temp,
4652: tl_outside_processing_out,
4653: tl_outside_processing_temp,

Line 4874: FROM wip_pac_period_balances wppb2

4870: - NVL(wppb.pl_overhead_var,0))
4871: + nvl(wppb.pl_overhead_in_apull,0),
4872: 0
4873: )
4874: FROM wip_pac_period_balances wppb2
4875: WHERE wppb2.pac_period_id = p_pac_period_id
4876: AND wppb2.cost_group_id = p_cost_group_id
4877: AND wppb2.wip_entity_id = p_entity_id
4878: AND NVL(wppb2.line_id,-99) = NVL(p_line_id,-99)

Line 4890: UPDATE wip_pac_period_balances wppb

4886: AND wppb.operation_seq_num <=
4887: decode(p_scrap,1,p_op_seq,wppb.operation_seq_num);
4888: ELSE
4889: l_stmt_num := 54;
4890: UPDATE wip_pac_period_balances wppb
4891: SET (
4892: tl_resource_temp,
4893: tl_outside_processing_temp,
4894: tl_overhead_temp,

Line 4982: FROM wip_pac_period_balances

4978: NVL(pl_overhead_out,0) /
4979: DECODE(NVL(relieved_assembly_units,0),0,1,relieved_assembly_units),
4980: 0
4981: )
4982: FROM wip_pac_period_balances
4983: WHERE pac_period_id = p_prior_period_id
4984: AND cost_group_id = p_cost_group_id
4985: AND wip_entity_id = p_entity_id
4986: AND NVL(line_id,-99) = NVL(p_line_id,-99)

Line 5002: UPDATE wip_pac_period_balances wppb

4998: ------------------------------------------------------------------
4999: -- Update wppb.RELIEVED_ASSEMBLY_UNITS
5000: ------------------------------------------------------------------
5001: l_stmt_num := 56;
5002: UPDATE wip_pac_period_balances wppb
5003: SET wppb.relieved_assembly_units =
5004: NVL(wppb.relieved_assembly_units,0) + p_net_qty
5005: WHERE wppb.pac_period_id = p_pac_period_id
5006: AND wppb.cost_group_id = p_cost_group_id

Line 5604: UPDATE WIP_PAC_PERIOD_BALANCES

5600:
5601: fnd_file.put_line(fnd_file.log,' Scrap_Qty Update << ');
5602: l_stmt_num := 15;
5603:
5604: UPDATE WIP_PAC_PERIOD_BALANCES
5605: SET relieved_scrap_qty = nvl(relieved_scrap_qty,0) + c_ent_rec.net_scrap
5606: WHERE wip_entity_id = c_ent_rec.entity_id
5607: AND nvl(line_id,-99) = decode(wip_entity_type, 4, -99, nvl(c_ent_rec.line_id,-99))
5608: AND operation_seq_num <= c_ent_rec.op_seq