APPS.RCV_PROCESSOR_PVT dependencies on MTL_SYSTEM_ITEMS

Line 224: FROM mtl_system_items

220: END IF;
221:
222: SELECT MAX(primary_unit_of_measure)
223: INTO l_primary_uom
224: FROM mtl_system_items
225: WHERE mtl_system_items.inventory_item_id = l_item_id
226: AND mtl_system_items.organization_id = l_to_org_id;
227:
228: IF (g_asn_debug = 'Y') THEN

Line 225: WHERE mtl_system_items.inventory_item_id = l_item_id

221:
222: SELECT MAX(primary_unit_of_measure)
223: INTO l_primary_uom
224: FROM mtl_system_items
225: WHERE mtl_system_items.inventory_item_id = l_item_id
226: AND mtl_system_items.organization_id = l_to_org_id;
227:
228: IF (g_asn_debug = 'Y') THEN
229: asn_debug.put_line('l_primary_uom ' || l_primary_uom);

Line 226: AND mtl_system_items.organization_id = l_to_org_id;

222: SELECT MAX(primary_unit_of_measure)
223: INTO l_primary_uom
224: FROM mtl_system_items
225: WHERE mtl_system_items.inventory_item_id = l_item_id
226: AND mtl_system_items.organization_id = l_to_org_id;
227:
228: IF (g_asn_debug = 'Y') THEN
229: asn_debug.put_line('l_primary_uom ' || l_primary_uom);
230: END IF;

Line 1074: FROM mtl_system_items

1070: END IF;
1071:
1072: SELECT MAX(primary_unit_of_measure)
1073: INTO l_primary_uom
1074: FROM mtl_system_items
1075: WHERE mtl_system_items.inventory_item_id = l_item_id
1076: AND mtl_system_items.organization_id = l_to_org_id;
1077:
1078: IF (g_asn_debug = 'Y') THEN

Line 1075: WHERE mtl_system_items.inventory_item_id = l_item_id

1071:
1072: SELECT MAX(primary_unit_of_measure)
1073: INTO l_primary_uom
1074: FROM mtl_system_items
1075: WHERE mtl_system_items.inventory_item_id = l_item_id
1076: AND mtl_system_items.organization_id = l_to_org_id;
1077:
1078: IF (g_asn_debug = 'Y') THEN
1079: asn_debug.put_line('l_primary_uom ' || l_primary_uom);

Line 1076: AND mtl_system_items.organization_id = l_to_org_id;

1072: SELECT MAX(primary_unit_of_measure)
1073: INTO l_primary_uom
1074: FROM mtl_system_items
1075: WHERE mtl_system_items.inventory_item_id = l_item_id
1076: AND mtl_system_items.organization_id = l_to_org_id;
1077:
1078: IF (g_asn_debug = 'Y') THEN
1079: asn_debug.put_line('l_primary_uom ' || l_primary_uom);
1080: END IF;

Line 1168: FROM mtl_system_items

1164: * shipment_header_id.
1165: */
1166: SELECT MAX(primary_unit_of_measure)
1167: INTO l_primary_uom
1168: FROM mtl_system_items
1169: WHERE mtl_system_items.inventory_item_id = l_item_id
1170: AND mtl_system_items.organization_id = l_to_org_id;
1171:
1172: /* l_qty_to_be_updated shd be in

Line 1169: WHERE mtl_system_items.inventory_item_id = l_item_id

1165: */
1166: SELECT MAX(primary_unit_of_measure)
1167: INTO l_primary_uom
1168: FROM mtl_system_items
1169: WHERE mtl_system_items.inventory_item_id = l_item_id
1170: AND mtl_system_items.organization_id = l_to_org_id;
1171:
1172: /* l_qty_to_be_updated shd be in
1173: * terms of the parent's uom. For

Line 1170: AND mtl_system_items.organization_id = l_to_org_id;

1166: SELECT MAX(primary_unit_of_measure)
1167: INTO l_primary_uom
1168: FROM mtl_system_items
1169: WHERE mtl_system_items.inventory_item_id = l_item_id
1170: AND mtl_system_items.organization_id = l_to_org_id;
1171:
1172: /* l_qty_to_be_updated shd be in
1173: * terms of the parent's uom. For
1174: * shipment supply qty, it must be