APPS.CSM_EMAIL_QUERY_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 1492: mtl_system_items_b item

1488: CURSOR c_system_items(p_incident_id NUMBER)
1489: IS
1490: SELECT item.segment1 AS item
1491: FROM cs_incidents_all_b csb,
1492: mtl_system_items_b item
1493: WHERE csb.incident_id = p_incident_id
1494: AND item.inventory_item_id(+) = csb.inventory_item_id
1495: AND item.organization_id = csb.org_id;
1496:

Line 1531: l_item mtl_system_items_b.segment1%TYPE;

1527:
1528: r_task_details c_task_details%ROWTYPE;
1529: r_task_uom c_task_uom%ROWTYPE;
1530: r_task_notes c_task_notes%ROWTYPE;
1531: l_item mtl_system_items_b.segment1%TYPE;
1532: l_serial_number csi_item_instances.serial_number%TYPE;
1533: l_task_access_flag VARCHAR2(1);
1534: l_query_text VARCHAR2(4000);
1535: l_qrycontext DBMS_XMLGEN.ctxHandle;

Line 1673: mtl_system_items_b item

1669: CURSOR c_system_items(p_incident_id NUMBER)
1670: IS
1671: SELECT item.segment1 AS item
1672: FROM cs_incidents_all_b csb,
1673: mtl_system_items_b item
1674: WHERE csb.incident_id = p_incident_id
1675: AND item.inventory_item_id(+) = csb.inventory_item_id
1676: AND item.organization_id = csb.org_id;
1677:

Line 1727: l_item mtl_system_items_b.segment1%TYPE;

1723: AND lkp.lookup_type = 'JTF_NOTE_STATUS'
1724: AND lkp.LANGUAGE = userenv('LANG');
1725:
1726: r_incident_details c_incident_details%ROWTYPE;
1727: l_item mtl_system_items_b.segment1%TYPE;
1728: l_instance_number csi_item_instances.instance_number%TYPE;
1729: l_serial_number csi_item_instances.serial_number%TYPE;
1730: l_description fnd_lookup_values.description%TYPE;
1731: r_sr_notes c_sr_notes%ROWTYPE;

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 2305: MTL_SYSTEM_ITEMS_B B,

2301: ) AS ITEM_TYPE,
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)

Line 2321: MTL_SYSTEM_ITEMS_B B,

2317: CURSOR c_get_item(p_item VARCHAR2, p_org_id NUMBER)
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

Line 2462: MTL_SYSTEM_ITEMS_B B,

2458: CURSOR c_get_item(p_item VARCHAR2, p_org_id NUMBER)
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

Line 2481: MTL_SYSTEM_ITEMS_B B,

2477: CURSOR c_get_item_name(p_item_id NUMBER, p_org_id NUMBER)
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

Line 2643: MTL_SYSTEM_ITEMS_B B,

2639: CURSOR c_get_item(p_item VARCHAR2, p_org_id NUMBER)
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

Line 2662: MTL_SYSTEM_ITEMS_B B,

2658: CURSOR c_get_item_name(p_item_id NUMBER, p_org_id NUMBER)
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