DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on MTL_PARAMETERS

Line 4663: FROM mtl_parameters mp,

4659: CURSOR inv_org_csr (p_tal_id IN NUMBER, p_asd_id IN NUMBER) IS
4660: SELECT mp.master_organization_id,
4661: chrb.inv_organization_id,
4662: txdb.inventory_item_id
4663: FROM mtl_parameters mp,
4664: okc_k_headers_b chrb,
4665: okc_k_lines_b cleb,
4666: okl_txl_Assets_b txlb,
4667: okl_txd_assets_b txdb

Line 4674: l_mast_org_id mtl_parameters.master_organization_id%TYPE;

4670: AND cleb.id = txlb.kle_id
4671: AND txlb.id = p_tal_id
4672: AND txdb.id = p_asd_id;
4673:
4674: l_mast_org_id mtl_parameters.master_organization_id%TYPE;
4675: l_inv_org_id okc_k_headers_b.inv_organization_id%TYPE;
4676: l_inv_item_id okl_txd_assets_b.inventory_item_id%TYPE;
4677:
4678: --Cursor to get location of parent instance from IB