APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 1098: ln_material_account_id mtl_secondary_inventories.material_account%type;

1094: p_currency_conversion_rate IN NUMBER
1095: ) IS
1096:
1097: ln_rcv_quantity rcv_transactions.quantity%TYPE;
1098: ln_material_account_id mtl_secondary_inventories.material_account%type;
1099: ln_costing_amount NUMBER;
1100:
1101: lv_accounting_type varchar2(30); --File.Sql.35 Cbabu := 'REGULAR'; /*Hard coded as Localization does not do anything in case of a RTR Transaction */
1102: lv_source varchar2(30); --File.Sql.35 Cbabu := 'Inventory India';

Line 1342: ln_expense_account mtl_secondary_inventories.expense_account%type;

1338: lv_reference_10_desc gl_interface.reference10%type;
1339:
1340: ln_credit_amount NUMBER;
1341: ln_debit_amount NUMBER;
1342: ln_expense_account mtl_secondary_inventories.expense_account%type;
1343:
1344:
1345: BEGIN
1346: --File.Sql.35 Cbabu

Line 1527: ln_material_account_id mtl_secondary_inventories.material_account%type;

1523: p_codepath IN OUT NOCOPY VARCHAR2,
1524: p_process_special_source IN VARCHAR2
1525: ) is
1526:
1527: ln_material_account_id mtl_secondary_inventories.material_account%type;
1528: ln_costing_amount number;
1529:
1530: lv_source varchar2(30); --File.Sql.35 Cbabu := 'Inventory India';
1531: lv_category varchar2(30); --File.Sql.35 Cbabu := 'MTL';

Line 1989: FROM mtl_secondary_inventories

1985:
1986: /* cursor to get the material account */
1987: CURSOR c_material_account(cp_organization_id number , cp_subinventory varchar2) is
1988: SELECT material_account
1989: FROM mtl_secondary_inventories
1990: WHERE organization_id = cp_organization_id
1991: AND secondary_inventory_name = cp_subinventory;
1992:
1993:

Line 1994: ln_material_account_id mtl_secondary_inventories.material_account%type;

1990: WHERE organization_id = cp_organization_id
1991: AND secondary_inventory_name = cp_subinventory;
1992:
1993:
1994: ln_material_account_id mtl_secondary_inventories.material_account%type;
1995: ln_costing_group_id pjm_project_parameters.costing_group_id%type;
1996:
1997: lv_debug varchar2(1); --File.Sql.35 Cbabu := 'Y';
1998:

Line 2071: ln_expense_account mtl_secondary_inventories.expense_account%type;

2067: p_codepath IN OUT NOCOPY VARCHAR2
2068: )
2069: RETURN NUMBER IS
2070:
2071: ln_expense_account mtl_secondary_inventories.expense_account%type;
2072:
2073: lv_debug varchar2(1); --File.Sql.35 Cbabu := 'Y';
2074:
2075: cursor c_fetch_expense_acct(cp_organization_id in number, cp_subinventory_code in varchar2) IS

Line 2077: FROM mtl_secondary_inventories

2073: lv_debug varchar2(1); --File.Sql.35 Cbabu := 'Y';
2074:
2075: cursor c_fetch_expense_acct(cp_organization_id in number, cp_subinventory_code in varchar2) IS
2076: SELECT expense_account
2077: FROM mtl_secondary_inventories
2078: WHERE organization_id = cp_organization_id
2079: AND secondary_inventory_name = cp_subinventory_code;
2080:
2081: cursor c_fetch_expense_acct1(cp_po_distribution_id in number) IS