APPS.CS_CHARGE_DETAILS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1256: MTL_SYSTEM_ITEMS_KFV ITEMS

1252:
1253: CURSOR c_instance IS
1254: SELECT 'Y'
1255: FROM CSI_ITEM_INSTANCES cp,
1256: MTL_SYSTEM_ITEMS_KFV ITEMS
1257: WHERE cp.instance_id = p_instance_id AND
1258: CP.OWNER_PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND
1259: cp.owner_party_id = p_party_id AND
1260: ITEMS.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID AND

Line 13648: FROM MTL_SYSTEM_ITEMS_KFV

13644: serial_number_control_code,
13645: revision_qty_control_code,
13646: nvl(comms_nl_trackable_flag, 'N') comms_nl_trackable_flag
13647: -- contract_item_type_code -- Fix for Bug # 3109160
13648: FROM MTL_SYSTEM_ITEMS_KFV
13649: WHERE organization_id = cs_std.get_item_valdn_orgzn_id
13650: AND inventory_item_id = p_inv_id;
13651:
13652:

Line 13762: FROM MTL_SYSTEM_ITEMS_KFV

13758: AND nvl(bt.end_date_active,sysdate)
13759: AND bt.billing_type = bc.billing_type
13760: AND bt.transaction_type_id = p_txn_type_id
13761: AND bc.billing_type IN (SELECT material_billable_flag
13762: FROM MTL_SYSTEM_ITEMS_KFV
13763: WHERE organization_id = cs_std.get_item_valdn_orgzn_id
13764: AND inventory_item_id = p_inv_id);
13765:
13766:

Line 13831: FROM mtl_system_items_kfv kfv,

13827:
13828: Cursor c_txn_billing_type(p_inventory_item_id IN NUMBER,
13829: p_txn_type_id IN NUMBER) IS
13830: SELECT ctbt.txn_billing_type_id
13831: FROM mtl_system_items_kfv kfv,
13832: cs_txn_billing_types ctbt
13833: WHERE kfv.inventory_item_id = p_inventory_item_id
13834: AND organization_id = cs_std.get_item_valdn_orgzn_id --
13835: AND ctbt.transaction_type_id = p_txn_type_id