APPS.CST_DIAGNOSTICS_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 74: FROM MTL_MATERIAL_TRANSACTIONS

70:
71: BEGIN
72: SELECT COMPLETION_TRANSACTION_ID
73: INTO L_C_TXN_ID
74: FROM MTL_MATERIAL_TRANSACTIONS
75: WHERE TRANSACTION_ID =TXN_ID
76: AND ORGANIZATION_ID =L_ORG_ID;
77:
78: IF L_C_TXN_ID IS NULL

Line 86: FROM MTL_MATERIAL_TRANSACTIONS

82: VALUES(TXN_ID,'COMPLETION TRANSACTION_ID NOT STAMPED.',NULL);
83: ELSE
84: SELECT COSTED_FLAG
85: INTO L_COSTED_FLAG
86: FROM MTL_MATERIAL_TRANSACTIONS
87: WHERE COMPLETION_TRANSACTION_ID = L_C_TXN_ID
88: AND TRANSACTION_SOURCE_TYPE_ID = 5
89: AND TRANSACTION_ACTION_ID NOT IN (1, 27, 33, 34);
90:

Line 133: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */

129: BEGIN
130: delete from CST_DIAG_ERRORED_TXNS;
131:
132: FOR ORG_REC IN ALL_ACTUAL_COSTING_ORGS LOOP
133: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */
134: TRUNC(NVL(MIN(TRANSACTION_DATE),(SYSDATE+1)))
135: INTO L_MIN_DATE
136: FROM mtl_material_transactions MMT
137: WHERE

Line 136: FROM mtl_material_transactions MMT

132: FOR ORG_REC IN ALL_ACTUAL_COSTING_ORGS LOOP
133: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */
134: TRUNC(NVL(MIN(TRANSACTION_DATE),(SYSDATE+1)))
135: INTO L_MIN_DATE
136: FROM mtl_material_transactions MMT
137: WHERE
138: nvl(parent_transaction_id, transaction_id) = transaction_id
139: AND costed_flag in ('N', 'E')
140: AND

Line 153: FROM mtl_material_transactions_temp MMTP

149: nvl(logical_transactions_created, 1) = 2
150: OR
151: EXISTS (
152: SELECT null
153: FROM mtl_material_transactions_temp MMTP
154: WHERE MMT.transaction_action_id IN (30, 31)
155: AND MMT.organization_id = MMTP.organization_id
156: AND (MMT.COMPLETION_TRANSACTION_ID = MMTP.COMPLETION_TRANSACTION_ID
157: -- Added for bug 4256685

Line 284: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */

280: )
281: );
282:
283:
284: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */
285: NVL(MIN(TRANSACTION_ID),-1)
286: INTO L_MIN_TXN
287: FROM mtl_material_transactions MMT
288: WHERE

Line 287: FROM mtl_material_transactions MMT

283:
284: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */
285: NVL(MIN(TRANSACTION_ID),-1)
286: INTO L_MIN_TXN
287: FROM mtl_material_transactions MMT
288: WHERE
289: transaction_date < (L_MIN_DATE+1)
290: AND transaction_date >= L_MIN_DATE
291: AND nvl(parent_transaction_id, transaction_id) = transaction_id

Line 306: FROM mtl_material_transactions_temp MMTP

302: nvl(logical_transactions_created, 1) = 2
303: OR
304: EXISTS (
305: SELECT null
306: FROM mtl_material_transactions_temp MMTP
307: WHERE MMT.transaction_action_id IN (30, 31)
308: AND MMT.organization_id = MMTP.organization_id
309: AND (MMT.COMPLETION_TRANSACTION_ID = MMTP.COMPLETION_TRANSACTION_ID
310: -- Added for bug 4256685

Line 465: FROM MTL_MATERIAL_TRANSACTIONS

461: L_TXN_MOVE_TXN_ID,
462: L_TXN_COMP_TXN_ID,
463: L_TXN_COSTED_FLAG,
464: L_LOGICAL_TXN_CRTD
465: FROM MTL_MATERIAL_TRANSACTIONS
466: WHERE TRANSACTION_ID = L_MIN_TXN;
467:
468:
469:

Line 599: FROM MTL_MATERIAL_TRANSACTIONS

595: ORGANIZATION_ID,
596: TRANSFER_ORGANIZATION_ID,
597: TRANSFER_TRANSACTION_ID,
598: COSTED_FLAG
599: FROM MTL_MATERIAL_TRANSACTIONS
600: WHERE ORGANIZATION_ID =ORG_ID
601: AND COSTED_FLAG ='N';
602:
603: L_MIN_REQUEST_ID NUMBER :=NULL;

Line 737: FROM MTL_MATERIAL_TRANSACTIONS MMT

733: AND WCTI.ENTITY_TYPE = 5
734: AND WCTI.PROCESS_STATUS = 3
735: UNION
736: SELECT MIN(TRANSACTION_DATE)
737: FROM MTL_MATERIAL_TRANSACTIONS MMT
738: WHERE MMT.TRANSACTION_SOURCE_TYPE_ID = 5
739: AND MMT.ORGANIZATION_ID = L_ORGANIZATION_ID
740: AND MMT.COSTED_FLAG = 'E'
741: AND EXISTS (SELECT 1

Line 748: FROM MTL_MATERIAL_TRANSACTIONS MMT,

744: AND WE.ORGANIZATION_ID = MMT.ORGANIZATION_ID
745: AND WE.ENTITY_TYPE = 5));
746: SELECT 1
747: INTO L_LOT_FLAG
748: FROM MTL_MATERIAL_TRANSACTIONS MMT,
749: WIP_ENTITIES WE
750: WHERE MMT.TRANSACTION_ID =ITEM_REC.TRANSACTION_ID
751: AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
752: AND WE.WIP_ENTITY_ID = MMT.TRANSACTION_SOURCE_ID

Line 832: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,

828: ( L_TXN_SOURCE_TYPE_ID =5 ) THEN
829:
830: SELECT COUNT(MMTT.COMPLETION_TRANSACTION_ID)
831: INTO L_MMTT_COUNT
832: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
833: CST_DIAG_ERRORED_TXNS SC
834: WHERE SC.ORGANIZATION_ID = L_ORGANIZATION_ID
835: AND SC.TRANSACTION_SOURCE_TYPE_ID = 5
836: AND MMTT.ORGANIZATION_ID = SC.ORGANIZATION_ID

Line 867: FROM MTL_MATERIAL_TRANSACTIONS MMT

863: WHERE SC.BOTTLE_NECK_TXN_ID IS NOT NULL
864: AND SC.TRANSACTION_ACTION_ID = 3
865: AND SC.TRANSACTION_COST IS NULL
866: AND EXISTS ( SELECT 'X'
867: FROM MTL_MATERIAL_TRANSACTIONS MMT
868: WHERE MMT.TRANSACTION_ID = SC.TRANSFER_TRANSACTION_ID
869: AND MMT.COSTED_FLAG IS NULL
870: )
871: AND SC.ORGANIZATION_ID = L_ORGANIZATION_ID;