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.WSMPOPRN dependencies on WSM_COPY_REQUIREMENT_OPS

Line 2462: FROM WSM_COPY_REQUIREMENT_OPS

2458: --commenting out following sql after code review of bug 3587239
2459: /*********
2460: SELECT 1
2461: INTO l_phantom_exists
2462: FROM WSM_COPY_REQUIREMENT_OPS
2463: WHERE EXISTS (SELECT null
2464: FROM WSM_COPY_REQUIREMENT_OPS WCRO
2465: WHERE WCRO.WIP_ENTITY_ID = p_wip_entity_id
2466: AND WCRO.OPERATION_SEQ_NUM = p_to_rtg_op_seq_num

Line 2464: FROM WSM_COPY_REQUIREMENT_OPS WCRO

2460: SELECT 1
2461: INTO l_phantom_exists
2462: FROM WSM_COPY_REQUIREMENT_OPS
2463: WHERE EXISTS (SELECT null
2464: FROM WSM_COPY_REQUIREMENT_OPS WCRO
2465: WHERE WCRO.WIP_ENTITY_ID = p_wip_entity_id
2466: AND WCRO.OPERATION_SEQ_NUM = p_to_rtg_op_seq_num
2467: AND WCRO.recommended='Y');
2468: *********/

Line 2473: FROM WSM_COPY_REQUIREMENT_OPS WCRO

2469: --move enh merging may be needed because of phantoms and component substitution
2470: --adding following sql after code review of bug 3587239
2471: SELECT 1
2472: INTO l_phantom_exists
2473: FROM WSM_COPY_REQUIREMENT_OPS WCRO
2474: WHERE WCRO.WIP_ENTITY_ID = p_wip_entity_id
2475: AND WCRO.OPERATION_SEQ_NUM = p_to_rtg_op_seq_num
2476: AND WCRO.recommended='Y'
2477: AND WCRO.source_phantom_id <> -1;

Line 2566: FROM WSM_COPY_REQUIREMENT_OPS WCRO,

2562: MSI.segment18,
2563: MSI.segment19,
2564: MSI.segment20,
2565: WCRO.department_id
2566: FROM WSM_COPY_REQUIREMENT_OPS WCRO,
2567: WSM_COPY_REQUIREMENT_OPS WCRO1,--Added for bug 5236684
2568: MTL_SYSTEM_ITEMS MSI
2569: WHERE WCRO.OPERATION_SEQ_NUM = p_to_rtg_op_seq_num
2570: AND WCRO.WIP_ENTITY_ID= p_wip_entity_id

Line 2567: WSM_COPY_REQUIREMENT_OPS WCRO1,--Added for bug 5236684

2563: MSI.segment19,
2564: MSI.segment20,
2565: WCRO.department_id
2566: FROM WSM_COPY_REQUIREMENT_OPS WCRO,
2567: WSM_COPY_REQUIREMENT_OPS WCRO1,--Added for bug 5236684
2568: MTL_SYSTEM_ITEMS MSI
2569: WHERE WCRO.OPERATION_SEQ_NUM = p_to_rtg_op_seq_num
2570: AND WCRO.WIP_ENTITY_ID= p_wip_entity_id
2571: AND MSI.inventory_item_id = WCRO.component_item_id

Line 3154: FROM WSM_COPY_REQUIREMENT_OPS WCRO,

3150: --bug 3587239 Round the released quantity to 6 places
3151: ROUND(decode(wcro.basis_type, 2, 1, p_start_quantity)
3152: *(WCRO.quantity_per_assembly/wcro.component_yield_factor), WSMPCNST.NUMBER_OF_DECIMALS), --LBM enh
3153: WCRO.component_yield_factor --component shrinkage
3154: FROM WSM_COPY_REQUIREMENT_OPS WCRO,
3155: MTL_SYSTEM_ITEMS MSI
3156: WHERE WCRO.OPERATION_SEQ_NUM = p_to_rtg_op_seq_num
3157: AND WCRO.WIP_ENTITY_ID= p_wip_entity_id
3158: AND MSI.inventory_item_id = WCRO.component_item_id