APPS.INV_ITEM_PVT dependencies on MTL_PARAMETERS

Line 46: FROM mtl_parameters

42: IF ((g_Master_Org_ID IS NULL ) OR NOT(g_Org_ID = p_Org_ID)) THEN
43: g_Org_ID := p_Org_ID;
44: SELECT master_organization_id
45: INTO g_Master_Org_ID
46: FROM mtl_parameters
47: WHERE organization_id = p_Org_ID;
48: END IF;
49: RETURN ( g_Master_Org_ID );
50:

Line 258: FROM mtl_parameters

254: IS
255: SELECT process_enabled_flag, wms_enabled_flag,
256: eam_enabled_flag, primary_cost_method,
257: trading_partner_org_flag
258: FROM mtl_parameters
259: WHERE organization_id = c_organization_id;
260:
261: l_process_enabled VARCHAR2(1);
262: l_eam_enabled VARCHAR2(1);

Line 3368: MTL_PARAMETERS P

3364: ITEM_CATALOG_GROUP_ID,
3365: PRIMARY_UNIT_OF_MEASURE,
3366: DESCRIPTION
3367: FROM MTL_SYSTEM_ITEMS_B_KFV MSI,
3368: MTL_PARAMETERS P
3369: WHERE MSI.ORGANIZATION_ID = P.ORGANIZATION_ID ';
3370:
3371: get_segments_string(P_Segment_Rec => P_Segment_Rec
3372: ,P_Segment_String => l_segments_string);

Line 4310: MTL_PARAMETERS MP

4306: P_Item_Rec.CREATED_BY,
4307: P_Item_Rec.LAST_UPDATE_LOGIN
4308: FROM
4309: MTL_SYSTEM_ITEMS_TL MSI,
4310: MTL_PARAMETERS MP
4311: WHERE
4312: MSI.INVENTORY_ITEM_ID = P_Item_Rec.INVENTORY_ITEM_ID
4313: AND MSI.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
4314: AND MP.ORGANIZATION_ID = P_Item_Rec.ORGANIZATION_ID;

Line 4707: l_prim_cost_method MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE;

4703: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4704: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)
4705: IS
4706:
4707: l_prim_cost_method MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE;
4708: /* l_profile_exists BOOLEAN;
4709: l_profile_val VARCHAR2(240); Bug 4247149*/
4710:
4711: BEGIN

Line 4716: FROM mtl_parameters

4712: IF NVL(P_cost_txn,-99) <> 1 THEN
4713:
4714: SELECT primary_cost_method
4715: INTO l_prim_cost_method
4716: FROM mtl_parameters
4717: WHERE ORGANIZATION_ID = p_org_id;
4718:
4719: UPDATE cst_item_costs
4720: SET inventory_asset_flag = decode(P_Asset_Flag,'Y', 1, 2)

Line 4847: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;

4843: l_last_update_date DATE;
4844: l_last_update_login NUMBER;
4845: */
4846: -- Bug 8512945 with base bug 8417326 : Start
4847: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
4848: l_exists VARCHAR2(1) := 'N';
4849: l_control_level NUMBER;
4850:
4851: Cursor c_get_child_costing_orgs(org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE) IS

Line 4851: Cursor c_get_child_costing_orgs(org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE) IS

4847: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
4848: l_exists VARCHAR2(1) := 'N';
4849: l_control_level NUMBER;
4850:
4851: Cursor c_get_child_costing_orgs(org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE) IS
4852: SELECT ORGANIZATION_ID
4853: FROM MTL_PARAMETERS
4854: WHERE ORGANIZATION_ID = org_id
4855: OR ORGANIZATION_ID IN

Line 4853: FROM MTL_PARAMETERS

4849: l_control_level NUMBER;
4850:
4851: Cursor c_get_child_costing_orgs(org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE) IS
4852: SELECT ORGANIZATION_ID
4853: FROM MTL_PARAMETERS
4854: WHERE ORGANIZATION_ID = org_id
4855: OR ORGANIZATION_ID IN
4856: (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS
4857: WHERE MASTER_ORGANIZATION_ID = org_id

Line 4856: (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS

4852: SELECT ORGANIZATION_ID
4853: FROM MTL_PARAMETERS
4854: WHERE ORGANIZATION_ID = org_id
4855: OR ORGANIZATION_ID IN
4856: (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS
4857: WHERE MASTER_ORGANIZATION_ID = org_id
4858: AND PRIMARY_COST_METHOD in (2,5,6)
4859: AND (1=(select control_level from mtl_item_attributes
4860: where attribute_name= 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG')

Line 6474: FROM MTL_PARAMETERS

6470: ,LONG_DESCRIPTION
6471: FROM MTL_SYSTEM_ITEMS_TL
6472: WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID
6473: AND ORGANIZATION_ID IN ( SELECT ORGANIZATION_ID
6474: FROM MTL_PARAMETERS
6475: WHERE MASTER_ORGANIZATION_ID = X_ORGANIZATION_ID
6476: AND ORGANIZATION_ID <> X_ORGANIZATION_ID)
6477: AND LANGUAGE = X_LANGUAGE
6478: FOR UPDATE OF INVENTORY_ITEM_ID;