DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on MTL_SYSTEM_ITEMS

Line 2567: MTL_SYSTEM_ITEMS MSI

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
2571: AND MSI.organization_id = WCRO.organization_id

Line 3154: MTL_SYSTEM_ITEMS MSI

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
3158: AND MSI.organization_id = WCRO.organization_id