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 1422: -- Retrieves default ccids from the table mtl_system_items

1418: --
1419: -- PROCEDURE NAME: get_inv_item_ccids
1420: --
1421: -- DECSRIPTION:
1422: -- Retrieves default ccids from the table mtl_system_items
1423: -- for a given item_id.
1424: --
1425: -- ARGUMENTS:
1426: -- IN:

Line 1447: mtl_system_items.item_type%TYPE ) IS

1443: p_inv_item_id IN BINARY_INTEGER,
1444: p_warehouse_id IN BINARY_INTEGER,
1445: p_ccid_rev IN OUT NOCOPY BINARY_INTEGER,
1446: p_inv_item_type IN OUT NOCOPY
1447: mtl_system_items.item_type%TYPE ) IS
1448: l_ctr BINARY_INTEGER;
1449: l_hit BOOLEAN := FALSE;
1450: t_warehouse_id BINARY_INTEGER;
1451:

Line 1511: FROM mtl_system_items

1507:
1508: SELECT nvl(sales_account, -1), nvl(item_type, '~')
1509: INTO p_ccid_rev,
1510: p_inv_item_type
1511: FROM mtl_system_items
1512: WHERE organization_id
1513: = t_warehouse_id
1514: AND inventory_item_id = p_inv_item_id;
1515:

Line 4118: mtl_system_items.item_type%TYPE ) IS

4114: p_site_use_id IN BINARY_INTEGER,
4115: p_warehouse_id IN BINARY_INTEGER,
4116: p_ccid_record IN OUT NOCOPY ccid_rec_type,
4117: p_inv_item_type IN OUT NOCOPY
4118: mtl_system_items.item_type%TYPE ) IS
4119:
4120:
4121: BEGIN
4122: print_fcn_label2( 'arp_auto_accounting.get_default_ccids()+' );

Line 4245: p_inv_item_type IN mtl_system_items.item_type%TYPE,

4241: p_system_info IN arp_trx_global.system_info_rec_type,
4242: p_flex_info IN arp_trx_global.acct_flex_info_rec_type,
4243: p_account_class IN VARCHAR2,
4244: p_ccid_record IN CCID_REC_TYPE,
4245: p_inv_item_type IN mtl_system_items.item_type%TYPE,
4246: p_ccid IN OUT NOCOPY BINARY_INTEGER,
4247: p_concat_segments IN OUT NOCOPY VARCHAR2,
4248: p_int_ccid IN OUT NOCOPY BINARY_INTEGER,
4249: p_int_concat_segments IN OUT NOCOPY VARCHAR2 ) IS

Line 4614: l_inv_item_type mtl_system_items.item_type%TYPE;

4610: p_int_ccid IN OUT NOCOPY BINARY_INTEGER,
4611: p_int_concat_segments IN OUT NOCOPY VARCHAR2 ) IS
4612:
4613: l_ccid_record ccid_rec_type;
4614: l_inv_item_type mtl_system_items.item_type%TYPE;
4615:
4616: PROCEDURE print_params IS
4617: BEGIN
4618: debug('EXCEPTION: arp_auto_accounting.flex_manager('

Line 7187: l_inv_item_type mtl_system_items.item_type%TYPE;

7183: l_ccid_tax BINARY_INTEGER;
7184: l_ccid_unbill BINARY_INTEGER;
7185: l_ccid_unearn BINARY_INTEGER;
7186: l_ccid_suspense BINARY_INTEGER;
7187: l_inv_item_type mtl_system_items.item_type%TYPE;
7188:
7189: BEGIN
7190: -- enable_debug;
7191:

Line 7245: l_inv_item_type mtl_system_items.item_type%TYPE;

7241: l_concat varchar2(800);
7242: l_ccid binary_integer;
7243: l_int_concat varchar2(800);
7244: l_int_ccid binary_integer;
7245: l_inv_item_type mtl_system_items.item_type%TYPE;
7246:
7247: BEGIN
7248:
7249: -- enable_debug;