APPS.WSMPGENE dependencies on MTL_MATERIAL_TRANSACTIONS

Line 93: FROM mtl_material_transactions

89:
90: CURSOR get_wip_id IS
91: SELECT
92: transaction_source_id
93: FROM mtl_material_transactions
94: WHERE transaction_id = trans_id
95: AND transaction_source_type_id = 5;
96: BEGIN
97: OPEN get_wip_id;

Line 128: FROM mtl_material_transactions

124:
125: CURSOR get_cur_trans_id IS
126: SELECT
127: max(transaction_id)
128: FROM mtl_material_transactions
129: WHERE source_line_id = trans_ref
130: AND transaction_quantity < 0;
131:
132: CURSOR test_for_more IS

Line 146: FROM mtl_material_transactions mmt

142: SELECT /*+ ORDERED */
143: mmt.source_line_id,
144: mmt.transaction_type_id,
145: mmt.source_code
146: FROM mtl_material_transactions mmt
147: WHERE mmt.transaction_id = next_trans_id;
148:
149: /* AND mmt.transaction_type_id = mtt.transaction_type_id; */
150:

Line 219: mtl_material_transactions mt

215: CURSOR wip_completion IS
216: SELECT
217: count(*)
218: FROM mtl_transaction_lot_numbers mtln,
219: mtl_material_transactions mt
220: WHERE mt.transaction_source_id = wip_ent_id
221: AND mt.organization_id = org_id
222: AND mt.transaction_action_id = 31
223: AND mt.transaction_source_type_id = 5

Line 436: FROM mtl_material_transactions

432:
433: CURSOR get_wip_id IS
434: SELECT
435: transaction_source_id
436: FROM mtl_material_transactions
437: WHERE transaction_id = trans_id
438: AND transaction_source_type_id = 5;
439: BEGIN
440: OPEN get_wip_id;

Line 473: mtl_material_transactions mmt

469: CURSOR get_cur_trans_id IS
470: SELECT
471: MIN(mmt.transaction_id)
472: FROM mtl_transaction_lot_numbers mtln,
473: mtl_material_transactions mmt
474: WHERE mtln.lot_number = lot_name
475: AND mtln.transaction_id = mmt.transaction_id
476: AND mmt.source_line_id = trans_ref;
477: CURSOR test_for_more IS

Line 493: FROM mtl_material_transactions mmt

489: SELECT mmt.source_line_id,
490: mmt.transaction_type_id,
491: mmt.source_code,
492: mmt.transaction_source_id
493: FROM mtl_material_transactions mmt
494: WHERE mmt.transaction_id = next_trans_id ;
495:
496: /* AND mmt.transaction_type_id = mtt.transaction_type_id; */
497:

Line 567: ** mtl_material_transactions mt

563: ** SELECT 1
564: ** FROM sys.dual
565: ** WHERE exists (select 1
566: ** from mtl_transaction_lot_numbers mtln,
567: ** mtl_material_transactions mt
568: ** WHERE mtln.transaction_id = mt.transaction_id
569: ** AND mt.transaction_source_id = wip_ent_id
570: ** AND mt.organization_id = org_id
571: ** AND mt.transaction_action_id = 1

Line 589: mtl_material_transactions mt

585:
586: SELECT 1
587: INTO no_trans
588: FROM mtl_transaction_lot_numbers mtln,
589: mtl_material_transactions mt
590: WHERE mtln.transaction_id = mt.transaction_id
591: AND mt.transaction_source_id = wip_ent_id
592: AND mt.organization_id = org_id
593: AND mt.transaction_action_id = 1