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.INV_LOT_TRX_VALIDATION_PVT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 273: FROM mtl_transaction_lots_interface

269: , supplier_lot_number
270: , n_attribute9
271: , territory_code
272: , serial_transaction_temp_id
273: FROM mtl_transaction_lots_interface
274: WHERE transaction_interface_id = p_transaction_interface_id;
275:
276: /*Support for Lot Serial:
277: *this cursor is to be used in case of the lot split and merge transactions and not for lot

Line 766: UPDATE mtl_transaction_lots_interface

762: SET transaction_quantity = l_transaction_quantity
763: , primary_quantity = l_primary_quantity
764: WHERE transaction_interface_id = l_transaction_interface_id;
765:
766: UPDATE mtl_transaction_lots_interface
767: SET transaction_quantity = ABS (l_transaction_quantity)
768: , primary_quantity = ABS (l_primary_quantity)
769: WHERE transaction_interface_id = l_transaction_interface_id;
770:

Line 1555: FOR l_lot_column_csr IN lot_column_csr ('MTL_TRANSACTION_LOTS_INTERFACE')

1551: global varialble g_select_stmt only once.
1552:
1553: */
1554: /*
1555: FOR l_lot_column_csr IN lot_column_csr ('MTL_TRANSACTION_LOTS_INTERFACE')
1556: LOOP
1557: l_column_idx := l_column_idx + 1;
1558: l_lot_attr_tbl (l_column_idx).column_name :=
1559: l_lot_column_csr.column_name;

Line 1599: || ' FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI, MTL_TRANSACTIONS_INTERFACE MTI, '

1595: THEN
1596: /*Bug:5354721. Appending FROM clause to the global statement. */
1597: l_select_stmt :=
1598: g_select_stmt
1599: || ' FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI, MTL_TRANSACTIONS_INTERFACE MTI, '
1600: || ' MTL_LOT_NUMBERS MLN '
1601: || ' WHERE mtli.transaction_interface_id = :b_interface_id '
1602: || ' AND mtli.lot_number = :b_lot_number '
1603: || ' AND mtli.transaction_interface_id = mti.transaction_interface_id '

Line 1614: || ' FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI, MTL_TRANSACTIONS_INTERFACE MTI, '

1610: -- parent lot. Passing a new parameter called starting lot
1611: -- which is the lot number of the parent lot.
1612: l_select_stmt :=
1613: g_select_stmt
1614: || ' FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI, MTL_TRANSACTIONS_INTERFACE MTI, '
1615: || ' MTL_LOT_NUMBERS MLN '
1616: || ' WHERE mtli.transaction_interface_id = :b_interface_id '
1617: || ' AND mtli.lot_number = :b_lot_number '
1618: || ' AND mtli.transaction_interface_id = mti.transaction_interface_id '

Line 1622: -- l_select_stmt := l_select_stmt || ' FROM MTL_TRANSACTION_LOTS_INTERFACE ' ||

1618: || ' AND mtli.transaction_interface_id = mti.transaction_interface_id '
1619: || ' AND mln.lot_number = :b_starting_lot_number'
1620: || ' AND mln.inventory_item_id = mti.inventory_item_id (+)'
1621: || ' AND mln.organization_id = mti.organization_id (+)';
1622: -- l_select_stmt := l_select_stmt || ' FROM MTL_TRANSACTION_LOTS_INTERFACE ' ||
1623: -- ' WHERE lot_number = :b_lot_number ' ||
1624: -- ' AND transaction_interface_id = :b_interface_id ';
1625: END IF;
1626:

Line 1769: l_update_stmt LONG := 'UPDATE MTL_TRANSACTION_LOTS_INTERFACE SET ';

1765: )
1766: IS
1767: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1768: l_column_idx NUMBER;
1769: l_update_stmt LONG := 'UPDATE MTL_TRANSACTION_LOTS_INTERFACE SET ';
1770: l_sql_p INTEGER := NULL;
1771: l_rows_processed INTEGER := NULL;
1772: l_debug NUMBER
1773: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

Line 1787: EXECUTE IMMEDIATE 'Update mtl_transaction_lots_interface

1783: IF (p_lot_attr_tbl (i).column_value IS NOT NULL)
1784: THEN
1785: IF (p_lot_attr_tbl (i).column_type = 'NUMBER')
1786: THEN
1787: EXECUTE IMMEDIATE 'Update mtl_transaction_lots_interface
1788: set '
1789: || p_lot_attr_tbl (i).column_name
1790: || ' = :1 '
1791: || 'where transaction_interface_id = :2 '

Line 1798: EXECUTE IMMEDIATE 'Update Mtl_transaction_lots_interface

1794: END IF;
1795:
1796: IF (p_lot_attr_tbl (i).column_type = 'DATE')
1797: THEN
1798: EXECUTE IMMEDIATE 'Update Mtl_transaction_lots_interface
1799: SET '
1800: || p_lot_attr_tbl (i).column_name
1801: || ' = :1 '
1802: || 'where transaction_interface_id = :2 '

Line 1812: EXECUTE IMMEDIATE 'Update Mtl_transaction_lots_interface

1808: END IF;
1809:
1810: IF (p_lot_attr_tbl (i).column_type = 'VARCHAR2')
1811: THEN
1812: EXECUTE IMMEDIATE 'Update Mtl_transaction_lots_interface
1813: SET '
1814: || p_lot_attr_tbl (i).column_name
1815: || ' = :1 '
1816: || 'where transaction_interface_id = :2 '

Line 2798: l_represenatative_lot mtl_transaction_lots_interface.lot_number%TYPE

2794: l_count NUMBER;
2795: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2796: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2797: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2798: l_represenatative_lot mtl_transaction_lots_interface.lot_number%TYPE
2799: := NULL;
2800: l_max_lot_qty NUMBER := 0;
2801: l_lot_number mtl_transaction_lots_interface.lot_number%TYPE
2802: := NULL;

Line 2801: l_lot_number mtl_transaction_lots_interface.lot_number%TYPE

2797: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2798: l_represenatative_lot mtl_transaction_lots_interface.lot_number%TYPE
2799: := NULL;
2800: l_max_lot_qty NUMBER := 0;
2801: l_lot_number mtl_transaction_lots_interface.lot_number%TYPE
2802: := NULL;
2803: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;
2804: l_wms_installed VARCHAR2 (1);
2805: l_wms_enabled VARCHAR2 (1);