[Home] [Help]
576: v_wljdi_cum_yield t_wljdi_cum_yield := t_wljdi_cum_yield();
577: v_wljdi_rev_cum_yield t_wljdi_rev_cum_yield := t_wljdi_rev_cum_yield();
578:
579: type t_res_recom is table of varchar2(5) index by binary_integer;
580: type t_res_code is table of bom_resources.resource_code%type index by binary_integer;
581:
582: /* end */
583: /* ST : Detailed scheduling : end */
584:
1804: begin
1805: l_stmt_num := 40.2;
1806: select unique(resource_id)
1807: into v_wljdi_resource_id_new(l_d)
1808: from bom_resources
1809: where resource_code = v_wljdi_resource_code_new(l_d)
1810: and organization_id = p_org_id
1811: and cost_code_type in (3,4);
1812: exception
1821: elsif v_wljdi_resource_code_new(l_d) IS NULL then
1822: begin /* unique why...? ..... */
1823: select unique(resource_code)
1824: into v_wljdi_resource_code_new(l_d)
1825: from bom_resources
1826: where resource_id = v_wljdi_resource_id_new(l_d)
1827: and organization_id = p_org_id
1828: and cost_code_type in (3,4);
1829:
2424: begin
2425: l_stmt_num := 70.2;
2426: select unique(resource_id)
2427: into l_resource_id
2428: from bom_resources
2429: where resource_code = v_wljdi_resource_code_new(l_d)
2430: and organization_id = p_org_id;
2431: exception
2432: when others then
3429: l_xst := 0;
3430:
3431: select br.batchable
3432: into l_xst
3433: from bom_resources br
3434: where resource_id = l_resource_id;
3435:
3436: if l_xst <> 1 then
3437: /* error out... */
3630: l_stmt_num := 140;
3631:
3632: select br.batchable
3633: into l_xst
3634: from bom_resources br
3635: where resource_id = l_resource_id;
3636:
3637: if l_xst <> 1 then
3638: /* error out... */
3854: l_res_autocharge_type,
3855: l_res_standard_rate_flag,
3856: l_res_batchable,
3857: l_res_code
3858: from bom_resources
3859: where resource_id=l_resource_id
3860: and organization_id=p_org_id
3861: and nvl(disable_date,sysdate+1) > sysdate;
3862: exception
13646: p_new_res_tbl(l_index).basis_type,
13647: l_uom_class,
13648: l_batchable,
13649: p_new_res_tbl(l_index).standard_rate_flag
13650: from bom_resources BR,
13651: mtl_units_of_measure_vl uom
13652: where br.resource_id = p_new_res_tbl(l_index).resource_id
13653: and autocharge_type = nvl(p_new_res_tbl(l_index).autocharge_type,autocharge_type)
13654: and nvl(p_new_res_tbl(l_index).uom_code,br.unit_of_measure) = br.unit_of_measure -- uom.uom_code
13774: begin
13775:
13776: select nvl(p_new_res_tbl(l_index).dept_id,wo.department_id)
13777: into p_new_res_tbl(l_index).dept_id
13778: from bom_resources br,bom_department_resources bdr, wip_operations wo
13779: where br.resource_id = p_new_res_tbl(l_index).resource_id
13780: and br.resource_code = p_new_res_tbl(l_index).resource_code
13781: and (br.disable_date > sysdate or br.disable_date is null)
13782: and br.organization_id = p_org_id
13841: begin
13842:
13843: select nvl(p_new_res_tbl(l_index).dept_id,wco.department_id)
13844: into p_new_res_tbl(l_index).dept_id
13845: from bom_resources br,bom_department_resources bdr, wsm_copy_operations wco
13846: where br.resource_id = p_new_res_tbl(l_index).resource_id
13847: and br.resource_code = p_new_res_tbl(l_index).resource_code
13848: and (br.disable_date > sysdate or br.disable_date is null)
13849: and br.organization_id = p_org_id
16434: bsor.attribute14,
16435: bsor.attribute15,
16436: null
16437: from wsm_copy_operations wco,
16438: bom_resources br,
16439: bom_std_op_resources bsor
16440: where bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16441: and br.resource_id = bsor.resource_id
16442: and nvl(br.disable_date, SYSDATE + 1) > SYSDATE
16565: bsor.attribute14,
16566: bsor.attribute15,
16567: null
16568: from wsm_copy_operations wco,
16569: bom_resources br,
16570: bom_std_sub_op_resources bsor,
16571: wsm_copy_op_resources wcor
16572: where bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16573: and br.resource_id = bsor.resource_id