eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_MOVPROC_PRIV dependencies on MTL_TRANSACTIONS_INTERFACE

Line 447: FROM mtl_transactions_interface mti

443: SET wmti.process_status = WIP_CONSTANTS.ERROR
444: WHERE wmti.group_id = p_group_id
445: AND EXISTS
446: (SELECT 1
447: FROM mtl_transactions_interface mti
448: WHERE mti.transaction_header_id = p_mtl_header_id
449: AND mti.move_transaction_id = wmti.transaction_id
450: AND mti.error_explanation IS NOT NULL);
451:

Line 473: FROM mtl_transactions_interface mti

469: FROM mtl_material_transactions_temp mmtt
470: WHERE mmtt.transaction_header_id = p_mtl_header_id
471: AND EXISTS
472: (SELECT *
473: FROM mtl_transactions_interface mti
474: WHERE mti.move_transaction_id = mmtt.move_transaction_id
475: AND mti.transaction_header_id = p_mtl_header_id));
476:
477: IF (l_logLevel <= wip_constants.full_logging) THEN

Line 489: FROM mtl_transactions_interface mti

485: DELETE FROM mtl_material_transactions_temp mmtt
486: WHERE mmtt.transaction_header_id = p_mtl_header_id
487: AND EXISTS
488: (SELECT *
489: FROM mtl_transactions_interface mti
490: WHERE mti.move_transaction_id = mmtt.move_transaction_id
491: AND mti.transaction_header_id = p_mtl_header_id);
492:
493: IF (l_logLevel <= wip_constants.full_logging) THEN

Line 504: FROM mtl_transactions_interface mti

500: -- Delete error records from MTLI
501: DELETE FROM mtl_transaction_lots_interface mtli
502: WHERE mtli.transaction_interface_id IN
503: (SELECT mti.transaction_interface_id
504: FROM mtl_transactions_interface mti
505: WHERE mti.transaction_header_id = p_mtl_header_id);
506:
507: IF (l_logLevel <= wip_constants.full_logging) THEN
508: l_msg := SQL%ROWCOUNT ||

Line 515: DELETE FROM mtl_transactions_interface

511: x_returnStatus => l_returnStatus);
512: END IF;
513:
514: -- Delete error records from MTI
515: DELETE FROM mtl_transactions_interface
516: WHERE transaction_header_id = p_mtl_header_id;
517:
518: IF (l_logLevel <= wip_constants.full_logging) THEN
519: l_msg := SQL%ROWCOUNT ||

Line 520: ' rows deleted from mtl_transactions_interface';

516: WHERE transaction_header_id = p_mtl_header_id;
517:
518: IF (l_logLevel <= wip_constants.full_logging) THEN
519: l_msg := SQL%ROWCOUNT ||
520: ' rows deleted from mtl_transactions_interface';
521: wip_logger.log(p_msg => l_msg,
522: x_returnStatus => l_returnStatus);
523: END IF;
524:

Line 588: * MTL_TRANSACTIONS_INTERFACE into WIP_TXN_INTERFACE_ERRORS

584: END write_mtl_error;
585:
586: /*****************************************************************************
587: * This procedure will be used to record error messages from
588: * MTL_TRANSACTIONS_INTERFACE into WIP_TXN_INTERFACE_ERRORS
589: ****************************************************************************/
590: PROCEDURE write_mtl_errors(p_mtl_header_id IN NUMBER) IS
591:
592: CURSOR c_mtl_errors IS

Line 605: FROM mtl_transactions_interface mti,

601: mti.request_id,
602: mti.program_application_id,
603: mti.program_id,
604: mti.program_update_date
605: FROM mtl_transactions_interface mti,
606: mtl_system_items_kfv msik
607: WHERE mti.transaction_header_id = p_mtl_header_id
608: AND mti.inventory_item_id = msik.inventory_item_id
609: AND mti.organization_id = msik.organization_id

Line 8758: INSERT INTO mtl_transactions_interface

