DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1499: MTL_SYSTEM_ITEMS_KFV sys,

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

Line 2286: from MTL_SYSTEM_ITEMS_KFV MTL,

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;

Line 2299: from MTL_SYSTEM_ITEMS_KFV

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';