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.ARP_AUTO_ACCOUNTING dependencies on MTL_SYSTEM_ITEMS

Line 222: inventory_item_id mtl_system_items.inventory_item_id%TYPE,

218: --
219: -- inv_item cache
220: --
221: TYPE inv_item_rec_type IS RECORD (
222: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
223: warehouse_id mtl_system_items.organization_id%TYPE ,
224: item_type mtl_system_items.item_type%TYPE,
225: sales_account mtl_system_items.sales_account%TYPE
226: );

Line 223: warehouse_id mtl_system_items.organization_id%TYPE ,

219: -- inv_item cache
220: --
221: TYPE inv_item_rec_type IS RECORD (
222: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
223: warehouse_id mtl_system_items.organization_id%TYPE ,
224: item_type mtl_system_items.item_type%TYPE,
225: sales_account mtl_system_items.sales_account%TYPE
226: );
227:

Line 224: item_type mtl_system_items.item_type%TYPE,

220: --
221: TYPE inv_item_rec_type IS RECORD (
222: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
223: warehouse_id mtl_system_items.organization_id%TYPE ,
224: item_type mtl_system_items.item_type%TYPE,
225: sales_account mtl_system_items.sales_account%TYPE
226: );
227:
228: TYPE inv_item_rev_table_type IS

Line 225: sales_account mtl_system_items.sales_account%TYPE

221: TYPE inv_item_rec_type IS RECORD (
222: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
223: warehouse_id mtl_system_items.organization_id%TYPE ,
224: item_type mtl_system_items.item_type%TYPE,
225: sales_account mtl_system_items.sales_account%TYPE
226: );
227:
228: TYPE inv_item_rev_table_type IS
229: TABLE OF inv_item_rec_type

Line 1426: -- Retrieves default ccids from the table mtl_system_items

1422: --
1423: -- PROCEDURE NAME: get_inv_item_ccids
1424: --
1425: -- DECSRIPTION:
1426: -- Retrieves default ccids from the table mtl_system_items
1427: -- for a given item_id.
1428: --
1429: -- ARGUMENTS:
1430: -- IN:

Line 1451: mtl_system_items.item_type%TYPE ) IS

1447: p_inv_item_id IN BINARY_INTEGER,
1448: p_warehouse_id IN BINARY_INTEGER,
1449: p_ccid_rev IN OUT NOCOPY BINARY_INTEGER,
1450: p_inv_item_type IN OUT NOCOPY
1451: mtl_system_items.item_type%TYPE ) IS
1452: l_ctr BINARY_INTEGER;
1453: l_hit BOOLEAN := FALSE;
1454: t_warehouse_id BINARY_INTEGER;
1455:

Line 1515: FROM mtl_system_items

1511:
1512: SELECT nvl(sales_account, -1), nvl(item_type, '~')
1513: INTO p_ccid_rev,
1514: p_inv_item_type
1515: FROM mtl_system_items
1516: WHERE organization_id
1517: = t_warehouse_id
1518: AND inventory_item_id = p_inv_item_id;
1519:

Line 4145: mtl_system_items.item_type%TYPE ) IS

4141: p_site_use_id IN NUMBER,
4142: p_warehouse_id IN BINARY_INTEGER,
4143: p_ccid_record IN OUT NOCOPY ccid_rec_type,
4144: p_inv_item_type IN OUT NOCOPY
4145: mtl_system_items.item_type%TYPE ) IS
4146:
4147:
4148: BEGIN
4149: print_fcn_label2( 'arp_auto_accounting.get_default_ccids()+' );

Line 4272: p_inv_item_type IN mtl_system_items.item_type%TYPE,

4268: p_system_info IN arp_trx_global.system_info_rec_type,
4269: p_flex_info IN arp_trx_global.acct_flex_info_rec_type,
4270: p_account_class IN VARCHAR2,
4271: p_ccid_record IN CCID_REC_TYPE,
4272: p_inv_item_type IN mtl_system_items.item_type%TYPE,
4273: p_ccid IN OUT NOCOPY BINARY_INTEGER,
4274: p_concat_segments IN OUT NOCOPY VARCHAR2,
4275: p_int_ccid IN OUT NOCOPY BINARY_INTEGER,
4276: p_int_concat_segments IN OUT NOCOPY VARCHAR2 ) IS

Line 4641: l_inv_item_type mtl_system_items.item_type%TYPE;

4637: p_int_ccid IN OUT NOCOPY BINARY_INTEGER,
4638: p_int_concat_segments IN OUT NOCOPY VARCHAR2 ) IS
4639:
4640: l_ccid_record ccid_rec_type;
4641: l_inv_item_type mtl_system_items.item_type%TYPE;
4642:
4643: PROCEDURE print_params IS
4644: BEGIN
4645: debug('EXCEPTION: arp_auto_accounting.flex_manager('

Line 7295: l_inv_item_type mtl_system_items.item_type%TYPE;

7291: l_ccid_tax BINARY_INTEGER;
7292: l_ccid_unbill BINARY_INTEGER;
7293: l_ccid_unearn BINARY_INTEGER;
7294: l_ccid_suspense BINARY_INTEGER;
7295: l_inv_item_type mtl_system_items.item_type%TYPE;
7296:
7297: BEGIN
7298: -- enable_debug;
7299:

Line 7353: l_inv_item_type mtl_system_items.item_type%TYPE;

7349: l_concat varchar2(800);
7350: l_ccid binary_integer;
7351: l_int_concat varchar2(800);
7352: l_int_ccid binary_integer;
7353: l_inv_item_type mtl_system_items.item_type%TYPE;
7354:
7355: BEGIN
7356:
7357: -- enable_debug;