APPS.CSM_EMAIL_QUERY_PKG dependencies on MTL_SYSTEM_ITEMS_TL

Line 2204: FROM MTL_SYSTEM_ITEMS_B B,MTL_SYSTEM_ITEMS_TL TL

2200: AND LANGUAGE = USERENV('LANG')
2201: ) AS SERIAL_NUMBER_CONTROL_CODE ,
2202:
2203: DECODE(NVL(B.COMMS_NL_TRACKABLE_FLAG,'N'),'Y', 'Yes','N','No') AS IB_TRACKABLE
2204: FROM MTL_SYSTEM_ITEMS_B B,MTL_SYSTEM_ITEMS_TL TL
2205: WHERE UPPER(B.SEGMENT1) = UPPER(p_item)
2206: AND B.INVENTORY_ITEM_ID = TL.INVENTORY_ITEM_ID
2207: AND B.ORGANIZATION_ID = TL.ORGANIZATION_ID
2208: AND TL.LANGUAGE = USERENV('LANG')

Line 2306: MTL_SYSTEM_ITEMS_TL TL

2302: R.RELATED_ITEM_ID
2303: FROM
2304: MTL_RELATED_ITEMS R,
2305: MTL_SYSTEM_ITEMS_B B,
2306: MTL_SYSTEM_ITEMS_TL TL
2307: WHERE R.INVENTORY_ITEM_ID = p_INV_ITEM_ID
2308: AND R.ORGANIZATION_ID = p_ORG_ID
2309: AND R.RELATIONSHIP_TYPE_ID IN(2,8)
2310: AND B.INVENTORY_ITEM_ID = R.RELATED_ITEM_ID

Line 2322: MTL_SYSTEM_ITEMS_TL TL

2318: IS
2319: SELECT B.INVENTORY_ITEM_ID,B.SEGMENT1,TL.DESCRIPTION
2320: FROM
2321: MTL_SYSTEM_ITEMS_B B,
2322: MTL_SYSTEM_ITEMS_TL TL
2323: WHERE UPPER(B.SEGMENT1) = UPPER(p_item)
2324: AND B.ORGANIZATION_ID = p_ORG_ID
2325: AND B.INVENTORY_ITEM_ID = TL.INVENTORY_ITEM_ID
2326: AND B.ORGANIZATION_ID = TL.ORGANIZATION_ID

Line 2463: MTL_SYSTEM_ITEMS_TL TL

2459: IS
2460: SELECT B.INVENTORY_ITEM_ID,B.SEGMENT1,TL.DESCRIPTION
2461: FROM
2462: MTL_SYSTEM_ITEMS_B B,
2463: MTL_SYSTEM_ITEMS_TL TL
2464: WHERE UPPER(B.SEGMENT1) = UPPER(p_item)
2465: AND B.ORGANIZATION_ID = p_ORG_ID
2466: AND B.INVENTORY_ITEM_ID = TL.INVENTORY_ITEM_ID
2467: AND B.ORGANIZATION_ID = TL.ORGANIZATION_ID

Line 2482: MTL_SYSTEM_ITEMS_TL TL

2478: IS
2479: SELECT B.SEGMENT1,TL.DESCRIPTION
2480: FROM
2481: MTL_SYSTEM_ITEMS_B B,
2482: MTL_SYSTEM_ITEMS_TL TL
2483: WHERE B.INVENTORY_ITEM_ID = p_item_id
2484: AND B.ORGANIZATION_ID = p_ORG_ID
2485: AND B.INVENTORY_ITEM_ID = TL.INVENTORY_ITEM_ID
2486: AND B.ORGANIZATION_ID = TL.ORGANIZATION_ID

Line 2644: MTL_SYSTEM_ITEMS_TL TL

2640: IS
2641: SELECT B.INVENTORY_ITEM_ID,B.SEGMENT1,TL.DESCRIPTION
2642: FROM
2643: MTL_SYSTEM_ITEMS_B B,
2644: MTL_SYSTEM_ITEMS_TL TL
2645: WHERE B.segment1 = p_item
2646: AND B.ORGANIZATION_ID = p_ORG_ID
2647: AND B.INVENTORY_ITEM_ID = TL.INVENTORY_ITEM_ID
2648: AND B.ORGANIZATION_ID = TL.ORGANIZATION_ID

Line 2663: MTL_SYSTEM_ITEMS_TL TL

2659: IS
2660: SELECT B.SEGMENT1,TL.DESCRIPTION
2661: FROM
2662: MTL_SYSTEM_ITEMS_B B,
2663: MTL_SYSTEM_ITEMS_TL TL
2664: WHERE B.INVENTORY_ITEM_ID = p_item_id
2665: AND B.ORGANIZATION_ID = p_ORG_ID
2666: AND B.INVENTORY_ITEM_ID = TL.INVENTORY_ITEM_ID
2667: AND B.ORGANIZATION_ID = TL.ORGANIZATION_ID