eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_EMAIL_QUERY_PKG dependencies on CSI_ITEM_INSTANCES

Line 1501: csi_item_instances inst

1497: CURSOR c_item_instance(p_incident_id NUMBER)
1498: IS
1499: SELECT inst.serial_number
1500: FROM cs_incidents_all_b csb,
1501: csi_item_instances inst
1502: WHERE csb.incident_id = p_incident_id
1503: AND inst.instance_id(+) = csb.customer_product_id
1504: AND inst.inv_master_organization_id = csb.org_id
1505: AND inst.inventory_item_id = csb.inventory_item_id;

Line 1532: l_serial_number csi_item_instances.serial_number%TYPE;

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;
1536: l_email_format VARCHAR2(240);

Line 1683: csi_item_instances inst

1679: IS
1680: SELECT inst.instance_number AS instance,
1681: inst.serial_number
1682: FROM cs_incidents_all_b csb,
1683: csi_item_instances inst
1684: WHERE csb.incident_id = p_incident_id
1685: AND inst.instance_id(+) = csb.customer_product_id
1686: AND inst.inv_master_organization_id = csb.org_id
1687: AND inst.inventory_item_id = csb.inventory_item_id;

Line 1728: l_instance_number csi_item_instances.instance_number%TYPE;

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;
1732: l_incident_id NUMBER;

Line 1729: l_serial_number csi_item_instances.serial_number%TYPE;

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;
1732: l_incident_id NUMBER;
1733: l_query_text VARCHAR2(4000);

Line 1852: FROM csi_item_instances csi,

1848: CURSOR c_inst_contracts(p_serial_number VARCHAR2, p_resource_id NUMBER)
1849: IS
1850: SELECT csi.instance_id,
1851: cs.contract_service_id
1852: FROM csi_item_instances csi,
1853: cs_incidents_all_b cs,
1854: jtf_tasks_b tsk,
1855: jtf_task_assignments ass
1856: WHERE csi.serial_number = p_serial_number

Line 1867: FROM csi_item_instances csi,

1863: CURSOR c_inst_contracts_group(p_serial_number VARCHAR2, p_resource_id NUMBER)
1864: IS
1865: SELECT csi.instance_id,
1866: cs.contract_service_id
1867: FROM csi_item_instances csi,
1868: cs_incidents_all_b cs,
1869: jtf_tasks_b tsk,
1870: jtf_task_assignments ass
1871: WHERE csi.serial_number = p_serial_number

Line 1893: FROM csi_item_instances csi,

1889: CURSOR c_inst_contracts_tech(p_serial_number VARCHAR2, p_resource_id NUMBER)
1890: IS
1891: SELECT csi.instance_id,
1892: cs.contract_service_id
1893: FROM csi_item_instances csi,
1894: cs_incidents_all_b cs,
1895: jtf_tasks_b tsk,
1896: JTF_TASK_ASSIGNMENTS ASS,
1897: JTF_RS_GROUP_MEMBERS jtm