DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on MTL_PARAMETERS

Line 1978: FROM mtl_secondary_inventories s, mtl_parameters m

1974: p_org_id IN NUMBER,
1975: x_dist_acct_id OUT NOCOPY NUMBER) IS
1976: CURSOR Cur_get_acct IS
1977: SELECT NVL(NVL(s.expense_account, s.material_account),NVL(m.expense_account, m.material_account))
1978: FROM mtl_secondary_inventories s, mtl_parameters m
1979: WHERE s.secondary_inventory_name = p_subinventory
1980: AND m.organization_id = p_org_id;
1981: BEGIN
1982: OPEN Cur_get_acct;

Line 2878: FROM mtl_parameters

2874: AND m.organization_id = v_organization_id
2875: AND m.subinventory_code = v_subinventory;
2876: CURSOR Cur_get_org_params(v_org_id NUMBER) IS
2877: SELECT negative_inv_receipt_code, stock_locator_control_code, organization_code
2878: FROM mtl_parameters
2879: WHERE organization_id = v_org_id;
2880: l_item_rec Cur_item_dtl%ROWTYPE;
2881: l_issue_rec mtl_transactions_interface%ROWTYPE;
2882: l_issue_lot_rec mtl_transaction_lots_interface%ROWTYPE;