APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 1248: ln_material_account_id mtl_secondary_inventories.material_account%type;

1244: p_currency_conversion_rate IN NUMBER
1245: ) IS
1246:
1247: ln_rcv_quantity rcv_transactions.quantity%TYPE;
1248: ln_material_account_id mtl_secondary_inventories.material_account%type;
1249: ln_costing_amount NUMBER;
1250:
1251: lv_accounting_type varchar2(30); --File.Sql.35 Cbabu := 'REGULAR'; /*Hard coded as Localization does not do anything in case of a RTR Transaction */
1252: lv_source varchar2(30); --File.Sql.35 Cbabu := 'Inventory India';

Line 1506: ln_expense_account mtl_secondary_inventories.expense_account%type;

1502: lv_reference_10_desc gl_interface.reference10%type;
1503:
1504: ln_credit_amount NUMBER;
1505: ln_debit_amount NUMBER;
1506: ln_expense_account mtl_secondary_inventories.expense_account%type;
1507:
1508:
1509: BEGIN
1510: --File.Sql.35 Cbabu

Line 1691: ln_material_account_id mtl_secondary_inventories.material_account%type;

1687: p_codepath IN OUT NOCOPY VARCHAR2,
1688: p_process_special_source IN VARCHAR2
1689: ) is
1690:
1691: ln_material_account_id mtl_secondary_inventories.material_account%type;
1692: ln_costing_amount number;
1693:
1694: lv_source varchar2(30); --File.Sql.35 Cbabu := 'Inventory India';
1695: lv_category varchar2(30); --File.Sql.35 Cbabu := 'MTL';

Line 2153: FROM mtl_secondary_inventories

2149:
2150: /* cursor to get the material account */
2151: CURSOR c_material_account(cp_organization_id number , cp_subinventory varchar2) is
2152: SELECT material_account
2153: FROM mtl_secondary_inventories
2154: WHERE organization_id = cp_organization_id
2155: AND secondary_inventory_name = cp_subinventory;
2156:
2157:

Line 2158: ln_material_account_id mtl_secondary_inventories.material_account%type;

2154: WHERE organization_id = cp_organization_id
2155: AND secondary_inventory_name = cp_subinventory;
2156:
2157:
2158: ln_material_account_id mtl_secondary_inventories.material_account%type;
2159: ln_costing_group_id pjm_project_parameters.costing_group_id%type;
2160:
2161: lv_debug varchar2(1); --File.Sql.35 Cbabu := 'Y';
2162:

Line 2235: ln_expense_account mtl_secondary_inventories.expense_account%type;

2231: p_codepath IN OUT NOCOPY VARCHAR2
2232: )
2233: RETURN NUMBER IS
2234:
2235: ln_expense_account mtl_secondary_inventories.expense_account%type;
2236:
2237: lv_debug varchar2(1); --File.Sql.35 Cbabu := 'Y';
2238:
2239: cursor c_fetch_expense_acct(cp_organization_id in number, cp_subinventory_code in varchar2) IS

Line 2241: FROM mtl_secondary_inventories

2237: lv_debug varchar2(1); --File.Sql.35 Cbabu := 'Y';
2238:
2239: cursor c_fetch_expense_acct(cp_organization_id in number, cp_subinventory_code in varchar2) IS
2240: SELECT expense_account
2241: FROM mtl_secondary_inventories
2242: WHERE organization_id = cp_organization_id
2243: AND secondary_inventory_name = cp_subinventory_code;
2244:
2245: cursor c_fetch_expense_acct1(cp_po_distribution_id in number) IS