266: SELECT
267: PRIMARY_COST_METHOD
268: INTO LP_BUY_COST_TYPE_ID
269: FROM
270: MTL_PARAMETERS
271: WHERE ORGANIZATION_ID = NVL(P_ORGANIZATION_ID
272: ,P_DEFAULT_ORG_ID);
273: END IF;
274: L_STMT_NUM := 70;
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
424: ,MSI.ORGANIZATION_ID)
425: AND MSI.INVENTORY_ITEM_ID = P_ITEM_ID
426: AND MSI.COSTING_ENABLED_FLAG = 'Y'
483: MTL_SYSTEM_ITEMS MSI,
484: BOM_PARAMETERS BP,
485: MTL_CATEGORIES_KFV MCV,
486: CST_ITEM_COSTS CIC,
487: MTL_PARAMETERS MP
488: WHERE P_ORGANIZATION_ID is not null
489: AND MIC.ORGANIZATION_ID = P_ORGANIZATION_ID
490: AND MIC.CATEGORY_SET_ID = LP_CATEGORY_SET_ID
491: AND MIC.CATEGORY_ID = MCV.CATEGORY_ID
545: MTL_SYSTEM_ITEMS MSI,
546: BOM_PARAMETERS BP,
547: MTL_CATEGORIES_KFV MCV,
548: CST_ITEM_COSTS CIC,
549: MTL_PARAMETERS MP
550: WHERE P_ORGANIZATION_ID is null
551: AND MIC.CATEGORY_SET_ID = LP_CATEGORY_SET_ID
552: AND MIC.CATEGORY_ID = MCV.CATEGORY_ID
553: AND MCV.CONCATENATED_SEGMENTS >= DECODE(P_CATEGORY_FROM
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
624: AND MSI.ORGANIZATION_ID = P_ORGANIZATION_ID
625: AND MSI.CONCATENATED_SEGMENTS >= DECODE(P_ITEM_FROM
626: ,NULL
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
686: AND MSI.CONCATENATED_SEGMENTS >= DECODE(P_ITEM_FROM
687: ,NULL
688: ,MSI.CONCATENATED_SEGMENTS
839: SELECT
840: ORGANIZATION_CODE
841: INTO L_NO_ALT_ORG
842: FROM
843: MTL_PARAMETERS
844: WHERE ORGANIZATION_ID = ORGS.ORGANIZATION_ID;
845: /*SRW.MESSAGE(0
846: ,'Alternate ' || L_SNAPSHOT_DESIGNATOR || ' is not defined in organziation ' || L_NO_ALT_ORG)*/NULL;
847: END LOOP;
851: SELECT
852: ORGANIZATION_CODE
853: INTO L_NO_BOM_ORG
854: FROM
855: MTL_PARAMETERS
856: WHERE ORGANIZATION_ID = ORGS.ORGANIZATION_ID;
857: /*SRW.MESSAGE(0
858: ,'Org: ' || L_NO_BOM_ORG || '. ')*/NULL;
859: END LOOP;
982: ,0),
983: ORGANIZATION_CODE
984: INTO L_DEFAULT_MATL_OVHD,L_ORGANIZATION_CODE
985: FROM
986: MTL_PARAMETERS
987: WHERE ORGANIZATION_ID = ORGANIZATIONS.ORGANIZATION_ID;
988: IF (L_DEFAULT_MATL_OVHD = 0) THEN
989: FND_MESSAGE.SET_NAME('BOM'
990: ,'CST_SC_DEF_MATL_OVHD_SUBELEM');