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.RCV_PROCESSOR_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 48: FROM mtl_transaction_lots_temp mtlt,

44: rti.shipment_line_id, --Bug 7443786
45: rti.item_id,
46: rti.unit_of_measure,
47: rti.to_organization_id
48: FROM mtl_transaction_lots_temp mtlt,
49: rcv_transactions_interface rti
50: WHERE product_transaction_id = l_interface_id
51: AND product_code = 'RCV'
52: AND rti.interface_transaction_id = mtlt.product_transaction_id

Line 107: * no row in mtl_transaction_lots_temp if user has not entered

103:
104: x_return_status := fnd_api.g_ret_sts_success;
105:
106: /* We can now come here if it is a lot-serial item and there is
107: * no row in mtl_transaction_lots_temp if user has not entered
108: * any lot/serial info for this transaction(Receive, Transfer etc).
109: * In this case we do not error nor insert. So return.
110: */
111: SELECT COUNT(*)

Line 113: FROM mtl_transaction_lots_temp mtlt

109: * In this case we do not error nor insert. So return.
110: */
111: SELECT COUNT(*)
112: INTO l_lot_count
113: FROM mtl_transaction_lots_temp mtlt
114: WHERE mtlt.product_transaction_id = p_interface_transaction_id
115: AND mtlt.product_code = 'RCV';
116:
117: IF (l_lot_count = 0) THEN

Line 452: mtl_transaction_lots_temp mtlt

448: SELECT msnt.fm_serial_number,
449: msnt.to_serial_number,
450: mtlt.lot_number
451: FROM mtl_serial_numbers_temp msnt,
452: mtl_transaction_lots_temp mtlt
453: WHERE msnt.product_transaction_id = p_interface_transaction_id
454: AND msnt.product_code = 'RCV'
455: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id(+);
456:

Line 486: * no row in mtl_transaction_lots_temp if user has not entered

482:
483: x_return_status := fnd_api.g_ret_sts_success;
484:
485: /* We can now come here if it is a lot-serial item and there is
486: * no row in mtl_transaction_lots_temp if user has not entered
487: * any lot/serial info for this transaction(Receive, Transfer etc).
488: * In this case we do not error nor insert. So return.
489: */
490: SELECT COUNT(*)

Line 799: FROM mtl_transaction_lots_temp mtlt,

795: rti.shipment_line_id, --Bug 7443786
796: rti.item_id,
797: rti.unit_of_measure,
798: rti.to_organization_id
799: FROM mtl_transaction_lots_temp mtlt,
800: rcv_transactions_interface rti
801: WHERE product_transaction_id = p_interface_id
802: AND product_code = 'RCV'
803: AND rti.interface_transaction_id = mtlt.product_transaction_id

Line 897: * no row in mtl_transaction_lots_temp if user has not entered

893:
894: x_return_status := fnd_api.g_ret_sts_success;
895:
896: /* We can now come here if it is a lot-serial item and there is
897: * no row in mtl_transaction_lots_temp if user has not entered
898: * any lot/serial info for this transaction(Receive, Transfer etc).
899: * In this case we do not error nor insert. So return.
900: */
901: SELECT COUNT(*)

Line 903: FROM mtl_transaction_lots_temp mtlt

899: * In this case we do not error nor insert. So return.
900: */
901: SELECT COUNT(*)
902: INTO l_lot_count
903: FROM mtl_transaction_lots_temp mtlt
904: WHERE mtlt.product_transaction_id = p_interface_transaction_id
905: AND mtlt.product_code = 'RCV';
906:
907: IF (l_lot_count = 0) THEN

Line 1283: from mtl_transaction_lots_temp mtlt

1279: update rcv_lots_supply rls
1280: set rls.quantity =
1281: (select rls.quantity +
1282: (sum(mtlt.transaction_quantity) * l_factor)
1283: from mtl_transaction_lots_temp mtlt
1284: where mtlt.product_transaction_ID =
1285: p_interface_transaction_id
1286: and mtlt.product_code = 'RCV'
1287: and rls.lot_num = mtlt.lot_number),

Line 1291: from mtl_transaction_lots_temp mtlt

