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;
415: L_PROG_APPL_ID,
416: L_PROG_ID,
417: sysdate
418: FROM
419: MTL_SYSTEM_ITEMS MSI,
420: BOM_PARAMETERS BP,
421: CST_ITEM_COSTS CIC,
422: MTL_PARAMETERS MP
423: WHERE MSI.ORGANIZATION_ID = NVL(P_ORGANIZATION_ID
479: L_PROG_ID,
480: sysdate
481: FROM
482: MTL_ITEM_CATEGORIES MIC,
483: MTL_SYSTEM_ITEMS MSI,
484: BOM_PARAMETERS BP,
485: MTL_CATEGORIES_KFV MCV,
486: CST_ITEM_COSTS CIC,
487: MTL_PARAMETERS MP
541: L_PROG_ID,
542: sysdate
543: FROM
544: MTL_ITEM_CATEGORIES MIC,
545: MTL_SYSTEM_ITEMS MSI,
546: BOM_PARAMETERS BP,
547: MTL_CATEGORIES_KFV MCV,
548: CST_ITEM_COSTS CIC,
549: MTL_PARAMETERS MP
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