[Home] [Help]
63: -- GET the SERIAL ENFORCE paramneter from Receiving Options
64: -- IF enforce is YES
65: -- then
66: -- For all Order lines matching with the ITEM call INV_RMA_SERIAL_PVT.POPULATE_TEMP_TABLE
67: -- to populate the temporary serial table MTL_RMA_SERIAL_TEMP
68: -- Modify the LOV to join with MTL_RMA_SERIAL_TEMP
69: -- Else
70: -- the Existing LOV
71: -- End if
64: -- IF enforce is YES
65: -- then
66: -- For all Order lines matching with the ITEM call INV_RMA_SERIAL_PVT.POPULATE_TEMP_TABLE
67: -- to populate the temporary serial table MTL_RMA_SERIAL_TEMP
68: -- Modify the LOV to join with MTL_RMA_SERIAL_TEMP
69: -- Else
70: -- the Existing LOV
71: -- End if
72:
127: AND msn.status_id = mms.status_id(+)
128: AND mms.language (+) = userenv('LANG')
129: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'
130: AND msn.serial_number LIKE (p_serial)
131: AND EXISTS ( select 'x' from mtl_rma_serial_temp msrt
132: where msrt.organization_id = p_organization_id
133: and msrt.inventory_item_id = p_item_id
134: and msrt.serial_number = msn.serial_number
135: and msrt.serial_number LIKE (p_serial)
3827: -- GET the SERIAL ENFORCE paramneter from Receiving Options
3828: -- IF enforce is YES
3829: -- then
3830: -- For all Order lines matching with the ITEM call INV_RMA_SERIAL_PVT.POPULATE_TEMP_TABLE
3831: -- to populate the temporary serial table MTL_RMA_SERIAL_TEMP
3832: -- Modify the LOV to join with MTL_RMA_SERIAL_TEMP
3833: -- Else
3834: -- the Existing LOV
3835: -- End if
3828: -- IF enforce is YES
3829: -- then
3830: -- For all Order lines matching with the ITEM call INV_RMA_SERIAL_PVT.POPULATE_TEMP_TABLE
3831: -- to populate the temporary serial table MTL_RMA_SERIAL_TEMP
3832: -- Modify the LOV to join with MTL_RMA_SERIAL_TEMP
3833: -- Else
3834: -- the Existing LOV
3835: -- End if
3836:
3876: End loop;
3877:
3878: SELECT count(line_id)
3879: INTO l_count_rows
3880: FROM mtl_rma_serial_temp msrt
3881: WHERE msrt.organization_id = p_organization_id
3882: AND msrt.inventory_item_id = p_item_id ;
3883:
3884:
3943: AND msn.status_id = mms.status_id(+)
3944: AND mms.language (+) = userenv('LANG')
3945: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'
3946: AND msn.serial_number LIKE (p_serial)
3947: AND EXISTS ( select 'x' from mtl_rma_serial_temp msrt
3948: where msrt.organization_id = p_organization_id
3949: and msrt.inventory_item_id = p_item_id
3950: and msrt.serial_number = msn.serial_number
3951: and msrt.serial_number LIKE (p_serial)
4091: -- GET the SERIAL ENFORCE paramneter from Receiving Options
4092: -- IF enforce is YES
4093: -- then
4094: -- For all Order lines matching with the ITEM call INV_RMA_SERIAL_PVT.POPULATE_TEMP_TABLE
4095: -- to populate the temporary serial table MTL_RMA_SERIAL_TEMP
4096: -- Modify the LOV to join with MTL_RMA_SERIAL_TEMP
4097: -- Else
4098: -- the Existing LOV
4099: -- End if
4092: -- IF enforce is YES
4093: -- then
4094: -- For all Order lines matching with the ITEM call INV_RMA_SERIAL_PVT.POPULATE_TEMP_TABLE
4095: -- to populate the temporary serial table MTL_RMA_SERIAL_TEMP
4096: -- Modify the LOV to join with MTL_RMA_SERIAL_TEMP
4097: -- Else
4098: -- the Existing LOV
4099: -- End if
4100:
4140: End loop;
4141:
4142: SELECT count(line_id)
4143: INTO l_count_rows
4144: FROM mtl_rma_serial_temp msrt
4145: WHERE msrt.organization_id = p_organization_id
4146: AND msrt.inventory_item_id = p_item_id ;
4147:
4148: IF l_count_rows > 0 THEN