APPS.CS_CHARGE_CORE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

              SELECT  incident_id INTO  x_source_id
              FROM    CS_INCIDENTS_ALL_B
              WHERE   incident_number = p_source_number;

Line: 35

           SELECT  repair_line_id INTO x_source_id
           FROM    CSD_REPAIRS
           WHERE   repair_number = p_source_number ;

Line: 45

           SELECT  debrief_header_id INTO x_source_id
           FROM    csf_debrief_headers
           WHERE   debrief_number = p_source_number ;

Line: 81

       SELECT min(TRX.TRX_NUMBER), to_char(TRX.TRX_DATE)
         FROM OE_ORDER_HEADERS_ALL HD,
              RA_CUSTOMER_TRX_ALL TRX,
              OE_ORDER_LINES_ALL L,
              RA_CUSTOMER_TRX_LINES_ALL TRXL
         WHERE HD.HEADER_ID = L.HEADER_ID
	      AND  trxl.INTERFACE_LINE_CONTEXT    = 'ORDER ENTRY'
	      AND  trxl.INTERFACE_LINE_ATTRIBUTE1 = to_char(hd.ORDER_NUMBER)
	      -- AND  trxl.INTERFACE_LINE_ATTRIBUTE2 = to_char(hd.ORDER_TYPE_ID) -- bug:2463968
              AND  trxl.INTERFACE_LINE_ATTRIBUTE6 = to_char(l.LINE_ID)
              AND TRX.CUSTOMER_TRX_ID = TRXL.CUSTOMER_TRX_ID
              AND HD.HEADER_ID    = p_order_header_id
         group by trx.trx_number,trx.trx_date; */

Line: 98

       SELECT min(TRX.TRX_NUMBER), to_char(TRX.TRX_DATE)
         FROM OE_ORDER_HEADERS_ALL HD,
              RA_CUSTOMER_TRX_ALL TRX,
              RA_CUSTOMER_TRX_LINES_ALL TRXL,
              oe_transaction_types_tl ottt
         WHERE HD.HEADER_ID = p_order_header_id
           and ottt.transaction_type_id = hd.ORDER_TYPE_ID
           and trxl.sales_order = to_char(hd.ORDER_NUMBER)
	       AND  trxl.INTERFACE_LINE_ATTRIBUTE2 = ottt.name
           AND TRX.CUSTOMER_TRX_ID = TRXL.CUSTOMER_TRX_ID
         group by trx.trx_number, trx.trx_date;

Line: 114

    SELECT order_number
     FROM  oe_order_headers_all
    WHERE  header_id = p_order_header_id;

Line: 120

    SELECT TRX.TRX_NUMBER,
           TRX.TRX_DATE
    FROM   RA_CUSTOMER_TRX_ALL TRX
    WHERE  TRX.CUSTOMER_TRX_ID IN (SELECT TRXL.CUSTOMER_TRX_ID  -- Bug 7117570 Changed = to IN
                                  FROM   RA_CUSTOMER_TRX_LINES_ALL TRXL
                                  WHERE  TRXL.INTERFACE_LINE_CONTEXT    = 'ORDER ENTRY'
                                  AND    TRXL.INTERFACE_LINE_ATTRIBUTE1 = to_char(p_order_header_number)
                                  AND    TRXL.INTERFACE_LINE_ATTRIBUTE6 = to_char(p_line_id)
  			          AND    TRXL.SALES_ORDER = to_char(p_order_header_number));

Line: 130

   /* SELECT TRX.TRX_NUMBER,
           TRX.TRX_DATE
    FROM   RA_CUSTOMER_TRX_LINES_ALL TRXL,
           RA_CUSTOMER_TRX_ALL TRX
    WHERE  TRXL.INTERFACE_LINE_CONTEXT    = 'ORDER ENTRY'
    AND    TRXL.INTERFACE_LINE_ATTRIBUTE1 = to_char(p_order_header_number)
    AND    TRXL.INTERFACE_LINE_ATTRIBUTE6 = to_char(p_line_id)
    AND    TRX.CUSTOMER_TRX_ID = TRXL.CUSTOMER_TRX_ID; */

Line: 223

	 SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
				   SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
	 INTO   p_org_id
      FROM   dual;

Line: 257

	SELECT ship_to_org_id
	FROM   CS_ESTIMATE_DETAILS
	WHERE  incident_id = p_qte_header_id
	AND    estimate_detail_id = p_qte_line_id;

Line: 263

	SELECT ship_to_org_id
	FROM   CS_ESTIMATE_DETAILS
	WHERE  incident_id = p_qte_header_id
	AND    estimate_detail_id IS NULL ;

Line: 272

    SELECT account_id
    FROM   CS_INCIDENTS_ALL_B
    WHERE  incident_id = p_qte_header_id;

Line: 277

         SELECT site_use_id
         FROM   hz_cust_site_uses b,
			 hz_cust_acct_sites a
         WHERE b.cust_acct_site_id = a.cust_acct_site_id
         AND   b.site_use_code = 'SHIP_TO' --and b.primary_flag = 'Y'
         AND   a.party_site_id = l_ship_site_id
         AND   a.cust_account_id = l_cust_id;

Line: 338

	SELECT invoice_to_org_id
	FROM   CS_ESTIMATE_DETAILS
	WHERE  estimate_detail_id = p_qte_line_id
     AND    incident_id = p_qte_header_id;

Line: 344

	SELECT invoice_to_org_id
	FROM   CS_ESTIMATE_DETAILS
	WHERE  incident_id = p_qte_header_id;

Line: 356

    SELECT customer_id
    FROM   CS_INCIDENTS_ALL_B
    WHERE  incident_id = p_qte_header_id;

Line: 361

         SELECT site_use_id
         FROM hz_cust_site_uses b,hz_cust_acct_sites a
         WHERE b.cust_acct_site_id = a.cust_acct_site_id
         AND b.site_use_code = 'BILL_TO'
         AND a.party_site_id = l_inv_site_id
         AND a.cust_account_id = l_cust_id;

Line: 442

select party_name||'-'||party_number party_name
  from hz_parties
 where party_id = p_value_object_id
   and nvl(status, 'A') = 'A';

Line: 448

select name
  from cs_incident_types_vl
 where incident_type_id = p_value_object_id;