APPS.CS_CHARGE_DETAILS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1295: MTL_SYSTEM_ITEMS_KFV ITEMS

1291:
1292: CURSOR c_instance IS
1293: SELECT 'Y'
1294: FROM CSI_ITEM_INSTANCES cp,
1295: MTL_SYSTEM_ITEMS_KFV ITEMS
1296: WHERE cp.instance_id = p_instance_id AND
1297: CP.OWNER_PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND
1298: -- cp.owner_party_id = p_party_id AND Commented for bug 8552188
1299: ITEMS.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID AND

Line 15185: FROM MTL_SYSTEM_ITEMS_KFV

15181: serial_number_control_code,
15182: revision_qty_control_code,
15183: nvl(comms_nl_trackable_flag, 'N') comms_nl_trackable_flag
15184: -- contract_item_type_code -- Fix for Bug # 3109160
15185: FROM MTL_SYSTEM_ITEMS_KFV
15186: WHERE organization_id = cs_std.get_item_valdn_orgzn_id
15187: AND inventory_item_id = p_inv_id;
15188:
15189:

Line 15299: FROM MTL_SYSTEM_ITEMS_KFV

15295: AND nvl(bt.end_date_active,sysdate)
15296: AND bt.billing_type = bc.billing_type
15297: AND bt.transaction_type_id = p_txn_type_id
15298: AND bc.billing_type IN (SELECT material_billable_flag
15299: FROM MTL_SYSTEM_ITEMS_KFV
15300: WHERE organization_id = cs_std.get_item_valdn_orgzn_id
15301: AND inventory_item_id = p_inv_id);
15302:
15303:

Line 15368: FROM mtl_system_items_kfv kfv,

15364:
15365: Cursor c_txn_billing_type(p_inventory_item_id IN NUMBER,
15366: p_txn_type_id IN NUMBER) IS
15367: SELECT ctbt.txn_billing_type_id
15368: FROM mtl_system_items_kfv kfv,
15369: cs_txn_billing_types ctbt
15370: WHERE kfv.inventory_item_id = p_inventory_item_id
15371: AND organization_id = cs_std.get_item_valdn_orgzn_id --
15372: AND ctbt.transaction_type_id = p_txn_type_id