DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on MTL_PARAMETERS

Line 4691: FROM mtl_parameters mp,

4687: CURSOR inv_org_csr (p_tal_id IN NUMBER, p_asd_id IN NUMBER) IS
4688: SELECT mp.master_organization_id,
4689: chrb.inv_organization_id,
4690: txdb.inventory_item_id
4691: FROM mtl_parameters mp,
4692: okc_k_headers_b chrb,
4693: okc_k_lines_b cleb,
4694: okl_txl_Assets_b txlb,
4695: okl_txd_assets_b txdb

Line 4702: l_mast_org_id mtl_parameters.master_organization_id%TYPE;

4698: AND cleb.id = txlb.kle_id
4699: AND txlb.id = p_tal_id
4700: AND txdb.id = p_asd_id;
4701:
4702: l_mast_org_id mtl_parameters.master_organization_id%TYPE;
4703: l_inv_org_id okc_k_headers_b.inv_organization_id%TYPE;
4704: l_inv_item_id okl_txd_assets_b.inventory_item_id%TYPE;
4705:
4706: --Cursor to get location of parent instance from IB