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

Line 141: x_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE := NULL;

137: x_cum_enabled chv_org_options.enable_cum_flag%TYPE := NULL;
138: x_supply_agreement_flag po_headers.supply_agreement_flag%TYPE := NULL;
139: -- x_asl_uom chv_cum_period_items.purchasing_unit_of_measure%type := null;
140: x_asl_uom VARCHAR2(80) := NULL;
141: x_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE := NULL;
142: x_error_status VARCHAR2(1);
143: BEGIN
144: -- check that the uom is valid
145: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 171: FROM mtl_system_items_kfv

167: -- must have a primary uom at this point since the first select stmt succeeded
168:
169: SELECT primary_unit_of_measure
170: INTO x_primary_unit_of_measure
171: FROM mtl_system_items_kfv
172: WHERE inventory_item_id = x_uom_record.item_id
173: AND organization_id = NVL(x_uom_record.to_organization_id, organization_id); -- Raj added as org_id is part of uk
174:
175: IF (NVL(x_uom_record.primary_unit_of_measure, x_primary_unit_of_measure) <> x_primary_unit_of_measure) THEN

Line 294: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;

290: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,
291: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE
292: ) IS -- bug 608353
293: x_progress VARCHAR2(3);
294: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
295: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
296: x_item_id_po po_lines.item_id%TYPE := NULL;
297: x_error_status VARCHAR2(1);
298: BEGIN

Line 295: x_organization_id mtl_system_items.organization_id%TYPE := NULL;

291: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE
292: ) IS -- bug 608353
293: x_progress VARCHAR2(3);
294: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
295: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
296: x_item_id_po po_lines.item_id%TYPE := NULL;
297: x_error_status VARCHAR2(1);
298: BEGIN
299: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 303: FROM mtl_system_items

299: x_error_status := rcv_error_pkg.g_ret_sts_error;
300:
301: SELECT NVL(MAX(inventory_item_id), -9999)
302: INTO x_inventory_item
303: FROM mtl_system_items
304: WHERE inventory_item_id = x_item_id_record.item_id;
305:
306: IF (x_inventory_item = -9999) THEN
307: rcv_error_pkg.set_error_message('RCV_ITEM_ID');

Line 313: FROM mtl_system_items

309: END IF;
310:
311: SELECT NVL(MAX(inventory_item_id), -9999)
312: INTO x_inventory_item
313: FROM mtl_system_items
314: WHERE SYSDATE BETWEEN NVL(start_date_active, SYSDATE - 1) AND NVL(end_date_active, SYSDATE + 1)
315: AND inventory_item_id = x_item_id_record.item_id;
316:
317: IF (x_inventory_item = -9999) THEN

Line 332: FROM mtl_system_items

328: * check for nvl(max(item_id),0).
329: */
330: SELECT NVL(MAX(organization_id), -9999)
331: INTO x_organization_id
332: FROM mtl_system_items
333: WHERE inventory_item_id = x_item_id_record.item_id
334: AND organization_id = NVL(x_item_id_record.to_organization_id, organization_id);
335:
336: IF (x_organization_id = -9999) THEN

Line 438: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;

434: ===========================================================================*/
435: PROCEDURE validate_substitute_item(
436: x_sub_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.sub_item_id_record_type
437: ) IS
438: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
439: x_progress VARCHAR2(3);
440: x_vendor_id po_vendors.vendor_id%TYPE := NULL;
441: x_error_status VARCHAR2(1);
442: BEGIN

Line 447: FROM mtl_system_items

443: x_error_status := rcv_error_pkg.g_ret_sts_error;
444:
445: SELECT NVL(MAX(inventory_item_id), 0)
446: INTO x_inventory_item
447: FROM mtl_system_items
448: WHERE inventory_item_id = x_sub_item_id_record.substitute_item_id
449: AND organization_id = NVL(x_sub_item_id_record.to_organization_id, organization_id);
450:
451: IF (x_inventory_item = 0) THEN

