APPS.BOM_CSTRSCCR_XMLP_PKG dependencies on MTL_PARAMETERS

Line 278: MTL_PARAMETERS

274: SELECT
275: PRIMARY_COST_METHOD
276: INTO LP_BUY_COST_TYPE_ID
277: FROM
278: MTL_PARAMETERS
279: WHERE ORGANIZATION_ID = NVL(LP_ORGANIZATION_ID
280: ,lp_default_org_id);
281: END IF;
282: L_STMT_NUM := 70;

Line 430: MTL_PARAMETERS MP

426: FROM
427: MTL_SYSTEM_ITEMS MSI,
428: BOM_PARAMETERS BP,
429: CST_ITEM_COSTS CIC,
430: MTL_PARAMETERS MP
431: WHERE MSI.ORGANIZATION_ID = NVL(LP_ORGANIZATION_ID
432: ,MSI.ORGANIZATION_ID)
433: AND MSI.INVENTORY_ITEM_ID = P_ITEM_ID
434: AND MSI.COSTING_ENABLED_FLAG = 'Y'

Line 495: MTL_PARAMETERS MP

491: MTL_SYSTEM_ITEMS MSI,
492: BOM_PARAMETERS BP,
493: MTL_CATEGORIES_KFV MCV,
494: CST_ITEM_COSTS CIC,
495: MTL_PARAMETERS MP
496: WHERE LP_ORGANIZATION_ID is not null
497: AND MIC.ORGANIZATION_ID = LP_ORGANIZATION_ID
498: AND MIC.CATEGORY_SET_ID = LP_CATEGORY_SET_ID
499: AND MIC.CATEGORY_ID = MCV.CATEGORY_ID

Line 557: MTL_PARAMETERS MP

553: MTL_SYSTEM_ITEMS MSI,
554: BOM_PARAMETERS BP,
555: MTL_CATEGORIES_KFV MCV,
556: CST_ITEM_COSTS CIC,
557: MTL_PARAMETERS MP
558: WHERE LP_ORGANIZATION_ID is null
559: AND MIC.CATEGORY_SET_ID = LP_CATEGORY_SET_ID
560: AND MIC.CATEGORY_ID = MCV.CATEGORY_ID
561: AND MCV.CONCATENATED_SEGMENTS >= DECODE(P_CATEGORY_FROM

Line 630: MTL_PARAMETERS MP

626: FROM
627: MTL_SYSTEM_ITEMS_KFV MSI,
628: BOM_PARAMETERS BP,
629: CST_ITEM_COSTS CIC,
630: MTL_PARAMETERS MP
631: WHERE LP_ORGANIZATION_ID is not null
632: AND MSI.ORGANIZATION_ID = LP_ORGANIZATION_ID
633: AND MSI.CONCATENATED_SEGMENTS >= DECODE(P_ITEM_FROM
634: ,NULL

Line 692: MTL_PARAMETERS MP

688: FROM
689: MTL_SYSTEM_ITEMS_KFV MSI,
690: BOM_PARAMETERS BP,
691: CST_ITEM_COSTS CIC,
692: MTL_PARAMETERS MP
693: WHERE LP_ORGANIZATION_ID is null
694: AND MSI.CONCATENATED_SEGMENTS >= DECODE(P_ITEM_FROM
695: ,NULL
696: ,MSI.CONCATENATED_SEGMENTS

Line 851: MTL_PARAMETERS

847: SELECT
848: ORGANIZATION_CODE
849: INTO L_NO_ALT_ORG
850: FROM
851: MTL_PARAMETERS
852: WHERE ORGANIZATION_ID = ORGS.ORGANIZATION_ID;
853: /*SRW.MESSAGE(0
854: ,'Alternate ' || L_SNAPSHOT_DESIGNATOR || ' is not defined in organziation ' || L_NO_ALT_ORG)*/NULL;
855: END LOOP;

Line 863: MTL_PARAMETERS

859: SELECT
860: ORGANIZATION_CODE
861: INTO L_NO_BOM_ORG
862: FROM
863: MTL_PARAMETERS
864: WHERE ORGANIZATION_ID = ORGS.ORGANIZATION_ID;
865: /*SRW.MESSAGE(0
866: ,'Org: ' || L_NO_BOM_ORG || '. ')*/NULL;
867: END LOOP;

Line 996: MTL_PARAMETERS

992: ,0),
993: ORGANIZATION_CODE
994: INTO L_DEFAULT_MATL_OVHD,L_ORGANIZATION_CODE
995: FROM
996: MTL_PARAMETERS
997: WHERE ORGANIZATION_ID = ORGANIZATIONS.ORGANIZATION_ID;
998: IF (L_DEFAULT_MATL_OVHD = 0) THEN
999: FND_MESSAGE.SET_NAME('BOM'
1000: ,'CST_SC_DEF_MATL_OVHD_SUBELEM');