APPS.PO_VAL_SHIPMENTS SQL Statements

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

Line: 310

  INSERT INTO PO_VALIDATION_RESULTS_GT
  ( result_set_id
  , entity_type
  , entity_id
  , message_name
  )
  SELECT
    x_result_set_id
  , c_ENTITY_TYPE_LINE_LOCATION
  , l_line_loc_id_tbl(i)
  , PO_MESSAGE_S.PO_PO_PLANNED_ITEM_DATE_REQ
  FROM
    FINANCIALS_SYSTEM_PARAMETERS FSP
  , MTL_SYSTEM_ITEMS MSI
  WHERE
      MSI.inventory_item_id = l_item_id_tbl(i)
  AND MSI.organization_id = FSP.inventory_organization_id
  AND
    (     MSI.mrp_planning_code IN (3,4,7,8,9)
      OR  MSI.inventory_planning_code IN (1,2)
    )
  ;

Line: 789

INSERT INTO PO_SESSION_GT SES
( key
, num1
, num2
, num3
, num4 --PBWC Message Change Impact: Adding token
, char1
)
VALUES
( l_data_key
, p_line_loc_id_tbl(i)
, p_org_id_tbl(i)
, p_ship_to_org_id_tbl(i)
, p_line_id_tbl(i) --PBWC Message Change Impact: Adding token
, p_consigned_flag_tbl(i)
)
;

Line: 807

UPDATE PO_SESSION_GT SES
SET (num5) = --PBWC Message Change Impact: Adding token
( SELECT
    FSP.set_of_books_id
  FROM
    FINANCIALS_SYSTEM_PARAMS_ALL FSP
  WHERE
    FSP.org_id = SES.num2
)
WHERE
    SES.key = l_data_key
AND SES.char1 = 'Y'
RETURNING
  SES.num1
, SES.num3
, SES.num4 --PBWC Message Change Impact: Adding token
, SES.num5 --PBWC Message Change Impact: Adding token
BULK COLLECT INTO
  l_line_loc_id_tbl
, l_ship_to_org_id_tbl
, l_line_id_tbl --PBWC Message Change Impact: Adding token
, l_set_of_books_id_tbl
;

Line: 1030

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_LINE_LOCATION
, p_line_loc_id_tbl(i)
, c_QUANTITY
, TO_CHAR(p_quantity_tbl(i))
, (CASE
     WHEN NVL(PLL.quantity_received, 0) >
            GREATEST(NVL(quantity_billed, 0), NVL(quantity_financed, 0))
     --PBWC Message Change Impact: Make it use the same message
     THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_RCVD_NA
     ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
   END
  )
--PBWC Message Change Impact: Adding a token
, (CASE
     WHEN NVL(PLL.quantity_received, 0) >
            GREATEST(NVL(quantity_billed, 0), NVL(quantity_financed, 0))
     THEN PO_MESSAGE_S.c_QTY_RCVD_TOKEN
     ELSE PO_MESSAGE_S.c_QTY_BILLED_TOKEN
   END
  )
, (CASE
     WHEN NVL(PLL.quantity_received, 0) >
            GREATEST(NVL(quantity_billed, 0), NVL(quantity_financed, 0))
     THEN to_char(PLL.quantity_received)
     ELSE to_char(quantity_billed)
   END
  )
--End PBWC Message Change Impact: Adding a token
FROM
  PO_LINE_LOCATIONS_ALL PLL
WHERE
    PLL.line_location_id = p_line_loc_id_tbl(i)
AND PLL.shipment_type IN (c_STANDARD, c_PREPAYMENT)  -- 
AND p_quantity_tbl(i) IS NOT NULL
-- Quantity is being reduced below the current transaction quantity:
AND p_quantity_tbl(i) < PLL.quantity
AND p_quantity_tbl(i) < GREATEST(NVL(PLL.quantity_received, 0),
                                 NVL(PLL.quantity_billed, 0),
                                 NVL(PLL.quantity_financed, 0))
;

Line: 1257

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_LINE_LOCATION
, p_line_loc_id_tbl(i)
, c_AMOUNT
, TO_CHAR(p_amount_tbl(i))
, (CASE
     WHEN NVL(PLL.amount_received, 0) >
            GREATEST(NVL(amount_billed, 0), NVL(amount_financed, 0))
     THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_RCVD_NA
     ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
   END
  )
--PBWC Message Change Impact: Adding a token
, (CASE
     WHEN NVL(PLL.amount_received, 0) >
            GREATEST(NVL(amount_billed, 0), NVL(amount_financed, 0))
     THEN PO_MESSAGE_S.c_AMT_RCVD_TOKEN
     ELSE PO_MESSAGE_S.c_AMT_BILLED_TOKEN
   END
  )
, (CASE
     WHEN NVL(PLL.amount_received, 0) >
            GREATEST(NVL(amount_billed, 0), NVL(amount_financed, 0))
     THEN TO_CHAR(PLL.amount_received)
     ELSE TO_CHAR(amount_billed)
   END
  )
FROM
  PO_LINE_LOCATIONS_ALL PLL
WHERE
    PLL.line_location_id = p_line_loc_id_tbl(i)
AND PLL.shipment_type IN (c_STANDARD, c_PREPAYMENT)  -- 
AND p_amount_tbl(i) IS NOT NULL
-- Amount is being reduced below the current transaction amount:
AND p_amount_tbl(i) < PLL.amount
AND p_amount_tbl(i) < GREATEST(NVL(PLL.amount_received, 0),
                               NVL(PLL.amount_billed, 0),
                               NVL(PLL.amount_financed, 0))
;

Line: 1517

	INSERT INTO po_validation_results_gt
		(result_set_id,
		 entity_type,
		 entity_id,
		 message_name,
		 column_name,
		 column_val)
	SELECT 	x_result_set_id,
		c_entity_type_LINE
		,p_line_loc_id_tbl(i)
		,PO_MESSAGE_S.PO_MOD_CANCEL_INVALID
		,c_CONTROL_ACTION
		,TO_CHAR(p_control_action_tbl(i))
	FROM 	DUAL
	WHERE	nvl(p_control_action_tbl(i), '*') = 'CANCEL'
	AND	not exists
			(SELECT 	'Y'
			FROM	PO_LINE_LOCATIONS_ALL
			WHERE   line_location_id = p_line_loc_id_tbl(i)
			AND 	quantity > quantity_received);

Line: 1610

            , p_column_val_selector => NULL
            , p_message_name        => PO_MESSAGE_S.PO_IDV_LINE_POP_DATES
            , x_results             => x_results
            , x_result_type         => x_result_type
        );