APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on MTL_SYSTEM_ITEMS

Line 631: item_id mtl_system_items.inventory_item_id%type,

627: FROM okc_k_headers_v
628: WHERE id = p_chr_id;
629:
630: TYPE srv_okl_rec_type IS RECORD (
631: item_id mtl_system_items.inventory_item_id%type,
632: item_name mtl_system_items.description%type,
633: price_negotiated okc_k_lines_v.price_negotiated%type,
634: fin_line_id okc_k_lines_v.id%type,
635: asset_number okc_k_lines_v.name%type,

Line 632: item_name mtl_system_items.description%type,

628: WHERE id = p_chr_id;
629:
630: TYPE srv_okl_rec_type IS RECORD (
631: item_id mtl_system_items.inventory_item_id%type,
632: item_name mtl_system_items.description%type,
633: price_negotiated okc_k_lines_v.price_negotiated%type,
634: fin_line_id okc_k_lines_v.id%type,
635: asset_number okc_k_lines_v.name%type,
636: okl_no_of_item number,

Line 660: mtl_system_items_b okl_mtl,

656: okc_line_styles_b srv_style,
657: okc_k_items srv_item,
658: okx_customer_products_v srv_prod,
659: okc_k_items okl_item,
660: mtl_system_items_b okl_mtl,
661: okc_k_lines_b okl_item_line,
662: okc_k_lines_v okl_fin_line,
663: okc_line_styles_b okl_style
664: WHERE srv_line.lse_id = srv_style.id

Line 948: -- create item line to link TOP line, created above, to MTL_SYSTEM_ITEMS

944: END IF;
945:
946: x_cle_id := x_clev_rec.id;
947:
948: -- create item line to link TOP line, created above, to MTL_SYSTEM_ITEMS
949:
950: OPEN item_csr (p_oks_service_line_id);
951: FETCH item_csr INTO l_inv_item_id,
952: l_inv_org_id,

Line 3124: FROM mtl_system_items

3120:
3121: CURSOR mtl_csr (p_inv_id NUMBER,
3122: p_org_id NUMBER) IS
3123: SELECT description
3124: FROM mtl_system_items
3125: WHERE inventory_item_id = p_inv_id
3126: AND organization_id = p_org_id;
3127:
3128: l_oks_chr_id OKC_K_HEADERS_B.ID%TYPE;