APPS.OE_CREDIT_ENGINE_GRP SQL Statements

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

Line: 65

  SELECT item_type,
         activity_name
  INTO   G_cc_hold_item_type,
         G_cc_hold_activity_name
  FROM   oe_hold_definitions
  WHERE  hold_id = 1;

Line: 122

  IF p_calling_action in ('BOOKING','BOOKING_INLINE','UPDATE',
                          'AUTO HOLD', 'AUTO RELEASE')
  THEN

/*7194250
    SELECT ENTRY_CREDIT_CHECK_RULE_ID
    INTO   x_credit_rule_id
    FROM   OE_ORDER_TYPES_V
    WHERE  ORDER_TYPE_ID = p_order_type_id;

Line: 133

    SELECT ENTRY_CREDIT_CHECK_RULE_ID
    INTO   x_credit_rule_id
    FROM   OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
    WHERE  ORDER_TYPE_ID = p_order_type_id
    AND   ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
    AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));

Line: 146

    SELECT SHIPPING_CREDIT_CHECK_RULE_ID
    INTO   x_credit_rule_id
    FROM   OE_ORDER_TYPES_V
    WHERE  ORDER_TYPE_ID = p_order_type_id;

Line: 152

    SELECT SHIPPING_CREDIT_CHECK_RULE_ID
    INTO   x_credit_rule_id
    FROM   OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
    WHERE  ORDER_TYPE_ID = p_order_type_id
    AND   SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
    AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));

Line: 165

    SELECT PACKING_CREDIT_CHECK_RULE_ID
    INTO   x_credit_rule_id
    FROM   OE_ORDER_TYPES_V
    WHERE  ORDER_TYPE_ID = p_order_type_id;

Line: 171

    SELECT PACKING_CREDIT_CHECK_RULE_ID
    INTO   x_credit_rule_id
    FROM   OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
    WHERE  ORDER_TYPE_ID = p_order_type_id
    AND   PACKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
    AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));

Line: 184

    SELECT PICKING_CREDIT_CHECK_RULE_ID
    INTO   x_credit_rule_id
    FROM   OE_ORDER_TYPES_V
    WHERE  ORDER_TYPE_ID = p_order_type_id;

Line: 190

    SELECT PICKING_CREDIT_CHECK_RULE_ID
    INTO   x_credit_rule_id
    FROM   OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
    WHERE  ORDER_TYPE_ID = p_order_type_id
    AND   PICKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
    AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));

Line: 317

SELECT OHR.Released_Order_Amount,OHR.Released_Curr_code
FROM OE_ORDER_HOLDS OOH,
OE_HOLD_SOURCES_ALL OHS,
OE_HOLD_RELEASES OHR
WHERE OOH.HOLD_SOURCE_ID = OHS.HOLD_SOURCE_ID
AND OOH.HEADER_ID = p_header_id
AND OOH.HOLD_RELEASE_ID IS NOT NULL
AND OHS.HOLD_ID = 1
AND OHS.HOLD_ENTITY_CODE = 'O'
AND OHS.HOLD_ENTITY_ID = p_header_id
AND OHS.RELEASED_FLAG ='Y'
AND OHR.HOLD_RELEASE_ID = OOH.HOLD_RELEASE_ID
ORDER BY OHR.creation_date DESC;

Line: 606

    SELECT
      currency_code
    INTO
      l_gl_currency
    FROM
      GL_sets_of_books
    WHERE set_of_books_id = l_sob_id ;

Line: 1187

      SELECT org_id
      INTO   l_org_id
      FROM   hz_cust_site_uses_all
      WHERE  site_use_id = p_site_id;