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: 363

    SELECT
      currency_code
    INTO
      l_gl_currency
    FROM
      GL_sets_of_books
    WHERE set_of_books_id = l_sob_id ;

Line: 939

      SELECT org_id
      INTO   l_org_id
      FROM   hz_cust_site_uses_all
      WHERE  site_use_id = p_site_id;