eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_3PL_BILLING_UNITS_PVT dependencies on MTL_BILLING_RULE_LINES_V

Line 8: v_client_id mtl_billing_rule_lines_v.client_id%type;

4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_3PL_BILLING_UNITS_PVT';
6: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7:
8: v_client_id mtl_billing_rule_lines_v.client_id%type;
9: v_client_code mtl_billing_rule_lines_v.client_code%type;
10: v_client_name mtl_billing_rule_lines_v.client_name%type;
11: v_client_number mtl_billing_rule_lines_v.client_number%type;
12: v_contract_id mtl_billing_rule_lines_v.contract_id%type;

Line 9: v_client_code mtl_billing_rule_lines_v.client_code%type;

5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_3PL_BILLING_UNITS_PVT';
6: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7:
8: v_client_id mtl_billing_rule_lines_v.client_id%type;
9: v_client_code mtl_billing_rule_lines_v.client_code%type;
10: v_client_name mtl_billing_rule_lines_v.client_name%type;
11: v_client_number mtl_billing_rule_lines_v.client_number%type;
12: v_contract_id mtl_billing_rule_lines_v.contract_id%type;
13: v_contract_number mtl_billing_rule_lines_v.contract_number%type;

Line 10: v_client_name mtl_billing_rule_lines_v.client_name%type;

6: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7:
8: v_client_id mtl_billing_rule_lines_v.client_id%type;
9: v_client_code mtl_billing_rule_lines_v.client_code%type;
10: v_client_name mtl_billing_rule_lines_v.client_name%type;
11: v_client_number mtl_billing_rule_lines_v.client_number%type;
12: v_contract_id mtl_billing_rule_lines_v.contract_id%type;
13: v_contract_number mtl_billing_rule_lines_v.contract_number%type;
14: v_counter_item_id mtl_billing_rule_lines_v.counter_item_id%type;

Line 11: v_client_number mtl_billing_rule_lines_v.client_number%type;

7:
8: v_client_id mtl_billing_rule_lines_v.client_id%type;
9: v_client_code mtl_billing_rule_lines_v.client_code%type;
10: v_client_name mtl_billing_rule_lines_v.client_name%type;
11: v_client_number mtl_billing_rule_lines_v.client_number%type;
12: v_contract_id mtl_billing_rule_lines_v.contract_id%type;
13: v_contract_number mtl_billing_rule_lines_v.contract_number%type;
14: v_counter_item_id mtl_billing_rule_lines_v.counter_item_id%type;
15: v_last_computation_Date mtl_billing_rule_lines_v.last_computation_Date%type;

Line 12: v_contract_id mtl_billing_rule_lines_v.contract_id%type;

8: v_client_id mtl_billing_rule_lines_v.client_id%type;
9: v_client_code mtl_billing_rule_lines_v.client_code%type;
10: v_client_name mtl_billing_rule_lines_v.client_name%type;
11: v_client_number mtl_billing_rule_lines_v.client_number%type;
12: v_contract_id mtl_billing_rule_lines_v.contract_id%type;
13: v_contract_number mtl_billing_rule_lines_v.contract_number%type;
14: v_counter_item_id mtl_billing_rule_lines_v.counter_item_id%type;
15: v_last_computation_Date mtl_billing_rule_lines_v.last_computation_Date%type;
16: v_net_Reading mtl_billing_rule_lines_v.net_Reading%type;

Line 13: v_contract_number mtl_billing_rule_lines_v.contract_number%type;

9: v_client_code mtl_billing_rule_lines_v.client_code%type;
10: v_client_name mtl_billing_rule_lines_v.client_name%type;
11: v_client_number mtl_billing_rule_lines_v.client_number%type;
12: v_contract_id mtl_billing_rule_lines_v.contract_id%type;
13: v_contract_number mtl_billing_rule_lines_v.contract_number%type;
14: v_counter_item_id mtl_billing_rule_lines_v.counter_item_id%type;
15: v_last_computation_Date mtl_billing_rule_lines_v.last_computation_Date%type;
16: v_net_Reading mtl_billing_rule_lines_v.net_Reading%type;
17: v_last_reading mtl_billing_rule_lines_v.last_reading%type;

Line 14: v_counter_item_id mtl_billing_rule_lines_v.counter_item_id%type;

