DBA Data[Home] [Help]

APPS.CSM_DEBRIEF_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 11: g_systemitems_table_name CONSTANT VARCHAR2(30) := 'MTL_SYSTEM_ITEMS_B';

7: g_debrief_pk1_name CONSTANT VARCHAR2(30) := 'DEBRIEF_LINE_ID';
8: g_debrief_pubi_name CSM_ACC_PKG.t_publication_item_list;
9: g_labor_billing_type_category CONSTANT VARCHAR2(30) := 'L';
10:
11: g_systemitems_table_name CONSTANT VARCHAR2(30) := 'MTL_SYSTEM_ITEMS_B';
12: g_systemitems_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC';
13: g_systemitems_acc_seq_name CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC_S';
14: g_systemitems_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
15: CSM_ACC_PKG.t_publication_item_list('CSF_M_SYSTEM_ITEMS');

Line 57: mtl_system_items_b msi,

53: CURSOR l_txn_billing_csr(p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE, p_user_id IN NUMBER)
54: IS
55: SELECT cbtc.billing_category
56: FROM csf_debrief_lines lines,
57: mtl_system_items_b msi,
58: cs_txn_billing_types txbt,
59: CS_BILLING_TYPE_CATEGORIES cbtc
60: WHERE lines.debrief_line_id = p_debrief_line_id
61: AND msi.inventory_item_id = lines.inventory_item_id