8754: /*------------------------------------------------------------+
8755: | Insert completion transaction record |
8756: +------------------------------------------------------------*/
8757: IF(l_move.jobTxn = WIP_CONSTANTS.YES) THEN
8758: INSERT INTO mtl_transactions_interface
8759: (completion_transaction_id,
8760: transaction_interface_id,
8761: last_updated_by,
8762: last_update_date,

Line 8911: INSERT INTO mtl_transactions_interface

8907: END IF; -- discrete jobs
8908:
8909: IF(l_move.scheTxn = WIP_CONSTANTS.YES) THEN
8910:
8911: INSERT INTO mtl_transactions_interface
8912: (completion_transaction_id,
8913: transaction_interface_id,
8914: last_updated_by,
8915: last_update_date,

Line 9053: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTIONS_INTERFACE');

9049: -- IF debug message level = 2, write statement below to log file
9050: IF (l_logLevel <= wip_constants.full_logging) THEN
9051: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9052: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9053: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTIONS_INTERFACE');
9054: l_msg := fnd_message.get;
9055: wip_logger.log(p_msg => l_msg,
9056: x_returnStatus => l_returnStatus);
9057: END IF;

Line 9064: FROM mtl_transactions_interface mti,

9060: IF(l_move.jobTxn = WIP_CONSTANTS.YES) THEN
9061:
9062: SELECT COUNT(*)
9063: INTO l_mti_lot_rec
9064: FROM mtl_transactions_interface mti,
9065: mtl_system_items msi
9066: WHERE mti.organization_id = msi.organization_id
9067: AND mti.inventory_item_id = msi.inventory_item_id
9068: AND mti.transaction_header_id = p_gib.assy_header_id

Line 9133: FROM mtl_transactions_interface mti,

9129: WIP_CONSTANTS.DYN_RCV_SN,mtl_material_transactions_s.nextval,
9130: NULL),
9131: 1, -- Bug 13734082 ,FP Bug for Populating orignation type as 'Production'
9132: mti.transaction_date
9133: FROM mtl_transactions_interface mti,
9134: mtl_system_items msi,
9135: wip_discrete_jobs wdj
9136: WHERE mti.organization_id = msi.organization_id
9137: AND mti.inventory_item_id = msi.inventory_item_id

Line 9170: FROM mtl_transactions_interface mti,

9166:
9167: UPDATE mtl_transaction_lots_interface mtli
9168: SET lot_expiration_date =
9169: (SELECT MIN(mln.expiration_date)
9170: FROM mtl_transactions_interface mti,
9171: mtl_system_items msi,
9172: mtl_lot_numbers mln
9173: WHERE mti.organization_id = msi.organization_id
9174: AND mti.inventory_item_id = msi.inventory_item_id

Line 9187: FROM mtl_transactions_interface mti,

9183: AND mln.inventory_item_id = mti.inventory_item_id
9184: AND mln.organization_id = mti.organization_id)
9185: WHERE mtli.transaction_interface_id IN
9186: (SELECT mti.transaction_interface_id
9187: FROM mtl_transactions_interface mti,
9188: mtl_system_items msi
9189: WHERE mti.organization_id = msi.organization_id
9190: AND mti.inventory_item_id = msi.inventory_item_id
9191: AND mti.transaction_header_id = p_gib.assy_header_id

Line 9228: FROM mtl_transactions_interface mti,

9224: oracle error 1427. See bugs 866408 and 938422. */
9225: UPDATE mtl_transaction_lots_interface mtli
9226: SET lot_expiration_date =
9227: (SELECT mti.transaction_date + NVL(msi.shelf_life_days,0)
9228: FROM mtl_transactions_interface mti,
9229: mtl_system_items msi
9230: WHERE mti.transaction_header_id = p_gib.assy_header_id
9231: AND mti.transaction_action_id = l_txn_action_id
9232: AND mti.transaction_type_id = l_txn_type_id

Line 9245: FROM mtl_transactions_interface mti,

9241: mti.transaction_interface_id)
9242: WHERE mtli.lot_expiration_date IS NULL
9243: AND mtli.transaction_interface_id IN
9244: (SELECT mti.transaction_interface_id
9245: FROM mtl_transactions_interface mti,
9246: mtl_system_items msi
9247: WHERE mti.organization_id = msi.organization_id
9248: AND mti.inventory_item_id = msi.inventory_item_id
9249: AND mti.transaction_header_id = p_gib.assy_header_id

Line 9272: FROM mtl_transactions_interface mti,

9268: END IF; -- Discrete and Lotbased jobs
9269:
9270: SELECT COUNT(*)
9271: INTO l_mti_ser_rec
9272: FROM mtl_transactions_interface mti,
9273: mtl_system_items msi
9274: WHERE mti.organization_id = msi.organization_id
9275: AND mti.inventory_item_id = msi.inventory_item_id
9276: AND mti.transaction_header_id = p_gib.assy_header_id

Line 9317: FROM mtl_transactions_interface mti,

9313: mti.last_updated_by,
9314: mti.last_update_login,
9315: wsmi.assembly_serial_number,
9316: wsmi.assembly_serial_number
9317: FROM mtl_transactions_interface mti,
9318: mtl_system_items msi,
9319: mtl_transaction_lots_interface mtli,
9320: wip_serial_move_interface wsmi
9321: WHERE mti.organization_id = msi.organization_id

Line 11395: mtl_transactions_interface mti

11391: --Bug#16274722: Added the below code to default the lot expiration date
11392: SELECT COUNT(1)
11393: INTO l_mti_lot_rec
11394: FROM mtl_transaction_lots_interface mtli,
11395: mtl_transactions_interface mti
11396: WHERE mtli.transaction_interface_id = mti.transaction_interface_id
11397: AND mti.transaction_header_id = p_mtl_header_id
11398: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
11399: and MTI.TRANSACTION_TYPE_ID in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)

Line 11408: FROM mtl_transactions_interface mti,

11404:
11405: UPDATE mtl_transaction_lots_interface mtli
11406: SET lot_expiration_date =
11407: (SELECT MIN(mln.expiration_date)
11408: FROM mtl_transactions_interface mti,
11409: mtl_system_items msi,
11410: mtl_lot_numbers mln
11411: WHERE mti.organization_id = msi.organization_id
11412: AND mti.inventory_item_id = msi.inventory_item_id

Line 11424: FROM mtl_transactions_interface mti,

11420: AND mln.inventory_item_id = mti.inventory_item_id
11421: AND mln.organization_id = mti.organization_id)
11422: WHERE mtli.transaction_interface_id IN
11423: (SELECT mti.transaction_interface_id
11424: FROM mtl_transactions_interface mti,
11425: mtl_system_items msi
11426: WHERE mti.organization_id = msi.organization_id
11427: AND mti.inventory_item_id = msi.inventory_item_id
11428: AND mti.transaction_header_id = p_mtl_header_id

Line 11454: FROM mtl_transactions_interface mti,

11450: oracle error 1427. See bugs 866408 and 938422. */
11451: UPDATE mtl_transaction_lots_interface mtli
11452: SET lot_expiration_date =
11453: (SELECT mti.transaction_date + NVL(msi.shelf_life_days,0)
11454: FROM mtl_transactions_interface mti,
11455: mtl_system_items msi
11456: WHERE mti.transaction_header_id =p_mtl_header_id
11457: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
11458: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)

Line 11470: FROM mtl_transactions_interface mti,

11466: mti.transaction_interface_id)
11467: WHERE mtli.lot_expiration_date IS NULL
11468: AND mtli.transaction_interface_id IN
11469: (SELECT mti.transaction_interface_id
11470: FROM mtl_transactions_interface mti,
11471: mtl_system_items msi
11472: WHERE mti.organization_id = msi.organization_id
11473: AND mti.inventory_item_id = msi.inventory_item_id
11474: AND mti.transaction_header_id = p_mtl_header_id