10: v_client_name mtl_billing_rule_lines_v.client_name%type;
11: v_client_number mtl_billing_rule_lines_v.client_number%type;
12: v_contract_id mtl_billing_rule_lines_v.contract_id%type;
13: v_contract_number mtl_billing_rule_lines_v.contract_number%type;
14: v_counter_item_id mtl_billing_rule_lines_v.counter_item_id%type;
15: v_last_computation_Date mtl_billing_rule_lines_v.last_computation_Date%type;
16: v_net_Reading mtl_billing_rule_lines_v.net_Reading%type;
17: v_last_reading mtl_billing_rule_lines_v.last_reading%type;
18: v_billing_uom mtl_billing_rule_lines_v.billing_uom%type;

Line 15: v_last_computation_Date mtl_billing_rule_lines_v.last_computation_Date%type;

11: v_client_number mtl_billing_rule_lines_v.client_number%type;
12: v_contract_id mtl_billing_rule_lines_v.contract_id%type;
13: v_contract_number mtl_billing_rule_lines_v.contract_number%type;
14: v_counter_item_id mtl_billing_rule_lines_v.counter_item_id%type;
15: v_last_computation_Date mtl_billing_rule_lines_v.last_computation_Date%type;
16: v_net_Reading mtl_billing_rule_lines_v.net_Reading%type;
17: v_last_reading mtl_billing_rule_lines_v.last_reading%type;
18: v_billing_uom mtl_billing_rule_lines_v.billing_uom%type;
19: v_service_item_org_id mtl_billing_rule_lines_v.service_item_org_id%type;

Line 16: v_net_Reading mtl_billing_rule_lines_v.net_Reading%type;

12: v_contract_id mtl_billing_rule_lines_v.contract_id%type;
13: v_contract_number mtl_billing_rule_lines_v.contract_number%type;
14: v_counter_item_id mtl_billing_rule_lines_v.counter_item_id%type;
15: v_last_computation_Date mtl_billing_rule_lines_v.last_computation_Date%type;
16: v_net_Reading mtl_billing_rule_lines_v.net_Reading%type;
17: v_last_reading mtl_billing_rule_lines_v.last_reading%type;
18: v_billing_uom mtl_billing_rule_lines_v.billing_uom%type;
19: v_service_item_org_id mtl_billing_rule_lines_v.service_item_org_id%type;
20: v_billing_source_id mtl_billing_rule_lines_v.billing_source_id%type;

Line 17: v_last_reading mtl_billing_rule_lines_v.last_reading%type;

13: v_contract_number mtl_billing_rule_lines_v.contract_number%type;
14: v_counter_item_id mtl_billing_rule_lines_v.counter_item_id%type;
15: v_last_computation_Date mtl_billing_rule_lines_v.last_computation_Date%type;
16: v_net_Reading mtl_billing_rule_lines_v.net_Reading%type;
17: v_last_reading mtl_billing_rule_lines_v.last_reading%type;
18: v_billing_uom mtl_billing_rule_lines_v.billing_uom%type;
19: v_service_item_org_id mtl_billing_rule_lines_v.service_item_org_id%type;
20: v_billing_source_id mtl_billing_rule_lines_v.billing_source_id%type;
21: v_billing_source_name mtl_billing_rule_lines_v.billing_source_name%type;

Line 18: v_billing_uom mtl_billing_rule_lines_v.billing_uom%type;

14: v_counter_item_id mtl_billing_rule_lines_v.counter_item_id%type;
15: v_last_computation_Date mtl_billing_rule_lines_v.last_computation_Date%type;
16: v_net_Reading mtl_billing_rule_lines_v.net_Reading%type;
17: v_last_reading mtl_billing_rule_lines_v.last_reading%type;
18: v_billing_uom mtl_billing_rule_lines_v.billing_uom%type;
19: v_service_item_org_id mtl_billing_rule_lines_v.service_item_org_id%type;
20: v_billing_source_id mtl_billing_rule_lines_v.billing_source_id%type;
21: v_billing_source_name mtl_billing_rule_lines_v.billing_source_name%type;
22: v_service_line_start_date mtl_billing_rule_lines_v.service_line_start_date%type;

Line 19: v_service_item_org_id mtl_billing_rule_lines_v.service_item_org_id%type;

15: v_last_computation_Date mtl_billing_rule_lines_v.last_computation_Date%type;
16: v_net_Reading mtl_billing_rule_lines_v.net_Reading%type;
17: v_last_reading mtl_billing_rule_lines_v.last_reading%type;
18: v_billing_uom mtl_billing_rule_lines_v.billing_uom%type;
19: v_service_item_org_id mtl_billing_rule_lines_v.service_item_org_id%type;
20: v_billing_source_id mtl_billing_rule_lines_v.billing_source_id%type;
21: v_billing_source_name mtl_billing_rule_lines_v.billing_source_name%type;
22: v_service_line_start_date mtl_billing_rule_lines_v.service_line_start_date%type;
23: v_service_line_end_date mtl_billing_rule_lines_v.service_line_end_date%type;

