APPS.MTL_CCEOI_PROCESS_PVT dependencies on MTL_SERIAL_NUMBERS

Line 4632: L_table_name := 'MTL_SERIAL_NUMBERS';

4628: MDEBUG( 'After Serial Validation Cd-Stat '||to_char(x_errorcode)||x_return_status);
4629: END IF;
4630: --
4631: IF x_errorcode >0 THEN
4632: L_table_name := 'MTL_SERIAL_NUMBERS';
4633: L_column_name := 'SERIAL_NUMBER';
4634: IF x_errorcode = 15 THEN
4635: L_message_name := 'INV_CCEOI_NO_SERIAL';
4636: ELSIF x_errorcode = 16 THEN

Line 6466: FROM MTL_SERIAL_NUMBERS

6462:
6463: if (x_return_status <> 'S' AND P_issue_receipt = 'R') then
6464: SELECT COUNT(*)
6465: INTO L_serial_count
6466: FROM MTL_SERIAL_NUMBERS
6467: WHERE SERIAL_NUMBER = v_serial_number AND
6468: INVENTORY_ITEM_ID = v_item_id AND
6469: CURRENT_ORGANIZATION_ID = v_org_id AND
6470: CURRENT_STATUS = 3;