DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on MTL_SYSTEM_ITEMS

Line 2568: MTL_SYSTEM_ITEMS MSI

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

Line 3155: MTL_SYSTEM_ITEMS MSI

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