APPS.INV_RCV_TXN_MATCH dependencies on MTL_SYSTEM_ITEMS

Line 1000: OR ( exists (SELECT 1 FROM mtl_system_items

996: -- 12546176 added condition for requistion
997: AND ( --9229228-Added this AND condition for lot.
998: v_lot_number IS NULL
999: -- 12814511 Added OR condition in cursor for plain item in source org
1000: OR ( exists (SELECT 1 FROM mtl_system_items
1001: WHERE inventory_item_id = v_item_id
1002: AND LOT_CONTROL_CODE = 1
1003: AND ORGANIZATION_ID = rsl.FROM_ORGANIZATION_ID )
1004: OR EXISTS (SELECT lot_num

Line 1097: OR ( exists (SELECT 1 FROM mtl_system_items

1093:
1094: AND ( --9229228-Added this AND condition for lot.
1095: v_lot_number IS NULL
1096: -- 12814511 Added OR condition in the count cursor for plain item in source org
1097: OR ( exists (SELECT 1 FROM mtl_system_items
1098: WHERE inventory_item_id = v_item_id
1099: AND LOT_CONTROL_CODE = 1
1100: AND ORGANIZATION_ID = rsl.FROM_ORGANIZATION_ID )
1101: OR EXISTS (SELECT lot_num

Line 1299: exists (SELECT 1 FROM mtl_system_items

1295: AND RSH.SHIPMENT_HEADER_ID = RSUP.SHIPMENT_HEADER_ID
1296: AND (
1297: v_lot_number IS NULL
1298: OR(
1299: exists (SELECT 1 FROM mtl_system_items
1300: WHERE inventory_item_id = v_item_id
1301: AND LOT_CONTROL_CODE = 1
1302: AND ORGANIZATION_ID = rsup.FROM_ORGANIZATION_ID )
1303: OR EXISTS

Line 1380: exists (SELECT 1 FROM mtl_system_items

1376: AND RSH.SHIPMENT_HEADER_ID = RSUP.shipment_header_id
1377: AND (
1378: v_lot_number IS NULL
1379: OR(
1380: exists (SELECT 1 FROM mtl_system_items
1381: WHERE inventory_item_id = v_item_id
1382: AND LOT_CONTROL_CODE = 1
1383: AND ORGANIZATION_ID = rsup.FROM_ORGANIZATION_ID )
1384: OR EXISTS

Line 3080: FROM mtl_system_items

3076: IF x_cascaded_table(n).item_id IS NOT NULL THEN
3077: BEGIN
3078: SELECT primary_unit_of_measure
3079: INTO temp_cascaded_table(current_n).primary_unit_of_measure
3080: FROM mtl_system_items
3081: WHERE mtl_system_items.inventory_item_id =
3082: temp_cascaded_table(current_n).item_id
3083: AND mtl_system_items.organization_id =
3084: temp_cascaded_table(current_n).to_organization_id;

Line 3081: WHERE mtl_system_items.inventory_item_id =

3077: BEGIN
3078: SELECT primary_unit_of_measure
3079: INTO temp_cascaded_table(current_n).primary_unit_of_measure
3080: FROM mtl_system_items
3081: WHERE mtl_system_items.inventory_item_id =
3082: temp_cascaded_table(current_n).item_id
3083: AND mtl_system_items.organization_id =
3084: temp_cascaded_table(current_n).to_organization_id;
3085: EXCEPTION

Line 3083: AND mtl_system_items.organization_id =

3079: INTO temp_cascaded_table(current_n).primary_unit_of_measure
3080: FROM mtl_system_items
3081: WHERE mtl_system_items.inventory_item_id =
3082: temp_cascaded_table(current_n).item_id
3083: AND mtl_system_items.organization_id =
3084: temp_cascaded_table(current_n).to_organization_id;
3085: EXCEPTION
3086: WHEN no_data_found THEN
3087: temp_cascaded_table(current_n).error_status := 'W';