Line 458: FROM mtl_system_items

454: END IF;
455:
456: SELECT NVL(MAX(inventory_item_id), 0)
457: INTO x_inventory_item
458: FROM mtl_system_items
459: WHERE SYSDATE BETWEEN NVL(start_date_active, SYSDATE - 1) AND NVL(end_date_active, SYSDATE + 1)
460: AND inventory_item_id = x_sub_item_id_record.substitute_item_id
461: AND organization_id = NVL(x_sub_item_id_record.to_organization_id, organization_id);
462:

Line 473: FROM mtl_system_items

469: only the value at PO shipments need to be checked instead of the values at the item
470: level or the supplier level. */
471: SELECT NVL(MAX(inventory_item_id), 0)
472: INTO x_inventory_item
473: FROM mtl_system_items
474: WHERE inventory_item_id = x_sub_item_id_record.substitute_item_id
475: AND organization_id = NVL(x_sub_item_id_record.to_organization_id, organization_id);
476:
477: IF (x_inventory_item = 0) THEN

Line 484: FROM mtl_system_items

480: END IF;
481:
482: SELECT NVL(MAX(inventory_item_id), 0)
483: INTO x_inventory_item
484: FROM mtl_system_items
485: WHERE inventory_item_id = x_sub_item_id_record.substitute_item_id
486: AND organization_id = NVL(x_sub_item_id_record.to_organization_id, organization_id)
487: AND purchasing_item_flag = 'Y';
488:

Line 496: FROM mtl_system_items

492: END IF;
493:
494: SELECT NVL(MAX(inventory_item_id), 0)
495: INTO x_inventory_item
496: FROM mtl_system_items
497: WHERE inventory_item_id = x_sub_item_id_record.substitute_item_id
498: AND organization_id = NVL(x_sub_item_id_record.to_organization_id, organization_id)
499: AND purchasing_enabled_flag = 'Y';
500:

Line 578: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;

574: ===========================================================================*/
575: PROCEDURE validate_item_revision(
576: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
577: ) IS
578: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
579: x_progress VARCHAR2(3);
580: x_revision_control_flag VARCHAR2(1);
581: x_error_status VARCHAR2(1);
582: BEGIN

Line 594: FROM mtl_system_items msi

590: 2, 'Y',
591: 'N'
592: )
593: INTO x_revision_control_flag
594: FROM mtl_system_items msi
595: WHERE inventory_item_id = x_item_revision_record.item_id
596: AND organization_id = x_item_revision_record.to_organization_id;
597:
598: IF x_revision_control_flag = 'N' THEN

Line 1174: mtl_system_items msi

1170:
1171: SELECT NVL(MAX(secondary_inventory_name), 'notfound')
1172: INTO x_subinventory
1173: FROM mtl_secondary_inventories msub,
1174: mtl_system_items msi
1175: WHERE msub.secondary_inventory_name = x_subinventory_record.subinventory
1176: AND msub.organization_id = x_subinventory_record.to_organization_id
1177: AND x_subinventory_record.transaction_date < NVL(msub.disable_date, x_subinventory_record.transaction_date + 1)
1178: AND msi.inventory_item_id = x_subinventory_record.item_id

Line 1752: FROM mtl_system_items_b

1748:
1749: -------Checking if the item is dual UOM controlled. If not then Return .
1750: SELECT tracking_quantity_ind , secondary_default_ind
1751: INTO l_TRACKING_QUANTITY_IND ,l_secondary_default_ind
1752: FROM mtl_system_items_b
1753: WHERE INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
1754: AND ORGANIZATION_ID = x_att_rec.to_organization_id;
1755:
1756: l_progress :='0004';

Line 1839: FROM MTL_SYSTEM_ITEMS_B

1835: BEGIN
1836:
1837: SELECT SECONDARY_UOM_CODE
1838: INTO l_secondary_uom_code
1839: FROM MTL_SYSTEM_ITEMS_B
1840: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
1841: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = x_att_rec.to_organization_id;
1842:
1843: IF g_asn_debug = 'Y' THEN

