DBA Data[Home] [Help]

APPS.OKS_BILL_REC_PUB dependencies on MTL_SYSTEM_ITEMS

Line 370: ,mtl_system_items mtl

366:
367: CURSOR inv_item_csr(p_cle_id IN NUMBER) Is
368: SELECT primary_uom_code
369: FROM Okc_K_items Item
370: ,mtl_system_items mtl
371: ,okc_k_lines_b line
372: ,okc_k_headers_b hdr
373: WHERE item.cle_id = p_cle_id
374: AND line.id = item.cle_id

Line 906: ,mtl_system_items_b mtl --Okx_system_items_v mtl

902: CURSOR l_inv_item_csr(p_cle_id Number) Is
903: SELECT mtl.primary_uom_code,
904: line.dnz_chr_id
905: FROM Okc_K_items Item
906: ,mtl_system_items_b mtl --Okx_system_items_v mtl
907: ,okc_k_headers_b hdr
908: ,okc_k_lines_b line
909: WHERE item.cle_id = line.id --p_cle_id
910: AND line.id = p_cle_id

Line 7805: mtl_system_items_b mtl

7801: Select item.Object1_id1,
7802: mtl.usage_item_flag,
7803: mtl.service_item_flag
7804: From Okc_K_items Item,
7805: mtl_system_items_b mtl
7806: Where item.cle_id = p_cle_id
7807: And mtl.inventory_item_id = item.object1_id1;
7808:
7809: Cursor l_usage_csr(p_id Number)