[Home] [Help]
219: IS
220:
221: l_stmt_num NUMBER := 0;
222: DATETIME_FMT CONSTANT VARCHAR2(22) := 'YYYY/MM/DD HH24:MI:SS';
223: -- Note : Cannot use WSMPCNST.C_DATETIME_FMT since BOM requires date in the above format,
224: -- which is different than the one defined in WSMPCNST.
225:
226: SORT_WIDTH CONSTANT NUMBER := 4;/*to be replaced with the bom profile value*/
227:
220:
221: l_stmt_num NUMBER := 0;
222: DATETIME_FMT CONSTANT VARCHAR2(22) := 'YYYY/MM/DD HH24:MI:SS';
223: -- Note : Cannot use WSMPCNST.C_DATETIME_FMT since BOM requires date in the above format,
224: -- which is different than the one defined in WSMPCNST.
225:
226: SORT_WIDTH CONSTANT NUMBER := 4;/*to be replaced with the bom profile value*/
227:
228: -- Setup related variables --
5478: wcro.component_sequence_id,
5479: wcro.wip_supply_type,
5480: Nvl(WCRO.reco_date_required, WCRO.last_update_date),
5481: wcro.basis_type, --LBM enh
5482: ROUND(WCRO.quantity_per_assembly* decode(wcro.basis_type, 2, 1, wdj.start_quantity), WSMPCNST.NUMBER_OF_DECIMALS), --LBM enh
5483: 0,
5484: WCRO.bill_quantity_per_assembly, --R12:Comp Shrinkage Project:Changed from qpa to bqpa
5485: WCRO.component_yield_factor, --R12:Comp Shrinkage Project:Added
5486: WCRO.supply_subinventory,
5523: MSI.segment18,
5524: MSI.segment19,
5525: MSI.segment20,
5526: WCRO.department_id,
5527: ROUND(WDJ.start_quantity*WCRO.quantity_per_assembly, WSMPCNST.NUMBER_OF_DECIMALS)
5528: FROM WIP_DISCRETE_JOBS WDJ,
5529: WSM_COPY_REQUIREMENT_OPS WCRO,
5530: MTL_SYSTEM_ITEMS MSI
5531: WHERE WCRO.WIP_ENTITY_ID = p_wip_entity_id