APPS.CSM_SR_EVENT_PKG dependencies on CS_ESTIMATE_DETAILS

Line 1643: FROM CS_ESTIMATE_DETAILS inv

1639: inv.SELLING_PRICE,
1640: inv.AFTER_WARRANTY_COST,
1641: inv.CHARGE_LINE_TYPE,
1642: inv.BILL_TO_PARTY_ID
1643: FROM CS_ESTIMATE_DETAILS inv
1644: WHERE INV.ORIGINAL_SOURCE_CODE = 'SR'
1645: AND inv.INCIDENT_ID = c_incident_id ;
1646:
1647: l_xml CLOB;

Line 1698: FROM CS_ESTIMATE_DETAILS inv WHERE INV.ORIGINAL_SOURCE_CODE = ''SR''

1694: l_SQL_TEXT := 'SELECT inv.INCIDENT_ID, inv.LINE_NUMBER, inv.BUSINESS_PROCESS_ID,
1695: inv.TXN_BILLING_TYPE_ID, inv.INVENTORY_ITEM_ID, inv.SERIAL_NUMBER,
1696: inv.QUANTITY_REQUIRED, inv.UNIT_OF_MEASURE_CODE, inv.SELLING_PRICE,
1697: inv.AFTER_WARRANTY_COST, inv.CHARGE_LINE_TYPE, inv.BILL_TO_PARTY_ID
1698: FROM CS_ESTIMATE_DETAILS inv WHERE INV.ORIGINAL_SOURCE_CODE = ''SR''
1699: AND inv.INCIDENT_ID = ' || l_INCIDENT_ID ;
1700: --Execute the SQL query
1701: qrycontext := DBMS_XMLGEN.newcontext(l_SQL_TEXT) ;
1702: