APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on MTL_ITEM_UOMS_VIEW

Line 2909: -- check to see if unit_meas_lookup_code is valid in mtl_item_uoms_view

2905: -- b) FND_MSG_PUB on unhandled exceptions.
2906: --Locks:
2907: -- None.
2908: --Function:
2909: -- check to see if unit_meas_lookup_code is valid in mtl_item_uoms_view
2910: --Parameters:
2911: --IN:
2912: --p_key
2913: -- Key used to access records in PO_SESSION_GT table.

Line 3073: -- in MTL_ITEM_UOMS_VIEW.

3069: END LOOP;
3070:
3071: l_progress := '070';
3072: -- SQL What: Bulk validate UOM. Check if unit_meas_lookup_code is valid
3073: -- in MTL_ITEM_UOMS_VIEW.
3074: -- Insert the error rows into GT table.
3075: -- SQL Why : It will be used to mark the record in plsql table as error.
3076: -- SQL Join: item_id, unit_of_measure, inv_org_id
3077: FORALL i IN 1 .. p_lines_rec.item_id.COUNT

Line 3097: FROM MTL_ITEM_UOMS_VIEW MIUV

3093: AND p_lines_rec.unit_of_measure(i) is not null
3094: AND p_lines_rec.uom_code(i) is not null
3095: AND ( (p_lines_rec.item_id(i) is not null
3096: AND NOT EXISTS (SELECT 1
3097: FROM MTL_ITEM_UOMS_VIEW MIUV
3098: WHERE MIUV.inventory_item_id = p_lines_rec.item_id(i)
3099: AND MIUV.organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id
3100: AND MIUV.unit_of_measure = p_lines_rec.unit_of_measure(i)))
3101: OR

Line 4056: -- check to see if unit_meas_lookup_code is valid in mtl_item_uoms_view

4052: p_lines_rec => p_lines_rec
4053: );
4054:
4055: l_progress := '050';
4056: -- check to see if unit_meas_lookup_code is valid in mtl_item_uoms_view
4057: validate_uom
4058: (
4059: p_key => l_key,
4060: p_lines_rec => p_lines_rec