DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 407: mtl_system_items_b_kfv msibk,

403: ctst.transaction_type_id transaction_type_id_csi
404: from cs_transaction_types_vl cttv,
405: csi_txn_sub_types ctst,
406: csi_txn_types ctt,
407: mtl_system_items_b_kfv msibk,
408: cs_billing_type_categories cbtc
409: where cttv.transaction_type_id = p_transaction_type_id
410: and msibk.material_billable_flag = cbtc.billing_type
411: and msibk.inventory_item_id = p_inventory_item_id

Line 434: from mtl_system_items

430: where party_site_use_id = p_install_site_id;
431:
432: cursor c_trackable (p_inventory_item_id Number, p_organization_id Number) is
433: select comms_nl_trackable_flag
434: from mtl_system_items
435: where inventory_item_id = p_inventory_item_id
436: and organization_id = p_organization_id;
437:
438: Cursor c_status_meaning(p_code Varchar2) Is