[Home] [Help]
427: SELECT
428: ITEM_TARIFF
429: INTO I_TARRIF
430: FROM
431: JAI_INV_ITM_SETUPS
432: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
433: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1;
434: EXCEPTION
435: WHEN OTHERS THEN
444: SELECT
445: ITEM_FOLIO
446: INTO I_FOLIO
447: FROM
448: JAI_INV_ITM_SETUPS
449: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
450: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1;
451: EXCEPTION
452: WHEN OTHERS THEN