Line 1840: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID = x_att_rec.inventory_item_id

1836:
1837: SELECT SECONDARY_UOM_CODE
1838: INTO l_secondary_uom_code
1839: FROM MTL_SYSTEM_ITEMS_B
1840: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
1841: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = x_att_rec.to_organization_id;
1842:
1843: IF g_asn_debug = 'Y' THEN
1844: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );

Line 1841: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = x_att_rec.to_organization_id;

1837: SELECT SECONDARY_UOM_CODE
1838: INTO l_secondary_uom_code
1839: FROM MTL_SYSTEM_ITEMS_B
1840: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
1841: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = x_att_rec.to_organization_id;
1842:
1843: IF g_asn_debug = 'Y' THEN
1844: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );
1845: END IF;

Line 1896: FROM MTL_SYSTEM_ITEMS_B

1892: BEGIN
1893:
1894: SELECT SECONDARY_UOM_CODE
1895: INTO x_att_rec.secondary_uom_code
1896: FROM MTL_SYSTEM_ITEMS_B
1897: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1898: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1899:
1900: IF g_asn_debug = 'Y' THEN

Line 1897: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id

1893:
1894: SELECT SECONDARY_UOM_CODE
1895: INTO x_att_rec.secondary_uom_code
1896: FROM MTL_SYSTEM_ITEMS_B
1897: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1898: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1899:
1900: IF g_asn_debug = 'Y' THEN
1901: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code ||':'||l_progress);

Line 1898: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;

1894: SELECT SECONDARY_UOM_CODE
1895: INTO x_att_rec.secondary_uom_code
1896: FROM MTL_SYSTEM_ITEMS_B
1897: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1898: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1899:
1900: IF g_asn_debug = 'Y' THEN
1901: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code ||':'||l_progress);
1902: END IF;

Line 1954: FROM MTL_SYSTEM_ITEMS_B

1950: BEGIN
1951:
1952: SELECT SECONDARY_UOM_CODE
1953: INTO x_att_rec.secondary_uom_code
1954: FROM MTL_SYSTEM_ITEMS_B
1955: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1956: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1957:
1958: IF g_asn_debug = 'Y' THEN

Line 1955: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id

1951:
1952: SELECT SECONDARY_UOM_CODE
1953: INTO x_att_rec.secondary_uom_code
1954: FROM MTL_SYSTEM_ITEMS_B
1955: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1956: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1957:
1958: IF g_asn_debug = 'Y' THEN
1959: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code||':'||l_progress );

Line 1956: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;

1952: SELECT SECONDARY_UOM_CODE
1953: INTO x_att_rec.secondary_uom_code
1954: FROM MTL_SYSTEM_ITEMS_B
1955: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1956: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1957:
1958: IF g_asn_debug = 'Y' THEN
1959: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code||':'||l_progress );
1960: END IF;

Line 1992: FROM MTL_SYSTEM_ITEMS_B

1988: BEGIN
1989:
1990: SELECT SECONDARY_UOM_CODE
1991: INTO l_secondary_uom_code
1992: FROM MTL_SYSTEM_ITEMS_B
1993: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1994: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1995:
1996: IF g_asn_debug = 'Y' THEN

Line 1993: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id

1989:
1990: SELECT SECONDARY_UOM_CODE
1991: INTO l_secondary_uom_code
1992: FROM MTL_SYSTEM_ITEMS_B
1993: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1994: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1995:
1996: IF g_asn_debug = 'Y' THEN
1997: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );

Line 1994: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;

1990: SELECT SECONDARY_UOM_CODE
1991: INTO l_secondary_uom_code
1992: FROM MTL_SYSTEM_ITEMS_B
1993: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1994: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1995:
1996: IF g_asn_debug = 'Y' THEN
1997: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );
1998: END IF;