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 3107: MTL_PARAMETERS P

3103: ITEM_CATALOG_GROUP_ID,
3104: PRIMARY_UNIT_OF_MEASURE,
3105: DESCRIPTION
3106: FROM MTL_SYSTEM_ITEMS_B_KFV MSI,
3107: MTL_PARAMETERS P
3108: WHERE MSI.ORGANIZATION_ID = P.ORGANIZATION_ID ';
3109:
3110: get_segments_string(P_Segment_Rec => P_Segment_Rec
3111: ,P_Segment_String => l_segments_string);

Line 4045: MTL_PARAMETERS MP

4041: P_Item_Rec.CREATED_BY,
4042: P_Item_Rec.LAST_UPDATE_LOGIN
4043: FROM
4044: MTL_SYSTEM_ITEMS_TL MSI,
4045: MTL_PARAMETERS MP
4046: WHERE
4047: MSI.INVENTORY_ITEM_ID = P_Item_Rec.INVENTORY_ITEM_ID
4048: AND MSI.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
4049: AND MP.ORGANIZATION_ID = P_Item_Rec.ORGANIZATION_ID;

Line 4442: l_prim_cost_method MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE;

4438: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4439: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)
4440: IS
4441:
4442: l_prim_cost_method MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE;
4443: /* l_profile_exists BOOLEAN;
4444: l_profile_val VARCHAR2(240); Bug 4247149*/
4445:
4446: BEGIN

Line 4451: FROM mtl_parameters

4447: IF NVL(P_cost_txn,-99) <> 1 THEN
4448:
4449: SELECT primary_cost_method
4450: INTO l_prim_cost_method
4451: FROM mtl_parameters
4452: WHERE ORGANIZATION_ID = p_org_id;
4453:
4454: UPDATE cst_item_costs
4455: SET inventory_asset_flag = decode(P_Asset_Flag,'Y', 1, 2)

Line 5985: FROM MTL_PARAMETERS

5981: ,LONG_DESCRIPTION
5982: FROM MTL_SYSTEM_ITEMS_TL
5983: WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID
5984: AND ORGANIZATION_ID IN ( SELECT ORGANIZATION_ID
5985: FROM MTL_PARAMETERS
5986: WHERE MASTER_ORGANIZATION_ID = X_ORGANIZATION_ID
5987: AND ORGANIZATION_ID <> X_ORGANIZATION_ID)
5988: AND LANGUAGE = X_LANGUAGE
5989: FOR UPDATE OF INVENTORY_ITEM_ID;