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 2461: FROM WSM_COPY_REQUIREMENT_OPS

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

Line 2463: FROM WSM_COPY_REQUIREMENT_OPS WCRO

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

Line 2472: FROM WSM_COPY_REQUIREMENT_OPS WCRO

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

Line 2565: FROM WSM_COPY_REQUIREMENT_OPS WCRO,

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

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

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

Line 3153: FROM WSM_COPY_REQUIREMENT_OPS WCRO,

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