APPS.PO_VAL_DISTRIBUTIONS SQL Statements

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

Line: 199

INSERT INTO PO_VALIDATION_RESULTS_GT
( result_set_id
, entity_type
, entity_id
, column_name
, column_val
, message_name
--PBWC Message Change Impact: Adding a token
, token1_name
, token1_value
)
SELECT
  x_result_set_id
, c_ENTITY_TYPE_DISTRIBUTION
, p_dist_id_tbl(i)
, C_QUANTITY_ORDERED
, TO_CHAR(p_qty_ordered_tbl(i))
, (CASE
     WHEN NVL(POD.quantity_delivered, 0) >
           GREATEST(NVL(POD.quantity_billed, 0), NVL(POD.quantity_financed, 0))
     THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_DEL_NA
     ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
   END
  )
--PBWC Message Change Impact: Adding a token
, (CASE
     WHEN NVL(POD.quantity_delivered, 0) >
           GREATEST(NVL(POD.quantity_billed, 0), NVL(POD.quantity_financed, 0))
     THEN PO_MESSAGE_S.c_QTY_DEL_token
     ELSE PO_MESSAGE_S.c_QTY_BILLED_token
   END
  )
, (CASE
     WHEN NVL(POD.quantity_delivered, 0) >
           GREATEST(NVL(POD.quantity_billed, 0), NVL(POD.quantity_financed, 0))
     THEN TO_CHAR(POD.quantity_delivered)
     ELSE TO_CHAR(POD.quantity_billed)
   END
  )
FROM
  PO_DISTRIBUTIONS_ALL POD
WHERE
    POD.po_distribution_id = p_dist_id_tbl(i)
AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT) -- 
-- Quantity is being reduced below the current transaction quantity:
AND p_qty_ordered_tbl(i) < POD.quantity_ordered
AND p_qty_ordered_tbl(i) <  -- 
       GREATEST(NVL(POD.quantity_delivered, 0),
                NVL(POD.quantity_billed, 0),
                NVL(POD.quantity_financed, 0))
;

Line: 335

INSERT INTO PO_VALIDATION_RESULTS_GT
( result_set_id
, entity_type
, entity_id
, column_name
, column_val
, message_name
--PBWC Message Change Impact: Adding a token
, token1_name
, token1_value
)
SELECT
  x_result_set_id
, c_ENTITY_TYPE_DISTRIBUTION
, p_dist_id_tbl(i)
, C_AMOUNT_ORDERED
, TO_CHAR(p_amt_ordered_tbl(i))
, (CASE
     WHEN NVL(POD.amount_delivered, 0) >
           GREATEST(NVL(POD.amount_billed, 0), NVL(POD.amount_financed, 0))
     THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_DEL_NA
     ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
   END
  )
--PBWC Message Change Impact: Adding a token
, (CASE
     WHEN NVL(POD.amount_delivered, 0) >
           GREATEST(NVL(POD.amount_billed, 0), NVL(POD.amount_financed, 0))
     THEN PO_MESSAGE_S.c_AMT_DEL_token
     ELSE PO_MESSAGE_S.c_AMT_BILLED_token
   END
  )
, (CASE
     WHEN NVL(POD.amount_delivered, 0) >
           GREATEST(NVL(POD.amount_billed, 0), NVL(POD.amount_financed, 0))
     THEN TO_CHAR(POD.amount_delivered)
     ELSE TO_CHAR(POD.amount_billed)
   END
  )
FROM
  PO_DISTRIBUTIONS_ALL POD
WHERE
    POD.po_distribution_id = p_dist_id_tbl(i)
AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT)  -- 
-- Amount is being reduced below the current transaction amount:
AND p_amt_ordered_tbl(i) < POD.amount_ordered
AND p_amt_ordered_tbl(i) < GREATEST(NVL(POD.amount_delivered, 0),
                                    NVL(POD.amount_financed, 0),
                                    NVL(POD.amount_billed, 0));

Line: 540

  SELECT outside_operation_flag
    INTO l_outside_operation_flag
    FROM po_line_types
   WHERE line_type_id = p_line_line_type_id_tbl(i);

Line: 757

  SELECT purch_encumbrance_flag, set_of_books_id
  INTO l_po_enc_flag, l_sob_id
  FROM financials_system_params_all
  WHERE org_id = p_org_id_tbl(i);

Line: 920

    SELECT set_of_books_id
    INTO  l_ledger_id
    FROM financials_system_params_all
    WHERE org_id = p_org_id_tbl(i);