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_ROI_TRANSACTION dependencies on MTL_SYSTEM_ITEMS

Line 2005: l_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE;

2001: of value being specified or not in RTI.
2002: */
2003: --AND x_cascaded_table(n).primary_unit_of_measure IS NULL THEN
2004: DECLARE
2005: l_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE;
2006: BEGIN
2007: /* BUG 608353 */
2008: SELECT primary_unit_of_measure
2009: INTO l_primary_unit_of_measure

Line 2010: FROM mtl_system_items

2006: BEGIN
2007: /* BUG 608353 */
2008: SELECT primary_unit_of_measure
2009: INTO l_primary_unit_of_measure
2010: FROM mtl_system_items
2011: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
2012: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
2013: IF (g_asn_debug = 'Y') THEN
2014: asn_debug.put_line('Primary UOM from RTI :' || x_cascaded_table(n).primary_unit_of_measure);

Line 2011: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id

2007: /* BUG 608353 */
2008: SELECT primary_unit_of_measure
2009: INTO l_primary_unit_of_measure
2010: FROM mtl_system_items
2011: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
2012: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
2013: IF (g_asn_debug = 'Y') THEN
2014: asn_debug.put_line('Primary UOM from RTI :' || x_cascaded_table(n).primary_unit_of_measure);
2015: asn_debug.put_line('Derived PRIMARY UOM from MSI:' || l_primary_unit_of_measure);

Line 2012: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;

2008: SELECT primary_unit_of_measure
2009: INTO l_primary_unit_of_measure
2010: FROM mtl_system_items
2011: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
2012: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
2013: IF (g_asn_debug = 'Y') THEN
2014: asn_debug.put_line('Primary UOM from RTI :' || x_cascaded_table(n).primary_unit_of_measure);
2015: asn_debug.put_line('Derived PRIMARY UOM from MSI:' || l_primary_unit_of_measure);
2016: END IF;

Line 2055: FROM mtl_system_items

2051: SELECT NVL(x_cascaded_table(n).use_mtl_lot, lot_control_code),
2052: NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
2053: INTO x_cascaded_table(n).use_mtl_lot,
2054: x_cascaded_table(n).use_mtl_serial
2055: FROM mtl_system_items
2056: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
2057: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
2058:
2059: IF (g_asn_debug = 'Y') THEN

Line 2056: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id

2052: NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
2053: INTO x_cascaded_table(n).use_mtl_lot,
2054: x_cascaded_table(n).use_mtl_serial
2055: FROM mtl_system_items
2056: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
2057: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
2058:
2059: IF (g_asn_debug = 'Y') THEN
2060: asn_debug.put_line('use_mtl_lot: ' || x_cascaded_table(n).use_mtl_lot);

Line 2057: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;

2053: INTO x_cascaded_table(n).use_mtl_lot,
2054: x_cascaded_table(n).use_mtl_serial
2055: FROM mtl_system_items
2056: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
2057: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
2058:
2059: IF (g_asn_debug = 'Y') THEN
2060: asn_debug.put_line('use_mtl_lot: ' || x_cascaded_table(n).use_mtl_lot);
2061: asn_debug.put_line('use_mtl_serial: ' || x_cascaded_table(n).use_mtl_serial);

Line 4878: FROM mtl_system_items

4874: AND temp_cascaded_table(current_n).item_id IS NOT NULL THEN --{
4875: BEGIN
4876: SELECT primary_unit_of_measure
4877: INTO temp_cascaded_table(current_n).primary_unit_of_measure
4878: FROM mtl_system_items
4879: WHERE mtl_system_items.inventory_item_id = temp_cascaded_table(current_n).item_id
4880: AND mtl_system_items.organization_id = temp_cascaded_table(current_n).to_organization_id;
4881:
4882: IF (g_asn_debug = 'Y') THEN

Line 4879: WHERE mtl_system_items.inventory_item_id = temp_cascaded_table(current_n).item_id

4875: BEGIN
4876: SELECT primary_unit_of_measure
4877: INTO temp_cascaded_table(current_n).primary_unit_of_measure
4878: FROM mtl_system_items
4879: WHERE mtl_system_items.inventory_item_id = temp_cascaded_table(current_n).item_id
4880: AND mtl_system_items.organization_id = temp_cascaded_table(current_n).to_organization_id;
4881:
4882: IF (g_asn_debug = 'Y') THEN
4883: asn_debug.put_line('Primary UOM: ' || temp_cascaded_table(current_n).primary_unit_of_measure);

Line 4880: AND mtl_system_items.organization_id = temp_cascaded_table(current_n).to_organization_id;

4876: SELECT primary_unit_of_measure
4877: INTO temp_cascaded_table(current_n).primary_unit_of_measure
4878: FROM mtl_system_items
4879: WHERE mtl_system_items.inventory_item_id = temp_cascaded_table(current_n).item_id
4880: AND mtl_system_items.organization_id = temp_cascaded_table(current_n).to_organization_id;
4881:
4882: IF (g_asn_debug = 'Y') THEN
4883: asn_debug.put_line('Primary UOM: ' || temp_cascaded_table(current_n).primary_unit_of_measure);
4884: END IF;

Line 8103: mtl_system_items msi

8099:
8100: SELECT NVL(MAX(secondary_inventory_name), 'notfound')
8101: INTO x_subinventory
8102: FROM mtl_secondary_inventories msub,
8103: mtl_system_items msi
8104: WHERE msub.secondary_inventory_name = x_cascaded_table(n).subinventory
8105: AND msub.organization_id = x_cascaded_table(n).to_organization_id
8106: AND x_cascaded_table(n).transaction_date < NVL(msub.disable_date, x_cascaded_table(n).transaction_date + 1)
8107: AND msi.inventory_item_id = x_cascaded_table(n).item_id

Line 8713: x_primary_uom mtl_system_items.primary_unit_of_measure%TYPE := NULL;

8709: n IN BINARY_INTEGER
8710: ) IS
8711: location_record rcv_shipment_line_sv.location_record_type;
8712: x_item_id NUMBER;
8713: x_primary_uom mtl_system_items.primary_unit_of_measure%TYPE := NULL;
8714: x_uom_class VARCHAR2(10);
8715: x_uom_count NUMBER(10);
8716: prim_uom_qty NUMBER;
8717: x_error_status VARCHAR2(1);

