[Home] [Help]
49: -- GET the SERIAL ENFORCE paramneter from Receiving Options
50: -- IF enforce is YES
51: -- then
52: -- For all Order lines matching with the ITEM call INV_RMA_SERIAL_PVT.POPULATE_TEMP_TABLE
53: -- to populate the temporary serial table MTL_RMA_SERIAL_TEMP
54: -- Modify the LOV to join with MTL_RMA_SERIAL_TEMP
55: -- Else
56: -- the Existing LOV
57: -- End if
50: -- IF enforce is YES
51: -- then
52: -- For all Order lines matching with the ITEM call INV_RMA_SERIAL_PVT.POPULATE_TEMP_TABLE
53: -- to populate the temporary serial table MTL_RMA_SERIAL_TEMP
54: -- Modify the LOV to join with MTL_RMA_SERIAL_TEMP
55: -- Else
56: -- the Existing LOV
57: -- End if
58:
113: AND msn.status_id = mms.status_id(+)
114: AND mms.language (+) = userenv('LANG')
115: 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'
116: AND msn.serial_number LIKE (p_serial)
117: AND EXISTS ( select 'x' from mtl_rma_serial_temp msrt
118: where msrt.organization_id = p_organization_id
119: and msrt.inventory_item_id = p_item_id
120: and msrt.serial_number = msn.serial_number
121: and msrt.serial_number LIKE (p_serial)
3738: -- GET the SERIAL ENFORCE paramneter from Receiving Options
3739: -- IF enforce is YES
3740: -- then
3741: -- For all Order lines matching with the ITEM call INV_RMA_SERIAL_PVT.POPULATE_TEMP_TABLE
3742: -- to populate the temporary serial table MTL_RMA_SERIAL_TEMP
3743: -- Modify the LOV to join with MTL_RMA_SERIAL_TEMP
3744: -- Else
3745: -- the Existing LOV
3746: -- End if
3739: -- IF enforce is YES
3740: -- then
3741: -- For all Order lines matching with the ITEM call INV_RMA_SERIAL_PVT.POPULATE_TEMP_TABLE
3742: -- to populate the temporary serial table MTL_RMA_SERIAL_TEMP
3743: -- Modify the LOV to join with MTL_RMA_SERIAL_TEMP
3744: -- Else
3745: -- the Existing LOV
3746: -- End if
3747:
3787: End loop;
3788:
3789: SELECT count(line_id)
3790: INTO l_count_rows
3791: FROM mtl_rma_serial_temp msrt
3792: WHERE msrt.organization_id = p_organization_id
3793: AND msrt.inventory_item_id = p_item_id ;
3794:
3795:
3854: AND msn.status_id = mms.status_id(+)
3855: AND mms.language (+) = userenv('LANG')
3856: 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'
3857: AND msn.serial_number LIKE (p_serial)
3858: AND EXISTS ( select 'x' from mtl_rma_serial_temp msrt
3859: where msrt.organization_id = p_organization_id
3860: and msrt.inventory_item_id = p_item_id
3861: and msrt.serial_number = msn.serial_number
3862: and msrt.serial_number LIKE (p_serial)
4002: -- GET the SERIAL ENFORCE paramneter from Receiving Options
4003: -- IF enforce is YES
4004: -- then
4005: -- For all Order lines matching with the ITEM call INV_RMA_SERIAL_PVT.POPULATE_TEMP_TABLE
4006: -- to populate the temporary serial table MTL_RMA_SERIAL_TEMP
4007: -- Modify the LOV to join with MTL_RMA_SERIAL_TEMP
4008: -- Else
4009: -- the Existing LOV
4010: -- End if
4003: -- IF enforce is YES
4004: -- then
4005: -- For all Order lines matching with the ITEM call INV_RMA_SERIAL_PVT.POPULATE_TEMP_TABLE
4006: -- to populate the temporary serial table MTL_RMA_SERIAL_TEMP
4007: -- Modify the LOV to join with MTL_RMA_SERIAL_TEMP
4008: -- Else
4009: -- the Existing LOV
4010: -- End if
4011:
4051: End loop;
4052:
4053: SELECT count(line_id)
4054: INTO l_count_rows
4055: FROM mtl_rma_serial_temp msrt
4056: WHERE msrt.organization_id = p_organization_id
4057: AND msrt.inventory_item_id = p_item_id ;
4058:
4059: IF l_count_rows > 0 THEN