DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on CS_TRANSACTION_TYPES

Line 337: from cs_transaction_types_vl cttv,

333: cttv.transaction_type_id ,
334: ctbt.billing_type,
335: ctst.sub_type_id ,
336: ctst.transaction_type_id transaction_type_id_csi
337: from cs_transaction_types_vl cttv,
338: cs_txn_billing_types ctbt,
339: csi_txn_sub_types ctst,
340: csi_txn_types ctt
341: where cttv.transaction_type_id = ctbt.transaction_type_id

Line 350: from cs_transaction_types

346: --hehxx added create_cost and create_charge flags
347: cursor c_cost_charge_flags (p_transaction_type_id number) is
348: select create_cost_flag,
349: create_charge_flag
350: from cs_transaction_types
351: where transaction_type_id = p_transaction_type_id;
352:
353: cursor c_trans (p_transaction_type_id number,
354: p_inventory_item_id number,

Line 361: from cs_transaction_types_vl cttv,

357: ctbt.txn_billing_type_id ,
358: cbtc.billing_category billing_type,
359: ctst.sub_type_id ,
360: ctst.transaction_type_id transaction_type_id_csi
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,