APPS.RCV_TABLE_FUNCTIONS SQL Statements

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

Line: 66

      SELECT *
      INTO   g_rhi_row
      FROM   rcv_headers_interface
      WHERE  header_interface_id = p_header_interface_id;

Line: 77

   PROCEDURE update_rhi_row(
      p_rhi_row IN rcv_headers_interface%ROWTYPE
   ) IS
   BEGIN
      asn_debug.put_line('Updating RHI HEADER_INTERFACE_ID=' || p_rhi_row.header_interface_id);

Line: 83

      UPDATE rcv_headers_interface
         SET ROW = p_rhi_row
       WHERE header_interface_id = p_rhi_row.header_interface_id;

Line: 106

      SELECT *
      INTO   g_rti_row
      FROM   rcv_transactions_interface
      WHERE  interface_transaction_id = p_interface_transaction_id;

Line: 117

   PROCEDURE update_rti_row(
      p_rti_row IN rcv_transactions_interface%ROWTYPE
   ) IS
   BEGIN
      asn_debug.put_line('Updating RTI INTERFACE_TRANSACTION_ID=' || p_rti_row.interface_transaction_id);

Line: 123

      UPDATE rcv_transactions_interface
         SET ROW = p_rti_row
       WHERE interface_transaction_id = p_rti_row.interface_transaction_id
             AND processing_status_code <> 'ERROR'; --BUG: 5598140

Line: 147

      SELECT *
      INTO   g_rt_row
      FROM   rcv_transactions
      WHERE  transaction_id = p_transaction_id;

Line: 187

      SELECT *
      INTO   g_rsh_row
      FROM   rcv_shipment_headers
      WHERE  shipment_num = p_shipment_num
      AND    (   vendor_site_id = NVL(p_vendor_site_id, vendor_site_id)
              OR vendor_site_id IS NULL)
      AND    (   vendor_id = NVL(p_vendor_id, vendor_id)
              OR vendor_id IS NULL)
      AND    ship_to_org_id = NVL(p_ship_to_org_id, ship_to_org_id)
      AND    shipped_date >= ADD_MONTHS(NVL(p_shipped_date, SYSDATE), -12);

Line: 227

      SELECT *
      INTO   g_rsh_row
      FROM   rcv_shipment_headers
      WHERE  shipment_header_id = p_shipment_header_id;

Line: 257

      SELECT *
      INTO   g_rsl_row
      FROM   rcv_shipment_lines
      WHERE  line_num = p_line_num
      AND    shipment_header_id = p_shipment_header_id;

Line: 288

      SELECT *
      INTO   g_rsl_row
      FROM   rcv_shipment_lines
      WHERE  shipment_line_id = p_shipment_line_id;

Line: 299

   PROCEDURE update_rsl_row(
      p_rsl_row IN rcv_shipment_lines%ROWTYPE
   ) IS
   BEGIN
      asn_debug.put_line('Updating RSL SHIPMENT_LINE_ID=' || p_rsl_row.shipment_line_id);

Line: 305

      UPDATE rcv_shipment_lines
       	 SET ROW = p_rsl_row
      WHERE shipment_line_id = p_rsl_row.shipment_line_id;

Line: 330

      SELECT *
      INTO   g_poh_row
      FROM   po_headers_all
      WHERE  po_header_id IN(SELECT po_header_id
                             FROM   po_headers
                             WHERE  segment1 = p_po_num
                             AND    type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
                             AND    org_id = NVL(p_org_id, org_id));

Line: 343

            SELECT *
            INTO   g_poh_row
            FROM   po_headers_all
            WHERE  segment1 = p_po_num
            AND    type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
            AND    org_id = NVL(p_org_id, org_id);

Line: 364

               SELECT *
               INTO   g_poh_row
               FROM   po_headers_all
               WHERE  segment1 = p_po_num
               AND    type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
               AND    org_id = g_default_org_id;

Line: 398

      SELECT *
      INTO   g_poh_row
      FROM   po_headers_all
      WHERE  po_header_id = p_header_id;

Line: 468

      SELECT *
      INTO   g_pol_row
      FROM   po_lines_all
      WHERE  po_line_id IN(SELECT po_line_id
                           FROM   po_lines
                           WHERE  po_header_id = p_header_id
                           AND    (   line_num = x_line_num
                                   OR x_line_num IS NULL)
                           AND    (  item_id   = x_item_id
 	                                OR x_item_id IS NULL )
                           AND    (   item_description = x_item_description
                                   OR x_item_description IS NULL)
                           AND    (   vendor_product_num = x_vendor_product_num
                                   OR x_vendor_product_num IS NULL));

Line: 487

            SELECT *
            INTO   g_pol_row
            FROM   po_lines_all
            WHERE  po_header_id = p_header_id
            AND    (   line_num = x_line_num
                    OR x_line_num IS NULL)
            AND    (  item_id   = x_item_id
                    OR x_item_id IS NULL )
            AND    (   item_description = x_item_description
                    OR x_item_description IS NULL)
            AND    (   vendor_product_num = x_vendor_product_num
                    OR x_vendor_product_num IS NULL);

Line: 532

      SELECT *
      INTO   g_pol_row
      FROM   po_lines_all
      WHERE  po_line_id = p_line_id;

Line: 563

      SELECT *
      INTO   g_pll_row
      FROM   po_line_locations_all
      WHERE  line_location_id IN(SELECT line_location_id
                                 FROM   po_line_locations
                                 WHERE  shipment_num = p_shipment_num
                                 AND    po_line_id = p_line_id);

