DBA Data[Home] [Help]

APPS.OKL_COPY_CONTRACT_PVT dependencies on MTL_SYSTEM_ITEMS

Line 11085: -- Query from mtl_system_items

11081: SELECT id INTO l_34_id
11082: FROM okc_k_lines_b
11083: WHERE cle_id = l_curr_id
11084: AND lse_id = 34;
11085: -- Query from mtl_system_items
11086: SELECT a.asset_category_id
11087: INTO l_asset_category_id
11088: FROM mtl_system_items a,
11089: okc_k_items b

Line 11088: FROM mtl_system_items a,

11084: AND lse_id = 34;
11085: -- Query from mtl_system_items
11086: SELECT a.asset_category_id
11087: INTO l_asset_category_id
11088: FROM mtl_system_items a,
11089: okc_k_items b
11090: WHERE a.inventory_item_id = TO_NUMBER(b.object1_id1)
11091: AND a.organization_id = TO_NUMBER(b.object1_id2)
11092: AND b.cle_id = l_34_id;