Line 20: v_billing_source_id mtl_billing_rule_lines_v.billing_source_id%type;

16: v_net_Reading mtl_billing_rule_lines_v.net_Reading%type;
17: v_last_reading mtl_billing_rule_lines_v.last_reading%type;
18: v_billing_uom mtl_billing_rule_lines_v.billing_uom%type;
19: v_service_item_org_id mtl_billing_rule_lines_v.service_item_org_id%type;
20: v_billing_source_id mtl_billing_rule_lines_v.billing_source_id%type;
21: v_billing_source_name mtl_billing_rule_lines_v.billing_source_name%type;
22: v_service_line_start_date mtl_billing_rule_lines_v.service_line_start_date%type;
23: v_service_line_end_date mtl_billing_rule_lines_v.service_line_end_date%type;
24:

Line 21: v_billing_source_name mtl_billing_rule_lines_v.billing_source_name%type;

17: v_last_reading mtl_billing_rule_lines_v.last_reading%type;
18: v_billing_uom mtl_billing_rule_lines_v.billing_uom%type;
19: v_service_item_org_id mtl_billing_rule_lines_v.service_item_org_id%type;
20: v_billing_source_id mtl_billing_rule_lines_v.billing_source_id%type;
21: v_billing_source_name mtl_billing_rule_lines_v.billing_source_name%type;
22: v_service_line_start_date mtl_billing_rule_lines_v.service_line_start_date%type;
23: v_service_line_end_date mtl_billing_rule_lines_v.service_line_end_date%type;
24:
25:

Line 22: v_service_line_start_date mtl_billing_rule_lines_v.service_line_start_date%type;

18: v_billing_uom mtl_billing_rule_lines_v.billing_uom%type;
19: v_service_item_org_id mtl_billing_rule_lines_v.service_item_org_id%type;
20: v_billing_source_id mtl_billing_rule_lines_v.billing_source_id%type;
21: v_billing_source_name mtl_billing_rule_lines_v.billing_source_name%type;
22: v_service_line_start_date mtl_billing_rule_lines_v.service_line_start_date%type;
23: v_service_line_end_date mtl_billing_rule_lines_v.service_line_end_date%type;
24:
25:
26: PROCEDURE debug(

Line 23: v_service_line_end_date mtl_billing_rule_lines_v.service_line_end_date%type;

19: v_service_item_org_id mtl_billing_rule_lines_v.service_item_org_id%type;
20: v_billing_source_id mtl_billing_rule_lines_v.billing_source_id%type;
21: v_billing_source_name mtl_billing_rule_lines_v.billing_source_name%type;
22: v_service_line_start_date mtl_billing_rule_lines_v.service_line_start_date%type;
23: v_service_line_end_date mtl_billing_rule_lines_v.service_line_end_date%type;
24:
25:
26: PROCEDURE debug(
27: p_message IN VARCHAR2

Line 179: lc_service_item_org_id mtl_billing_rule_lines_v.service_item_org_id%TYPE;

175: lc_counter_item_id mtl_system_items.inventory_item_id%TYPE;
176: lc_net_Reading csi_counter_readings.net_Reading%TYPE;
177: lc_last_reading csi_counter_readings.net_Reading%TYPE;
178: lc_billing_uom mtl_system_items.primary_uom_code%TYPE;
179: lc_service_item_org_id mtl_billing_rule_lines_v.service_item_org_id%TYPE;
180: lc_billing_source_id mtl_billing_sources_b.billing_source_id%TYPE;
181: lc_billing_source_name mtl_billing_sources_tl.name%TYPE;
182: lc_last_computation_Date DATE;
183: lc_service_line_start_date DATE;

Line 514: || 'FROM mtl_billing_rule_lines_v rules '

510: || 'last_computation_Date, net_Reading, last_reading, '
511: || 'billing_uom, service_item_org_id, billing_source_id, '
512: || 'billing_source_name, service_line_start_date, '
513: || 'service_line_end_date '
514: || 'FROM mtl_billing_rule_lines_v rules '
515: || 'WHERE authoring_org_id IN ( SELECT organization_id '
516: || 'FROM hr_operating_units hr '
517: || 'WHERE '
518: || 'mo_global.check_access(hr.organization_id)=''Y'') '