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_TRANSACTION_LOTS_INTERFACE

Line 501: DELETE FROM mtl_transaction_lots_interface mtli

497: x_returnStatus => l_returnStatus);
498: END IF;
499:
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);

Line 509: ' rows deleted from mtl_transaction_lots_interface';

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 ||
509: ' rows deleted from mtl_transaction_lots_interface';
510: wip_logger.log(p_msg => l_msg,
511: x_returnStatus => l_returnStatus);
512: END IF;
513:

Line 9101: INSERT INTO mtl_transaction_lots_interface

9097: | in mtlt is already inserted for record in mtt and the fact that
9098: | we only insert one row into mtlt here for one row in mtt, we could
9099: | add a NOT EXISTS statment to prevent duplicate record being inserted
9100: +---------------------------------------------------------------------*/
9101: INSERT INTO mtl_transaction_lots_interface
9102: (transaction_interface_id,
9103: lot_number,
9104: primary_quantity,
9105: transaction_quantity,

Line 9149: FROM mtl_transaction_lots_interface mtli

9145: AND mti.organization_id = wdj.organization_id
9146: AND mti.transaction_source_id = wdj.wip_entity_id
9147: AND NOT EXISTS
9148: (SELECT 1
9149: FROM mtl_transaction_lots_interface mtli
9150: WHERE mtli.transaction_interface_id =
9151: mti.transaction_interface_id);
9152:
9153: -- IF debug message level = 2, write statement below to log file

Line 9157: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');

9153: -- IF debug message level = 2, write statement below to log file
9154: IF (l_logLevel <= wip_constants.full_logging) THEN
9155: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9156: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9157: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9158: l_msg := fnd_message.get;
9159: wip_logger.log(p_msg => l_msg,
9160: x_returnStatus => l_returnStatus);
9161: END IF;

Line 9167: UPDATE mtl_transaction_lots_interface mtli

9163: /* Update lot records with an expiration date */
9164: /* Use expiration date in MTL_LOT_NUMBERS. */
9165: /* IF no expiration date THEN calculate based on SHELF_LIFE_DAYS */
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,

Line 9215: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');

9211: -- IF debug message level = 2, write statement below to log file
9212: IF (l_logLevel <= wip_constants.full_logging) THEN
9213: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
9214: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9215: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9216: l_msg := fnd_message.get;
9217: wip_logger.log(p_msg => l_msg,
9218: x_returnStatus => l_returnStatus);
9219: END IF;

Line 9225: UPDATE mtl_transaction_lots_interface mtli

9221: /* IF Exp date null in MTL_LOT_NUMBERS should I leave it null */
9222: /* Or should I just decode based on exp date null in the temp table? */
9223: /* Removed group by and modIFied select and where conditions to avoid
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

Line 9261: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');

9257: -- IF debug message level = 2, write statement below to log file
9258: IF (l_logLevel <= wip_constants.full_logging) THEN
9259: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
9260: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9261: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9262: l_msg := fnd_message.get;
9263: wip_logger.log(p_msg => l_msg,
9264: x_returnStatus => l_returnStatus);
9265: END IF;

Line 9319: mtl_transaction_lots_interface mtli,

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
9322: AND mti.inventory_item_id = msi.inventory_item_id
9323: AND mti.transaction_header_id = p_gib.assy_header_id

Line 11394: FROM mtl_transaction_lots_interface mtli,

11390: l_process_phase := '2.5';
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)

Line 11405: UPDATE mtl_transaction_lots_interface mtli

11401:
11402: IF l_mti_lot_rec>0 THEN
11403: --ProcesOATxn is used only for Discrete jobs
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,

Line 11441: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');

11437: -- IF debug message level = 2, write statement below to log file
11438: IF (l_log_level <= wip_constants.full_logging) THEN
11439: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
11440: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11441: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
11442: l_msg := fnd_message.get;
11443: wip_logger.log(p_msg => l_msg,
11444: x_returnStatus => l_return_status);
11445: END IF;

Line 11451: UPDATE mtl_transaction_lots_interface mtli

11447: /* IF Exp date null in MTL_LOT_NUMBERS should I leave it null */
11448: /* Or should I just decode based on exp date null in the temp table? */
11449: /* Removed group by and modIFied select and where conditions to avoid
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

Line 11485: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');

11481: -- IF debug message level = 2, write statement below to log file
11482: IF (l_log_level <= wip_constants.full_logging) THEN
11483: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
11484: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11485: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
11486: l_msg := fnd_message.get;
11487: wip_logger.log(p_msg => l_msg,
11488: x_returnStatus => l_return_status);
11489: END IF;