APPS.CST_DIAGNOSTICS_PKG dependencies on MTL_PARAMETERS

Line 113: FROM MTL_PARAMETERS MP

109: ----------------------------------------------------------------------------*/
110: PROCEDURE Get_Stuck_Txn_Info AS
111: CURSOR ALL_ACTUAL_COSTING_ORGS IS
112: SELECT MP.ORGANIZATION_ID
113: FROM MTL_PARAMETERS MP
114: WHERE MP.PRIMARY_COST_METHOD IN (2,5,6);
115: L_MIN_DATE DATE;
116: L_MIN_TXN NUMBER;
117: L_TXN_DATE DATE;

Line 173: FROM mtl_parameters

169: AND
170: (
171: EXISTS (
172: SELECT null
173: FROM mtl_parameters
174: WHERE organization_id = MMT.transfer_organization_id
175: AND primary_cost_method IN (2,5,6)
176: )
177: AND

Line 215: FROM mtl_parameters

211: AND NVL(MMT.fob_point,MIP.fob_point) = 1
212: AND shipment_costed IS NULL
213: AND EXISTS (
214: SELECT null
215: FROM mtl_parameters
216: WHERE organization_id = MMT.organization_id
217: AND primary_cost_method IN (2,5,6)
218: )
219: )

Line 224: FROM mtl_parameters

220: OR
221: (
222: EXISTS (
223: SELECT null
224: FROM mtl_parameters
225: WHERE organization_id = MMT.organization_id
226: AND primary_cost_method = 1
227: AND cost_cutoff_date is not null
228: AND MMT.transaction_date >= cost_cutoff_date

Line 262: FROM mtl_parameters

258: )
259: AND
260: EXISTS (
261: SELECT null
262: FROM mtl_parameters
263: WHERE
264: primary_cost_method = 1
265: AND cost_cutoff_date is not null
266: AND MMT.transaction_date >= cost_cutoff_date

Line 326: FROM mtl_parameters

322: AND
323: (
324: EXISTS (
325: SELECT null
326: FROM mtl_parameters
327: WHERE organization_id = MMT.transfer_organization_id
328: AND primary_cost_method IN (2,5,6)
329: )
330: AND

Line 370: FROM mtl_parameters

366: AND NVL(MMT.fob_point,MIP.fob_point) = 1
367: AND shipment_costed IS NULL
368: AND EXISTS (
369: SELECT null
370: FROM mtl_parameters
371: WHERE organization_id = MMT.organization_id
372: AND primary_cost_method IN (2,5,6)
373: )
374: )

Line 379: FROM mtl_parameters

375: OR
376: (
377: EXISTS (
378: SELECT null
379: FROM mtl_parameters
380: WHERE organization_id = MMT.organization_id
381: AND primary_cost_method = 1
382: AND cost_cutoff_date is not null
383: AND MMT.transaction_date >= cost_cutoff_date

Line 418: FROM mtl_parameters

414: )
415: AND
416: EXISTS (
417: SELECT null
418: FROM mtl_parameters
419: WHERE
420: primary_cost_method = 1
421: AND cost_cutoff_date is not null
422: AND MMT.transaction_date >= cost_cutoff_date

Line 568: FROM MTL_PARAMETERS

564: IF (L_RELEASE IN ('11.5.7','11.5.8','11.5.9','11.5.10'))
565: THEN
566: SELECT NVL(COST_CUTOFF_DATE,SYSDATE+1)
567: INTO P_COST_CUTOFF_DATE
568: FROM MTL_PARAMETERS
569: WHERE ORGANIZATION_ID = P_ORG_ID;
570: ELSE
571: P_COST_CUTOFF_DATE :=SYSDATE+1;
572: END IF;

Line 661: FROM MTL_PARAMETERS

657: SELECT PRIMARY_COST_METHOD,
658: NVL(WSM_ENABLED_FLAG,'N')
659: INTO L_PRIMARY_COST_METHOD,
660: L_WSM_FLAG
661: FROM MTL_PARAMETERS
662: WHERE ORGANIZATION_ID = L_ORGANIZATION_ID;
663:
664: --DBMS_OUTPUT.PUT_LINE('CHECKING COSTING METHOD: = '|| L_PRIMARY_COST_METHOD || 'WMS FLAG = '|| L_WSM_FLAG );
665:

Line 686: FROM MTL_PARAMETERS

682: /* get transfer_org costing method only if TRANSFER_ORGANIZATION_ID is not null */
683: IF (ITEM_REC.TRANSFER_ORGANIZATION_ID is not null) THEN
684: SELECT PRIMARY_COST_METHOD
685: INTO L_TRF_ORG_CST_METHOD
686: FROM MTL_PARAMETERS
687: WHERE ORGANIZATION_ID = ITEM_REC.TRANSFER_ORGANIZATION_ID;
688: END IF;
689:
690: --DBMS_OUTPUT.PUT_LINE('TXN DATE :='||ITEM_REC.TRANSACTION_DATE);