[Home] [Help]
806:
807: x_date_from := g_date_from ;
808: x_date_to := g_date_to ;
809:
810: -- Phase I: Calculate Standard Quantities
811: x_phase := 'I';
812: if g_debug = 1 then
813: fnd_file.put_line(fnd_file.log, 'Before Stage 2 Phase I');
814: end if ;
813: fnd_file.put_line(fnd_file.log, 'Before Stage 2 Phase I');
814: end if ;
815: ----dbms_output.put_line('Before Stage 2 Phase I');
816:
817: -- Calculate the Standard Quantities for the various departments
818: Calculate_Std_Quantity(
819: p_group_id => x_group_id,
820: p_organization_id => p_organization_id ,
821: p_date_from => x_date_from,
830: fnd_file.put_line(fnd_file.log, 'Before Stage 2 Phase II');
831: end if ;
832: ----dbms_output.put_line('Before Stage 2 Phase II');
833:
834: -- Calculate the standard units for the various resources in the
835: -- departments
836: Calculate_Std_Units(
837: p_group_id => x_group_id,
838: p_resource_id => p_resource_id,
1628: END Populate_Yield;
1629:
1630: /* Calculate_Std_Quantity
1631:
1632: Calculate the Standard Quantities used by the various departments
1633: in the organization within the date range that is specified.
1634: However if the date range is not specified then we consider the
1635: whole time horizon. If no department is specified then we get all
1636: the departments in the organization. However if the department is
1660: indicator_type,
1661: process_phase,
1662: transaction_date,
1663: applied_units_prd,
1664: standard_units,
1665: standard_quantity,
1666: last_update_date,
1667: last_updated_by,
1668: creation_date,
1661: process_phase,
1662: transaction_date,
1663: applied_units_prd,
1664: standard_units,
1665: standard_quantity,
1666: last_update_date,
1667: last_updated_by,
1668: creation_date,
1669: created_by,
1879: lot/Item based resources - fixed for Oabis 11.1 - required
1880: introducing a new column basis_type. The sequence of steps
1881: are :
1882:
1883: 1. Calculate the Standard_Quantities for each
1884: wip_entity_id, operation_seq_num, department,
1885: resource, transaction_date.
1886:
1887: 2. Delete the original rows + lot based resource
1932: group_id,
1933: organization_id,
1934: department_id,
1935: department_code,
1936: standard_quantity,
1937: resource_id,
1938: resource_code,
1939: wip_entity_id,
1940: operation_seq_num,
1941: resource_basis,
1942: indicator_type,
1943: process_phase,
1944: transaction_date,
1945: standard_units,
1946: applied_units_prd,
1947: last_update_date,
1948: last_updated_by,
1949: creation_date,
1960: decode(wit.indicator_type,
1961: WIP_EFFICIENCY, wit.department_code,
1962: WIP_PRODUCTIVITY,
1963: nvl(bd.department_code, wit.department_code)),
1964: wit.standard_quantity,
1965: wor.resource_id,
1966: br.resource_code,
1967: wit.wip_entity_id,
1968: wit.operation_seq_num,
1972: transaction_date, -- already trunc'ed
1973: inv_convert.inv_um_convert(0,
1974: NULL,
1975: decode(wor.basis_type,
1976: 1, (wit.standard_quantity*
1977: wor.usage_rate_or_amount),
1978: 2, (wit.standard_quantity)),
1979: wor.uom_code,
1980: g_uom_code,
1974: NULL,
1975: decode(wor.basis_type,
1976: 1, (wit.standard_quantity*
1977: wor.usage_rate_or_amount),
1978: 2, (wit.standard_quantity)),
1979: wor.uom_code,
1980: g_uom_code,
1981: NULL,
1982: NULL),
2151: department_id,
2152: department_code,
2153: resource_id,
2154: resource_code,
2155: standard_quantity,
2156: standard_units,
2157: applied_units_prd,
2158: transaction_date,
2159: indicator_type,
2152: department_code,
2153: resource_id,
2154: resource_code,
2155: standard_quantity,
2156: standard_units,
2157: applied_units_prd,
2158: transaction_date,
2159: indicator_type,
2160: process_phase,
2811: DEPARTMENT_ID,
2812: DEPARTMENT_CODE,
2813: RESOURCE_ID,
2814: RESOURCE_CODE,
2815: STANDARD_HOURS,
2816: APPLIED_HOURS_PRD,
2817: LAST_UPDATE_DATE,
2818: LAST_UPDATED_BY,
2819: CREATION_DATE,
2830: wit.department_id,
2831: wit.department_code,
2832: wit.resource_id,
2833: wit.resource_code,
2834: wit.standard_units,
2835: wit.applied_units_prd,
2836: wit.last_update_date,
2837: wit.last_updated_by,
2838: wit.creation_date,
4269: group_id,
4270: organization_id,
4271: department_id,
4272: department_code,
4273: standard_quantity,
4274: resource_id,
4275: resource_code,
4276: transaction_date,
4277: standard_units,
4273: standard_quantity,
4274: resource_id,
4275: resource_code,
4276: transaction_date,
4277: standard_units,
4278: indicator_type,
4279: process_phase,
4280: last_update_date,
4281: last_updated_by,
4286: group_id,
4287: organization_id,
4288: department_id,
4289: department_code,
4290: sum(standard_quantity),
4291: resource_id,
4292: resource_code,
4293: transaction_date, -- already trunc'ed
4294: sum(standard_units),
4290: sum(standard_quantity),
4291: resource_id,
4292: resource_code,
4293: transaction_date, -- already trunc'ed
4294: sum(standard_units),
4295: WIP_PRODUCTIVITY,
4296: WIP_PROD_PHASE_FOUR,
4297: last_update_date,
4298: last_updated_by,
4422: department_id,
4423: department_code,
4424: resource_id,
4425: resource_code,
4426: standard_units,
4427: available_units,
4428: transaction_date,
4429: indicator_type,
4430: process_phase,
5881: resource_id,
5882: resource_code,
5883: transaction_date,
5884: shift_num,
5885: standard_quantity,
5886: total_quantity,
5887: scrap_quantity,
5888: standard_units,
5889: applied_units_prd,
5884: shift_num,
5885: standard_quantity,
5886: total_quantity,
5887: scrap_quantity,
5888: standard_units,
5889: applied_units_prd,
5890: applied_units_utz,
5891: available_units,
5892: resource_cost,
5916: resource_id,
5917: resource_code,
5918: transaction_date,
5919: shift_num,
5920: standard_quantity,
5921: total_quantity,
5922: scrap_quantity,
5923: standard_units,
5924: applied_units_prd,
5919: shift_num,
5920: standard_quantity,
5921: total_quantity,
5922: scrap_quantity,
5923: standard_units,
5924: applied_units_prd,
5925: applied_units_utz,
5926: available_units,
5927: resource_cost,
5980: resource_id,
5981: resource_code,
5982: transaction_date,
5983: shift_num,
5984: standard_quantity,
5985: total_quantity,
5986: scrap_quantity,
5987: standard_units,
5988: applied_units_prd,
5983: shift_num,
5984: standard_quantity,
5985: total_quantity,
5986: scrap_quantity,
5987: standard_units,
5988: applied_units_prd,
5989: applied_units_utz,
5990: available_units,
5991: resource_cost,
6016: resource_id,
6017: resource_code,
6018: trunc(transaction_date),
6019: NULL,
6020: SUM(standard_quantity),
6021: sum(total_quantity),
6022: sum(scrap_quantity),
6023: SUM(standard_units),
6024: sum(applied_units_prd),
6019: NULL,
6020: SUM(standard_quantity),
6021: sum(total_quantity),
6022: sum(scrap_quantity),
6023: SUM(standard_units),
6024: sum(applied_units_prd),
6025: sum(applied_units_utz),
6026: sum(available_units),
6027: sum(resource_cost),
6095: department_id,
6096: department_code,
6097: resource_id,
6098: resource_code,
6099: standard_hours,
6100: applied_hours_prd,
6101: available_hours,
6102: applied_hours_utz,
6103: total_quantity,
6118: wit.department_id,
6119: wit.department_code,
6120: wit.resource_id,
6121: wit.resource_code,
6122: wit.standard_units,
6123: wit.applied_units_prd,
6124: wit2.available_units,
6125: wit2.applied_units_utz,
6126: wit3.total_quantity,
6312: resource_code,
6313: transaction_date,
6314: total_quantity,
6315: scrap_quantity,
6316: standard_hours,
6317: applied_hours_prd,
6318: applied_hours_utz,
6319: available_hours,
6320: existing_flag,
6361: resource_code,
6362: transaction_date,
6363: total_quantity,
6364: scrap_quantity,
6365: standard_hours,
6366: applied_hours_prd,
6367: applied_hours_utz,
6368: available_hours,
6369: existing_flag,
6668: resource_code,
6669: transaction_date,
6670: total_quantity,
6671: scrap_quantity,
6672: standard_hours,
6673: applied_hours_prd,
6674: applied_hours_utz,
6675: available_hours,
6676: existing_flag,
6717: resource_code,
6718: transaction_date,
6719: total_quantity,
6720: scrap_quantity,
6721: standard_hours,
6722: applied_hours_prd,
6723: applied_hours_utz,
6724: available_hours,
6725: existing_flag,