APPS.RCV_PROCESSOR_PVT dependencies on MTL_SYSTEM_ITEMS

Line 225: FROM mtl_system_items

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

Line 226: WHERE mtl_system_items.inventory_item_id = l_item_id

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

Line 227: AND mtl_system_items.organization_id = l_to_org_id;

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

Line 1080: FROM mtl_system_items

1076: END IF;
1077:
1078: SELECT MAX(primary_unit_of_measure)
1079: INTO l_primary_uom
1080: FROM mtl_system_items
1081: WHERE mtl_system_items.inventory_item_id = l_item_id
1082: AND mtl_system_items.organization_id = l_to_org_id;
1083:
1084: IF (g_asn_debug = 'Y') THEN

Line 1081: WHERE mtl_system_items.inventory_item_id = l_item_id

1077:
1078: SELECT MAX(primary_unit_of_measure)
1079: INTO l_primary_uom
1080: FROM mtl_system_items
1081: WHERE mtl_system_items.inventory_item_id = l_item_id
1082: AND mtl_system_items.organization_id = l_to_org_id;
1083:
1084: IF (g_asn_debug = 'Y') THEN
1085: asn_debug.put_line('l_primary_uom ' || l_primary_uom);

Line 1082: AND mtl_system_items.organization_id = l_to_org_id;

1078: SELECT MAX(primary_unit_of_measure)
1079: INTO l_primary_uom
1080: FROM mtl_system_items
1081: WHERE mtl_system_items.inventory_item_id = l_item_id
1082: AND mtl_system_items.organization_id = l_to_org_id;
1083:
1084: IF (g_asn_debug = 'Y') THEN
1085: asn_debug.put_line('l_primary_uom ' || l_primary_uom);
1086: END IF;

Line 1174: FROM mtl_system_items

1170: * shipment_header_id.
1171: */
1172: SELECT MAX(primary_unit_of_measure)
1173: INTO l_primary_uom
1174: FROM mtl_system_items
1175: WHERE mtl_system_items.inventory_item_id = l_item_id
1176: AND mtl_system_items.organization_id = l_to_org_id;
1177:
1178: /* l_qty_to_be_updated shd be in

Line 1175: WHERE mtl_system_items.inventory_item_id = l_item_id

1171: */
1172: SELECT MAX(primary_unit_of_measure)
1173: INTO l_primary_uom
1174: FROM mtl_system_items
1175: WHERE mtl_system_items.inventory_item_id = l_item_id
1176: AND mtl_system_items.organization_id = l_to_org_id;
1177:
1178: /* l_qty_to_be_updated shd be in
1179: * terms of the parent's uom. For

Line 1176: AND mtl_system_items.organization_id = l_to_org_id;

1172: SELECT MAX(primary_unit_of_measure)
1173: INTO l_primary_uom
1174: FROM mtl_system_items
1175: WHERE mtl_system_items.inventory_item_id = l_item_id
1176: AND mtl_system_items.organization_id = l_to_org_id;
1177:
1178: /* l_qty_to_be_updated shd be in
1179: * terms of the parent's uom. For
1180: * shipment supply qty, it must be