Line: 575

            SELECT *
            INTO   g_pll_row
            FROM   po_line_locations_all
            WHERE  shipment_num = p_shipment_num
            AND    po_line_id = p_line_id;

Line: 613

      SELECT *
      INTO   g_pll_row
      FROM   po_line_locations_all
      WHERE  line_location_id = p_line_location_id;

Line: 644

      SELECT *
      INTO   g_pod_row
      FROM   po_distributions_all
      WHERE  po_distribution_id IN(SELECT po_distribution_id
                                   FROM   po_distributions
                                   WHERE  distribution_num = p_distribution_num
                                   AND    line_location_id = p_line_location_id);

Line: 656

            SELECT *
            INTO   g_pod_row
            FROM   po_distributions_all
            WHERE  distribution_num = p_distribution_num
            AND    line_location_id = p_line_location_id;

Line: 694

      SELECT *
      INTO   g_pod_row
      FROM   po_distributions_all
      WHERE  po_distribution_id = p_distribution_id;

Line: 731

      SELECT   *
      INTO     g_oeh_row
      FROM     oe_order_headers_all
      WHERE    header_id IN(SELECT header_id
                            FROM   oe_order_headers
                            WHERE  order_number = p_order_number
                            AND    order_type_id = NVL(p_order_type_id, order_type_id)
                            AND    version_number = NVL(p_version_number, version_number)
                            AND    org_id = NVL(p_org_id, org_id))
      AND      ROWNUM = 1
      ORDER BY version_number DESC;

Line: 747

            SELECT   *
            INTO     g_oeh_row
            FROM     oe_order_headers_all
            WHERE    order_number = p_order_number
            AND      order_type_id = NVL(p_order_type_id, order_type_id)
            AND      version_number = NVL(p_version_number, version_number)
            AND      org_id = NVL(p_org_id, org_id)
            AND      ROWNUM = 1
            ORDER BY version_number DESC;

Line: 771

               SELECT   *
               INTO     g_oeh_row
               FROM     oe_order_headers_all
               WHERE    order_number = p_order_number
               AND      order_type_id = NVL(p_order_type_id, order_type_id)
               AND      version_number = NVL(p_version_number, version_number)
               AND      org_id = g_default_org_id
               AND      ROWNUM = 1
               ORDER BY version_number DESC;

Line: 808

      SELECT *
      INTO   g_oeh_row
      FROM   oe_order_headers_all
      WHERE  header_id = p_header_id;

Line: 839

      SELECT *
      INTO   g_oel_row
      FROM   oe_order_lines_all
      WHERE  line_id IN(SELECT line_id
                        FROM   oe_order_lines
                        WHERE  line_number = p_line_number
                        AND    header_id = p_header_id
                        AND    flow_status_code = 'AWAITING_RETURN');

Line: 852

            SELECT *
            INTO   g_oel_row
            FROM   oe_order_lines_all
            WHERE  line_number = p_line_number
            AND    header_id = p_header_id
            AND    flow_status_code = 'AWAITING_RETURN';

Line: 891

      SELECT *
      INTO   g_oel_row
      FROM   oe_order_lines_all
      WHERE  line_id = p_line_id;

Line: 915

      SELECT *
      INTO   g_prl_row
      FROM   po_requisition_lines_all
      WHERE  requisition_line_id = p_requisition_line_id;

Line: 939

      SELECT *
      INTO   g_prd_row
      FROM   po_req_distributions_all
      WHERE  distribution_id = p_req_distribution_id;

Line: 964

		SELECT *
		INTO   g_msi_row
		FROM   mtl_system_items
		WHERE  inventory_item_id = p_item_id
		AND	   organization_id = p_org_id;

Line: 990

		SELECT *
		INTO   g_mic_row
		FROM   mtl_item_categories
		WHERE  inventory_item_id = p_item_id
		AND	   organization_id = p_org_id;

Line: 1013

		SELECT *
		INTO   g_mp_row
		FROM   mtl_parameters
		WHERE  organization_id = p_org_id
		AND    rownum = 1;

Line: 1036

		SELECT *
		INTO   g_rp_row
		FROM   rcv_parameters
		WHERE  organization_id = p_org_id
		AND    rownum = 1;

Line: 1059

		SELECT *
		INTO   g_fc_row
		FROM   fnd_currencies
		WHERE  currency_code = p_currency_code;

Line: 1074

			SELECT *
			INTO   g_fsp_row
			FROM   financials_system_parameters;

Line: 1093

		SELECT *
		INTO   g_pvs_row
		FROM   po_vendor_sites_all
		WHERE  vendor_site_id = p_vendor_site_id;

Line: 1112

		SELECT *
		INTO   g_muom_row
		FROM   mtl_units_of_measure
		WHERE  unit_of_measure = p_unit_of_measure;

Line: 1127

			SELECT displayed_field
			  INTO g_po_lookups(l_key)
			  FROM po_lookup_codes
			 WHERE lookup_type = p_lookup_type
			   AND lookup_code = p_lookup_code
			   AND enabled_flag = 'Y';

Line: 1146

	       SELECT nvl(lcm_flag,'N')
	       INTO   g_lcm_flag
	       FROM   po_line_locations_all
	       WHERE  line_location_id = p_po_line_location_id;

Line: 1164

	       SELECT nvl(lcm_enabled_flag,'N')
	       INTO   g_lcm_enabled_flag
	       FROM   mtl_parameters
	       WHERE  organization_id = p_organization_id;

Line: 1182

	       SELECT nvl(pre_receive,'N')
	       INTO   g_pre_rcv_flag
	       FROM   rcv_parameters
	       WHERE  organization_id = p_organization_id;