1495: sys.description LineDescription,
1496: ln.lse_id LseID,
1497: itm.number_of_items Quantity
1498: FROM
1499: MTL_SYSTEM_ITEMS_KFV sys,
1500: okc_k_items itm,
1501: okc_k_lines_v ln
1502: WHERE
1503: ln.DNZ_CHR_ID=p_contract_id
2282: p_itm_obj2_arg VARCHAR2
2283: )
2284: IS
2285: select MTL.concatenated_segments
2286: from MTL_SYSTEM_ITEMS_KFV MTL,
2287: CSI_ITEM_INSTANCES CSI
2288: where csi.instance_id = p_itm_obj1_arg
2289: and mtl.inventory_item_id = csi.inventory_item_id
2290: and mtl.organization_id =csi.inv_master_organization_id;
2295: )
2296: IS
2297:
2298: select concatenated_segments
2299: from MTL_SYSTEM_ITEMS_KFV
2300: where
2301: inventory_item_id = to_number(p_itm_obj1_arg)
2302: and organization_id = to_number(p_itm_obj2_arg)
2303: and serviceable_product_flag='Y';