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.

[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on MTL_SYSTEM_ITEMS

Line 1549: l_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE;

1545: of value being specified or not in RTI.
1546: */
1547: --AND x_cascaded_table(n).primary_unit_of_measure IS NULL THEN
1548: DECLARE
1549: l_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE;
1550: BEGIN
1551: /* BUG 608353 */
1552: SELECT primary_unit_of_measure
1553: INTO l_primary_unit_of_measure

Line 1554: FROM mtl_system_items

1550: BEGIN
1551: /* BUG 608353 */
1552: SELECT primary_unit_of_measure
1553: INTO l_primary_unit_of_measure
1554: FROM mtl_system_items
1555: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
1556: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
1557: IF (g_asn_debug = 'Y') THEN
1558: asn_debug.put_line('Primary UOM from RTI :' || x_cascaded_table(n).primary_unit_of_measure);

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

1551: /* BUG 608353 */
1552: SELECT primary_unit_of_measure
1553: INTO l_primary_unit_of_measure
1554: FROM mtl_system_items
1555: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
1556: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
1557: IF (g_asn_debug = 'Y') THEN
1558: asn_debug.put_line('Primary UOM from RTI :' || x_cascaded_table(n).primary_unit_of_measure);
1559: asn_debug.put_line('Derived PRIMARY UOM from MSI:' || l_primary_unit_of_measure);

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

1552: SELECT primary_unit_of_measure
1553: INTO l_primary_unit_of_measure
1554: FROM mtl_system_items
1555: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
1556: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
1557: IF (g_asn_debug = 'Y') THEN
1558: asn_debug.put_line('Primary UOM from RTI :' || x_cascaded_table(n).primary_unit_of_measure);
1559: asn_debug.put_line('Derived PRIMARY UOM from MSI:' || l_primary_unit_of_measure);
1560: END IF;

Line 1599: FROM mtl_system_items

1595: SELECT NVL(x_cascaded_table(n).use_mtl_lot, lot_control_code),
1596: NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
1597: INTO x_cascaded_table(n).use_mtl_lot,
1598: x_cascaded_table(n).use_mtl_serial
1599: FROM mtl_system_items
1600: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
1601: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
1602:
1603: IF (g_asn_debug = 'Y') THEN

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

1596: NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
1597: INTO x_cascaded_table(n).use_mtl_lot,
1598: x_cascaded_table(n).use_mtl_serial
1599: FROM mtl_system_items
1600: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
1601: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
1602:
1603: IF (g_asn_debug = 'Y') THEN
1604: asn_debug.put_line('use_mtl_lot: ' || x_cascaded_table(n).use_mtl_lot);

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

1597: INTO x_cascaded_table(n).use_mtl_lot,
1598: x_cascaded_table(n).use_mtl_serial
1599: FROM mtl_system_items
1600: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
1601: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
1602:
1603: IF (g_asn_debug = 'Y') THEN
1604: asn_debug.put_line('use_mtl_lot: ' || x_cascaded_table(n).use_mtl_lot);
1605: asn_debug.put_line('use_mtl_serial: ' || x_cascaded_table(n).use_mtl_serial);

Line 4318: FROM mtl_system_items

4314: AND temp_cascaded_table(current_n).item_id IS NOT NULL THEN --{
4315: BEGIN
4316: SELECT primary_unit_of_measure
4317: INTO temp_cascaded_table(current_n).primary_unit_of_measure
4318: FROM mtl_system_items
4319: WHERE mtl_system_items.inventory_item_id = temp_cascaded_table(current_n).item_id
4320: AND mtl_system_items.organization_id = temp_cascaded_table(current_n).to_organization_id;
4321:
4322: IF (g_asn_debug = 'Y') THEN

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

4315: BEGIN
4316: SELECT primary_unit_of_measure
4317: INTO temp_cascaded_table(current_n).primary_unit_of_measure
4318: FROM mtl_system_items
4319: WHERE mtl_system_items.inventory_item_id = temp_cascaded_table(current_n).item_id
4320: AND mtl_system_items.organization_id = temp_cascaded_table(current_n).to_organization_id;
4321:
4322: IF (g_asn_debug = 'Y') THEN
4323: asn_debug.put_line('Primary UOM: ' || temp_cascaded_table(current_n).primary_unit_of_measure);

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

4316: SELECT primary_unit_of_measure
4317: INTO temp_cascaded_table(current_n).primary_unit_of_measure
4318: FROM mtl_system_items
4319: WHERE mtl_system_items.inventory_item_id = temp_cascaded_table(current_n).item_id
4320: AND mtl_system_items.organization_id = temp_cascaded_table(current_n).to_organization_id;
4321:
4322: IF (g_asn_debug = 'Y') THEN
4323: asn_debug.put_line('Primary UOM: ' || temp_cascaded_table(current_n).primary_unit_of_measure);
4324: END IF;

Line 7259: mtl_system_items msi

7255:
7256: SELECT NVL(MAX(secondary_inventory_name), 'notfound')
7257: INTO x_subinventory
7258: FROM mtl_secondary_inventories msub,
7259: mtl_system_items msi
7260: WHERE msub.secondary_inventory_name = x_cascaded_table(n).subinventory
7261: AND msub.organization_id = x_cascaded_table(n).to_organization_id
7262: AND x_cascaded_table(n).transaction_date < NVL(msub.disable_date, x_cascaded_table(n).transaction_date + 1)
7263: AND msi.inventory_item_id = x_cascaded_table(n).item_id

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

7766: n IN BINARY_INTEGER
7767: ) IS
7768: location_record rcv_shipment_line_sv.location_record_type;
7769: x_item_id NUMBER;
7770: x_primary_uom mtl_system_items.primary_unit_of_measure%TYPE := NULL;
7771: x_uom_class VARCHAR2(10);
7772: x_uom_count NUMBER(10);
7773: prim_uom_qty NUMBER;
7774: x_error_status VARCHAR2(1);

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

7771: x_uom_class VARCHAR2(10);
7772: x_uom_count NUMBER(10);
7773: prim_uom_qty NUMBER;
7774: x_error_status VARCHAR2(1);
7775: l_item_description mtl_system_items_vl.description%type; --bug 4697949
7776: BEGIN
7777: x_error_status := rcv_error_pkg.g_ret_sts_error;
7778:
7779: -- If substitute item has been specified then we need to switch the item_id with the

Line 7811: FROM mtl_system_items

7807: END IF;
7808:
7809: SELECT MAX(primary_unit_of_measure)
7810: INTO x_primary_uom
7811: FROM mtl_system_items
7812: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
7813: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
7814:
7815: IF x_primary_uom IS NULL THEN

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

7808:
7809: SELECT MAX(primary_unit_of_measure)
7810: INTO x_primary_uom
7811: FROM mtl_system_items
7812: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
7813: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
7814:
7815: IF x_primary_uom IS NULL THEN
7816: IF (g_asn_debug = 'Y') THEN

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

7809: SELECT MAX(primary_unit_of_measure)
7810: INTO x_primary_uom
7811: FROM mtl_system_items
7812: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
7813: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
7814:
7815: IF x_primary_uom IS NULL THEN
7816: IF (g_asn_debug = 'Y') THEN
7817: asn_debug.put_line('No Primary UOM for substitute item');

Line 7853: from mtl_system_items_vl

7849: substitute item*/
7850: BEGIN
7851: select description
7852: into l_item_description
7853: from mtl_system_items_vl
7854: where inventory_item_id = x_cascaded_table(n).substitute_item_id
7855: and organization_id = x_cascaded_table(n).to_organization_id;
7856: EXCEPTION
7857: when others then

Line 11772: FROM mtl_system_items

11768: SELECT NVL(x_cascaded_table(n).use_mtl_lot, lot_control_code),
11769: NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
11770: INTO x_cascaded_table(n).use_mtl_lot,
11771: x_cascaded_table(n).use_mtl_serial
11772: FROM mtl_system_items
11773: WHERE mtl_system_items.inventory_item_id = NVL(x_cascaded_table(n).item_id, 0)
11774: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
11775: END IF;
11776: END Comment: Bug: 4735484

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

11769: NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
11770: INTO x_cascaded_table(n).use_mtl_lot,
11771: x_cascaded_table(n).use_mtl_serial
11772: FROM mtl_system_items
11773: WHERE mtl_system_items.inventory_item_id = NVL(x_cascaded_table(n).item_id, 0)
11774: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
11775: END IF;
11776: END Comment: Bug: 4735484
11777: */

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

11770: INTO x_cascaded_table(n).use_mtl_lot,
11771: x_cascaded_table(n).use_mtl_serial
11772: FROM mtl_system_items
11773: WHERE mtl_system_items.inventory_item_id = NVL(x_cascaded_table(n).item_id, 0)
11774: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
11775: END IF;
11776: END Comment: Bug: 4735484
11777: */
11778: x_cascaded_table(n).interface_source_code := 'RCV';

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

14475: * get the use_mtl_lot and use_mtl_serial.
14476: */
14477: /* Bug 5076685: For one time items, item_id won't be available. We need to
14478: have a check for item_id not null, before hitting the
14479: mtl_system_items table.Added the IF - END IF statement. */
14480: /*
14481: BEGIN Comment: Bug: 4735484
14482: IF x_cascaded_table(n).item_id IS NOT NULL THEN
14483: SELECT NVL(x_cascaded_table(n).use_mtl_lot, lot_control_code),

Line 14487: FROM mtl_system_items

14483: SELECT NVL(x_cascaded_table(n).use_mtl_lot, lot_control_code),
14484: NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
14485: INTO x_cascaded_table(n).use_mtl_lot,
14486: x_cascaded_table(n).use_mtl_serial
14487: FROM mtl_system_items
14488: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
14489: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
14490: END IF;
14491: END Comment: Bug: 4735484

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

14484: NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
14485: INTO x_cascaded_table(n).use_mtl_lot,
14486: x_cascaded_table(n).use_mtl_serial
14487: FROM mtl_system_items
14488: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
14489: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
14490: END IF;
14491: END Comment: Bug: 4735484
14492: */

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

14485: INTO x_cascaded_table(n).use_mtl_lot,
14486: x_cascaded_table(n).use_mtl_serial
14487: FROM mtl_system_items
14488: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
14489: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
14490: END IF;
14491: END Comment: Bug: 4735484
14492: */
14493: END IF;