350: ,1
351: ,2000)
352: INTO P_ITEM_NAME
353: FROM
354: MTL_SYSTEM_ITEMS_KFV MSIV
355: WHERE MSIV.INVENTORY_ITEM_ID = P_ITEM_ID
356: AND MSIV.ORGANIZATION_ID = NVL(P_ORGANIZATION_ID
357: ,P_DEFAULT_ORG_ID);
358: END IF;
615: L_PROG_APPL_ID,
616: L_PROG_ID,
617: sysdate
618: FROM
619: MTL_SYSTEM_ITEMS_KFV MSI,
620: BOM_PARAMETERS BP,
621: CST_ITEM_COSTS CIC,
622: MTL_PARAMETERS MP
623: WHERE P_ORGANIZATION_ID is not null
677: L_PROG_APPL_ID,
678: L_PROG_ID,
679: sysdate
680: FROM
681: MTL_SYSTEM_ITEMS_KFV MSI,
682: BOM_PARAMETERS BP,
683: CST_ITEM_COSTS CIC,
684: MTL_PARAMETERS MP
685: WHERE P_ORGANIZATION_ID is null