APPS.JA_AU_CCID_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 35: l_subinv_ccid mtl_secondary_inventories.expense_account%TYPE;

31: IS
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;

Line 189: mtl_secondary_inventories.secondary_inventory_name%TYPE,

185: PROCEDURE JA_AU_GET_REPLN_EXP_ACCTS
186: (x_org_id IN
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,

Line 193: mtl_secondary_inventories.expense_account%TYPE,

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)
196: IS
197: BEGIN

Line 203: FROM mtl_secondary_inventories

199: l_error_msg := 'AUTOGL ERROR - Could not retrieve subinventory expense_account';
200:
201: SELECT nvl(expense_account, -1)
202: INTO x_subinv_ccid
203: FROM mtl_secondary_inventories
204: WHERE organization_id = x_org_id
205: AND secondary_inventory_name = x_subinv ;
206:
207: IF x_subinv_ccid = -1 THEN

Line 251: mtl_secondary_inventories.expense_account%TYPE,

247: JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE,
248: x_segment IN
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:

Line 261: IF x_table_name = 'MTL_SECONDARY_INVENTORIES' THEN

257:
258: BEGIN
259:
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,