1287: and rls.lot_num = mtlt.lot_number),
1288: rls.primary_quantity =
1289: (select rls.primary_quantity -
1290: (sum(mtlt.primary_quantity) * l_factor)
1291: from mtl_transaction_lots_temp mtlt
1292: where mtlt.product_transaction_ID =
1293: p_interface_transaction_id
1294: and mtlt.product_code = 'RCV'
1295: and rls.lot_num = mtlt.lot_number)

Line 1411: mtl_transaction_lots_temp mtlt

1407: SELECT msnt.fm_serial_number,
1408: msnt.to_serial_number,
1409: mtlt.lot_number
1410: FROM mtl_serial_numbers_temp msnt,
1411: mtl_transaction_lots_temp mtlt
1412: WHERE msnt.product_transaction_id = p_interface_transaction_id
1413: AND msnt.product_code = 'RCV'
1414: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id(+);
1415:

Line 1450: * no row in mtl_transaction_lots_temp if user has not entered

1446:
1447: x_return_status := fnd_api.g_ret_sts_success;
1448:
1449: /* We can now come here if it is a lot-serial item and there is
1450: * no row in mtl_transaction_lots_temp if user has not entered
1451: * any lot/serial info for this transaction(Receive, Transfer etc).
1452: * In this case we do not error nor insert. So return.
1453: */
1454: SELECT COUNT(*)

Line 1776: * no row in mtl_transaction_lots_temp if user has not entered

1772:
1773: x_return_status := fnd_api.g_ret_sts_success;
1774:
1775: /* We can now come here if it is a lot-serial item and there is
1776: * no row in mtl_transaction_lots_temp if user has not entered
1777: * any lot/serial info for this transaction(Receive, Transfer etc).
1778: * In this case we do not error nor insert. So return.
1779: */
1780: SELECT COUNT(*)

Line 1782: FROM mtl_transaction_lots_temp mtlt

1778: * In this case we do not error nor insert. So return.
1779: */
1780: SELECT COUNT(*)
1781: INTO l_lot_count
1782: FROM mtl_transaction_lots_temp mtlt
1783: WHERE mtlt.product_transaction_id = p_interface_transaction_id
1784: AND mtlt.product_code = 'RCV';
1785:
1786: IF (l_lot_count = 0) THEN

Line 1881: FROM mtl_transaction_lots_temp mtlt

1877: /*INVCONV*/
1878: /* mtlt.sublot_num, */
1879: /*end , INVCONV*/
1880: mtlt.reason_code
1881: FROM mtl_transaction_lots_temp mtlt
1882: GROUP BY mtlt.product_transaction_id,
1883: mtlt.lot_number,
1884: /*INVCONV*/
1885: /* mtlt.sublot_num, */

Line 1959: * no row in mtl_transaction_lots_temp if user has not entered

1955:
1956: x_return_status := fnd_api.g_ret_sts_success;
1957:
1958: /* We can now come here if it is a lot-serial item and there is
1959: * no row in mtl_transaction_lots_temp if user has not entered
1960: * any lot/serial info for this transaction(Receive, Transfer etc).
1961: * In this case we do not error nor insert. So return.
1962: */
1963: SELECT COUNT(*)

Line 2103: * no row in mtl_transaction_lots_temp if user has not entered

2099:
2100: x_return_status := fnd_api.g_ret_sts_success;
2101:
2102: /* We can now come here if it is a lot-serial item and there is
2103: * no row in mtl_transaction_lots_temp if user has not entered
2104: * any lot/serial info for this transaction(Receive, Transfer etc).
2105: * In this case we do not error nor insert. So return.
2106: */
2107: SELECT COUNT(*)

Line 2109: FROM mtl_transaction_lots_temp mtlt

2105: * In this case we do not error nor insert. So return.
2106: */
2107: SELECT COUNT(*)
2108: INTO l_lot_count
2109: FROM mtl_transaction_lots_temp mtlt
2110: WHERE mtlt.product_transaction_id = p_interface_transaction_id
2111: AND mtlt.product_code = 'RCV';
2112:
2113: IF (l_lot_count = 0) THEN

Line 2198: FROM mtl_transaction_lots_temp mtlt

2194: /* mtlt.sublot_num, */
2195: /*end , INVCONV*/
2196: mtlt.reason_code,
2197: mtlt.product_code
2198: FROM mtl_transaction_lots_temp mtlt
2199: GROUP BY mtlt.product_transaction_id,
2200: mtlt.lot_number,
2201: mtlt.lot_expiration_date,
2202: /* INVCONV*/