APPS.MTL_CCEOI_PROCESS_PVT dependencies on MTL_SERIAL_NUMBERS

Line 4489: L_table_name := 'MTL_SERIAL_NUMBERS';

4485: MDEBUG( 'After Serial Validation Cd-Stat '||to_char(x_errorcode)||x_return_status);
4486: END IF;
4487: --
4488: IF x_errorcode >0 THEN
4489: L_table_name := 'MTL_SERIAL_NUMBERS';
4490: L_column_name := 'SERIAL_NUMBER';
4491: IF x_errorcode = 15 THEN
4492: L_message_name := 'INV_CCEOI_NO_SERIAL';
4493: ELSIF x_errorcode = 16 THEN

Line 6291: FROM MTL_SERIAL_NUMBERS

6287:
6288: if (x_return_status <> 'S' AND P_issue_receipt = 'R') then
6289: SELECT COUNT(*)
6290: INTO L_serial_count
6291: FROM MTL_SERIAL_NUMBERS
6292: WHERE SERIAL_NUMBER = v_serial_number AND
6293: INVENTORY_ITEM_ID = v_item_id AND
6294: CURRENT_ORGANIZATION_ID = v_org_id AND
6295: CURRENT_STATUS = 3;