eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OM_VALIDATION_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 857: FROM mtl_system_items_vl

853: WHERE claim_id = p_claim_id;
854:
855: CURSOR csr_product_name(cv_item_id IN NUMBER, cv_org_id IN NUMBER) IS
856: SELECT description
857: FROM mtl_system_items_vl
858: WHERE inventory_item_id = cv_item_id
859: AND organization_id = cv_org_id;
860:
861: CURSOR csr_line_old_rate(cv_claim_line_id IN NUMBER) IS

Line 1458: FROM mtl_system_items_vl

1454: WHERE line_id = cv_order_line_id;
1455:
1456: CURSOR csr_product_name(cv_item_id IN NUMBER, cv_org_id IN NUMBER) IS
1457: SELECT description
1458: FROM mtl_system_items_vl
1459: WHERE inventory_item_id = cv_item_id
1460: AND organization_id = cv_org_id;
1461:
1462: i NUMBER;

Line 1594: FROM mtl_system_items_vl

1590: SELECT invoice_enabled_flag
1591: , invoiceable_item_flag
1592: , returnable_flag
1593: , description
1594: FROM mtl_system_items_vl
1595: WHERE inventory_item_id = cv_item_id
1596: AND organization_id = cv_org_id;
1597:
1598: l_csr_item_attr csr_item_attr%ROWTYPE;