[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 --
5709: wcro.component_sequence_id,
5710: wcro.wip_supply_type,
5711: Nvl(WCRO.reco_date_required, WCRO.last_update_date),
5712: wcro.basis_type, --LBM enh
5713: ROUND(WCRO.quantity_per_assembly* decode(wcro.basis_type, 2, 1, wdj.start_quantity), WSMPCNST.NUMBER_OF_DECIMALS), --LBM enh
5714: 0,
5715: WCRO.bill_quantity_per_assembly, --R12:Comp Shrinkage Project:Changed from qpa to bqpa
5716: WCRO.component_yield_factor, --R12:Comp Shrinkage Project:Added
5717: WCRO.supply_subinventory,
5754: MSI.segment18,
5755: MSI.segment19,
5756: MSI.segment20,
5757: WCRO.department_id,
5758: ROUND(WDJ.start_quantity*WCRO.quantity_per_assembly, WSMPCNST.NUMBER_OF_DECIMALS)
5759: FROM WIP_DISCRETE_JOBS WDJ,
5760: WSM_COPY_REQUIREMENT_OPS WCRO,
5761: MTL_SYSTEM_ITEMS MSI
5762: WHERE WCRO.WIP_ENTITY_ID = p_wip_entity_id