APPS.JA_AU_CCID_PKG dependencies on MTL_SYSTEM_ITEMS

Line 36: l_item_ccid mtl_system_items.expense_account%TYPE;

32:
33: l_chart_of_accts_id org_organization_definitions.organization_id%TYPE;
34: l_set_of_books_id org_organization_definitions.set_of_books_id%TYPE;
35: l_subinv_ccid mtl_secondary_inventories.expense_account%TYPE;
36: l_item_ccid mtl_system_items.expense_account%TYPE;
37: l_table_name JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE;
38: l_constant JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE;
39: l_segment JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE;
40: l_segvalues fnd_flex_ext.segmentarray;

Line 191: mtl_system_items.inventory_item_id%TYPE,

187: org_organization_definitions.organization_id%TYPE,
188: x_subinv IN
189: mtl_secondary_inventories.secondary_inventory_name%TYPE,
190: x_item_id IN
191: mtl_system_items.inventory_item_id%TYPE,
192: x_subinv_ccid IN OUT
193: mtl_secondary_inventories.expense_account%TYPE,
194: x_item_ccid IN OUT
195: mtl_system_items.expense_account%TYPE)

Line 195: mtl_system_items.expense_account%TYPE)

191: mtl_system_items.inventory_item_id%TYPE,
192: x_subinv_ccid IN OUT
193: mtl_secondary_inventories.expense_account%TYPE,
194: x_item_ccid IN OUT
195: mtl_system_items.expense_account%TYPE)
196: IS
197: BEGIN
198:
199: l_error_msg := 'AUTOGL ERROR - Could not retrieve subinventory expense_account';

Line 216: FROM mtl_system_items

212: l_error_msg := 'AUTOGL ERROR - Could not retrieve item expense_account';
213:
214: SELECT nvl(expense_account, -1)
215: INTO x_item_ccid
216: FROM mtl_system_items
217: WHERE organization_id = x_org_id
218: AND inventory_item_id = x_item_id ;
219:
220: IF x_item_ccid = -1 THEN

Line 253: mtl_system_items.expense_account%TYPE)

249: JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE,
250: x_subinv_ccid IN
251: mtl_secondary_inventories.expense_account%TYPE,
252: x_item_ccid IN
253: mtl_system_items.expense_account%TYPE)
254: RETURN gl_code_combinations.segment1%TYPE IS
255:
256: l_value gl_code_combinations.segment1%TYPE;
257:

Line 264: ELSIF x_table_name = 'MTL_SYSTEM_ITEMS' THEN

260: IF SUBSTR(x_constant,1,2) = '!~' THEN /* Not a constant */
261: IF x_table_name = 'MTL_SECONDARY_INVENTORIES' THEN
262: l_value := JA_AU_get_value(x_subinv_ccid,
263: x_segment);
264: ELSIF x_table_name = 'MTL_SYSTEM_ITEMS' THEN
265: l_value := JA_AU_get_value(x_item_ccid,
266: x_segment);
267: ELSE
268: l_value := '0';