DBA Data[Home] [Help]

APPS.INV_ITEM_API dependencies on MTL_PARAMETERS

Line 431: , MTL_PARAMETERS MP1

427: -- Serial_Tagging Enh -- bug 9913552
428: ,MSI.SERIAL_TAGGING_FLAG
429: FROM
430: MTL_SYSTEM_ITEMS_B MSI
431: , MTL_PARAMETERS MP1
432: WHERE
433: INVENTORY_ITEM_ID = p_Item_ID
434: AND MSI.ORGANIZATION_ID = MP1.ORGANIZATION_ID
435: AND ( ( p_fetch_Master = g_TRUE AND MSI.ORGANIZATION_ID = p_Org_ID ) OR

Line 439: FROM MTL_PARAMETERS MP2

435: AND ( ( p_fetch_Master = g_TRUE AND MSI.ORGANIZATION_ID = p_Org_ID ) OR
436: ( p_fetch_Orgs = g_TRUE AND
437: MSI.ORGANIZATION_ID IN
438: ( SELECT MP2.ORGANIZATION_ID
439: FROM MTL_PARAMETERS MP2
440: WHERE MP2.MASTER_ORGANIZATION_ID = p_Org_ID
441: AND MP2.ORGANIZATION_ID <> p_Org_ID
442: )
443: )

Line 483: FROM MTL_PARAMETERS

479: AND ( ( p_fetch_Master = g_TRUE AND ORGANIZATION_ID = p_Org_ID ) OR
480: ( p_fetch_Orgs = g_TRUE AND
481: ORGANIZATION_ID IN
482: ( SELECT ORGANIZATION_ID
483: FROM MTL_PARAMETERS
484: WHERE MASTER_ORGANIZATION_ID = p_Org_ID
485: AND ORGANIZATION_ID <> p_Org_ID
486: )
487: )