DBA Data[Home] [Help]

APPS.CSI_INV_TRXS_PKG dependencies on DUAL

Line 2522: FROM sys.dual

2518: debug('l_mtl_item_tbl(j).serial_number : '||l_mtl_item_tbl(j).serial_number);
2519:
2520: BEGIN
2521: SELECT 'Y' INTO l_return_item
2522: FROM sys.dual
2523: WHERE EXISTS (
2524: SELECT 1 FROM csi_item_instances
2525: WHERE serial_number = l_mtl_item_tbl(j).serial_number
2526: AND inventory_item_id = l_mtl_item_tbl(j).inventory_item_id

Line 5255: FROM sys.dual

5251: debug('serial_number_control_code' || l_mtl_item_tbl(table_index).serial_number_control_code);
5252:
5253: BEGIN
5254: SELECT 'Y' INTO l_returned_item
5255: FROM sys.dual
5256: WHERE EXISTS (
5257: SELECT 1 FROM csi_item_instances
5258: WHERE serial_number = l_mtl_item_tbl(table_index).serial_number
5259: AND inventory_item_id = l_mtl_item_tbl(table_index).inventory_item_id