DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 365: mtl_system_items_b_kfv msibk,

361: from cs_transaction_types_vl cttv,
362: cs_txn_billing_types ctbt,
363: csi_txn_sub_types ctst,
364: csi_txn_types ctt,
365: mtl_system_items_b_kfv msibk,
366: cs_billing_type_categories cbtc
367: where cttv.transaction_type_id = p_transaction_type_id
368: and cttv.transaction_type_id = ctbt.transaction_type_id
369: and ctbt.billing_type = msibk.material_billable_flag

Line 394: from mtl_system_items

390: where party_site_use_id = p_install_site_id;
391:
392: cursor c_trackable (p_inventory_item_id Number, p_organization_id Number) is -- changed for bug 3897985
393: select comms_nl_trackable_flag
394: from mtl_system_items
395: where inventory_item_id = p_inventory_item_id
396: and organization_id = p_organization_id;
397:
398: Cursor c_status_meaning(p_code Varchar2) Is