APPS.OZF_OM_VALIDATION_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 798: FROM mtl_system_items_vl

794: WHERE claim_id = p_claim_id;
795:
796: CURSOR csr_product_name(cv_item_id IN NUMBER, cv_org_id IN NUMBER) IS
797: SELECT description
798: FROM mtl_system_items_vl
799: WHERE inventory_item_id = cv_item_id
800: AND organization_id = cv_org_id;
801:
802: CURSOR csr_line_old_rate(cv_claim_line_id IN NUMBER) IS

Line 1396: FROM mtl_system_items_vl

1392: WHERE line_id = cv_order_line_id;
1393:
1394: CURSOR csr_product_name(cv_item_id IN NUMBER, cv_org_id IN NUMBER) IS
1395: SELECT description
1396: FROM mtl_system_items_vl
1397: WHERE inventory_item_id = cv_item_id
1398: AND organization_id = cv_org_id;
1399:
1400: i NUMBER;

Line 1532: FROM mtl_system_items_vl

1528: SELECT invoice_enabled_flag
1529: , invoiceable_item_flag
1530: , returnable_flag
1531: , description
1532: FROM mtl_system_items_vl
1533: WHERE inventory_item_id = cv_item_id
1534: AND organization_id = cv_org_id;
1535:
1536: l_csr_item_attr csr_item_attr%ROWTYPE;