APPS.WSMPGENE dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 135: FROM mtl_transaction_lot_numbers

131:
132: CURSOR test_for_more IS
133: SELECT
134: MIN(transaction_id)
135: FROM mtl_transaction_lot_numbers
136: WHERE inventory_item_id = item_id
137: AND lot_number = ltrim(lot_name)
138: AND transaction_id > cur_trans_id
139: AND transaction_quantity < 0;

Line 218: FROM mtl_transaction_lot_numbers mtln,

214: x_err_msg OUT VARCHAR2 ) IS
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

Line 242: FROM mtl_transaction_lot_numbers

238: x_err_msg OUT VARCHAR2) IS
239: CURSOR check_for_more IS
240: SELECT
241: count(*)
242: FROM mtl_transaction_lot_numbers
243: WHERE lot_number = lot_name
244: AND inventory_item_id = item_id
245: AND transaction_id > cur_trans_id
246: AND transaction_quantity < 0;

Line 472: FROM mtl_transaction_lot_numbers mtln,

468:
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;

Line 480: FROM mtl_transaction_lot_numbers

476: AND mmt.source_line_id = trans_ref;
477: CURSOR test_for_more IS
478: SELECT
479: MAX(transaction_id)
480: FROM mtl_transaction_lot_numbers
481: WHERE lot_number = lot_name
482: AND inventory_item_id = item_id
483: AND transaction_id < cur_trans_id
484: AND transaction_quantity > 0;

Line 566: ** from mtl_transaction_lot_numbers mtln,

562: ** CURSOR issues IS
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

Line 588: FROM mtl_transaction_lot_numbers mtln,

584: BEGIN
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

Line 667: ** FROM mtl_transaction_lot_numbers

663: /* CURSOR check_for_more IS
664: ** SELECT 1
665: ** FROM sys.dual
666: ** WHERE EXISTS (SELECT 1
667: ** FROM mtl_transaction_lot_numbers
668: ** WHERE lot_number = lot_name
669: ** AND inventory_item_id = item_id
670: ** AND transaction_id < cur_trans_id
671: ** AND transaction_quantity > 0);

Line 686: FROM mtl_transaction_lot_numbers

682: BEGIN
683:
684: SELECT 1
685: INTO no_of_trans
686: FROM mtl_transaction_lot_numbers
687: WHERE lot_number = lot_name
688: AND inventory_item_id = item_id
689: AND transaction_id < nvl(cur_trans_id, transaction_id +1) --bugfix1796646 added nvl.
690: AND transaction_quantity > 0;