Line 8718: l_item_description mtl_system_items_vl.description%type; --bug 4697949

8714: x_uom_class VARCHAR2(10);
8715: x_uom_count NUMBER(10);
8716: prim_uom_qty NUMBER;
8717: x_error_status VARCHAR2(1);
8718: l_item_description mtl_system_items_vl.description%type; --bug 4697949
8719: BEGIN
8720: x_error_status := rcv_error_pkg.g_ret_sts_error;
8721:
8722: -- If substitute item has been specified then we need to switch the item_id with the

Line 8754: FROM mtl_system_items

8750: END IF;
8751:
8752: SELECT MAX(primary_unit_of_measure)
8753: INTO x_primary_uom
8754: FROM mtl_system_items
8755: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
8756: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
8757:
8758: IF x_primary_uom IS NULL THEN

Line 8755: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id

8751:
8752: SELECT MAX(primary_unit_of_measure)
8753: INTO x_primary_uom
8754: FROM mtl_system_items
8755: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
8756: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
8757:
8758: IF x_primary_uom IS NULL THEN
8759: IF (g_asn_debug = 'Y') THEN

Line 8756: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;

8752: SELECT MAX(primary_unit_of_measure)
8753: INTO x_primary_uom
8754: FROM mtl_system_items
8755: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
8756: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
8757:
8758: IF x_primary_uom IS NULL THEN
8759: IF (g_asn_debug = 'Y') THEN
8760: asn_debug.put_line('No Primary UOM for substitute item');

Line 8796: from mtl_system_items_vl

8792: substitute item*/
8793: BEGIN
8794: select description
8795: into l_item_description
8796: from mtl_system_items_vl
8797: where inventory_item_id = x_cascaded_table(n).substitute_item_id
8798: and organization_id = x_cascaded_table(n).to_organization_id;
8799: EXCEPTION
8800: when others then

Line 13068: FROM mtl_system_items

13064: SELECT NVL(x_cascaded_table(n).use_mtl_lot, lot_control_code),
13065: NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
13066: INTO x_cascaded_table(n).use_mtl_lot,
13067: x_cascaded_table(n).use_mtl_serial
13068: FROM mtl_system_items
13069: WHERE mtl_system_items.inventory_item_id = NVL(x_cascaded_table(n).item_id, 0)
13070: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
13071: END IF;
13072: END Comment: Bug: 4735484

Line 13069: WHERE mtl_system_items.inventory_item_id = NVL(x_cascaded_table(n).item_id, 0)

13065: NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
13066: INTO x_cascaded_table(n).use_mtl_lot,
13067: x_cascaded_table(n).use_mtl_serial
13068: FROM mtl_system_items
13069: WHERE mtl_system_items.inventory_item_id = NVL(x_cascaded_table(n).item_id, 0)
13070: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
13071: END IF;
13072: END Comment: Bug: 4735484
13073: */

Line 13070: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;

13066: INTO x_cascaded_table(n).use_mtl_lot,
13067: x_cascaded_table(n).use_mtl_serial
13068: FROM mtl_system_items
13069: WHERE mtl_system_items.inventory_item_id = NVL(x_cascaded_table(n).item_id, 0)
13070: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
13071: END IF;
13072: END Comment: Bug: 4735484
13073: */
13074: x_cascaded_table(n).interface_source_code := NVL(x_cascaded_table(n).interface_source_code,'RCV'); -- Bug 10127806;

Line 15894: mtl_system_items table.Added the IF - END IF statement. */

15890: * get the use_mtl_lot and use_mtl_serial.
15891: */
15892: /* Bug 5076685: For one time items, item_id won't be available. We need to
15893: have a check for item_id not null, before hitting the
15894: mtl_system_items table.Added the IF - END IF statement. */
15895: /*
15896: BEGIN Comment: Bug: 4735484
15897: IF x_cascaded_table(n).item_id IS NOT NULL THEN
15898: SELECT NVL(x_cascaded_table(n).use_mtl_lot, lot_control_code),

Line 15902: FROM mtl_system_items

15898: SELECT NVL(x_cascaded_table(n).use_mtl_lot, lot_control_code),
15899: NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
15900: INTO x_cascaded_table(n).use_mtl_lot,
15901: x_cascaded_table(n).use_mtl_serial
15902: FROM mtl_system_items
15903: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
15904: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
15905: END IF;
15906: END Comment: Bug: 4735484

Line 15903: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id

15899: NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
15900: INTO x_cascaded_table(n).use_mtl_lot,
15901: x_cascaded_table(n).use_mtl_serial
15902: FROM mtl_system_items
15903: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
15904: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
15905: END IF;
15906: END Comment: Bug: 4735484
15907: */

Line 15904: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;

15900: INTO x_cascaded_table(n).use_mtl_lot,
15901: x_cascaded_table(n).use_mtl_serial
15902: FROM mtl_system_items
15903: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
15904: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
15905: END IF;
15906: END Comment: Bug: 4735484
15907: */
15908: END IF;