eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_LINES dependencies on PO_MESSAGE_S

Line 186: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

182: , p_value_tbl => p_committed_amount_tbl
183: , p_entity_id_tbl => p_line_id_tbl
184: , p_entity_type => c_ENTITY_TYPE_LINE
185: , p_column_name => c_COMMITTED_AMOUNT
186: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
187: , x_results => x_results
188: , x_result_type => x_result_type
189: );
190:

Line 213: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

209: , p_value_tbl => p_min_release_amount_tbl
210: , p_entity_id_tbl => p_line_id_tbl
211: , p_entity_type => c_ENTITY_TYPE_LINE
212: , p_column_name => c_MIN_RELEASE_AMOUNT
213: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
214: , x_results => x_results
215: , x_result_type => x_result_type
216: );
217:

Line 300: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA

296: , c_QUANTITY
297: , TO_CHAR(p_quantity_tbl(i))
298: , (CASE
299: WHEN POLL_TOTAL.qty_bill_actuals = POLL_TOTAL.qty_executed
300: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
301: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_RCVD_NA
302: END
303: )
304: , (CASE

Line 301: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_RCVD_NA

297: , TO_CHAR(p_quantity_tbl(i))
298: , (CASE
299: WHEN POLL_TOTAL.qty_bill_actuals = POLL_TOTAL.qty_executed
300: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
301: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_RCVD_NA
302: END
303: )
304: , (CASE
305: WHEN POLL_TOTAL.qty_bill_actuals = POLL_TOTAL.qty_executed

Line 306: THEN PO_MESSAGE_S.c_QTY_BILLED_token

302: END
303: )
304: , (CASE
305: WHEN POLL_TOTAL.qty_bill_actuals = POLL_TOTAL.qty_executed
306: THEN PO_MESSAGE_S.c_QTY_BILLED_token
307: ELSE PO_MESSAGE_S.c_QTY_RCVD_token
308: END
309: )
310: , (CASE

Line 307: ELSE PO_MESSAGE_S.c_QTY_RCVD_token

303: )
304: , (CASE
305: WHEN POLL_TOTAL.qty_bill_actuals = POLL_TOTAL.qty_executed
306: THEN PO_MESSAGE_S.c_QTY_BILLED_token
307: ELSE PO_MESSAGE_S.c_QTY_RCVD_token
308: END
309: )
310: , (CASE
311: WHEN POLL_TOTAL.qty_bill_actuals = POLL_TOTAL.qty_executed

Line 406: , p_message_name => PO_MESSAGE_S.PO_ADVANCE_GT_LINE_AMOUNT

402: x_results.add_result(
403: p_entity_type => c_ENTITY_TYPE_LINE
404: , p_entity_id => p_line_id_tbl(i)
405: , p_column_name => c_AMOUNT
406: , p_message_name => PO_MESSAGE_S.PO_ADVANCE_GT_LINE_AMOUNT
407: );
408: END IF;
409: END LOOP;
410:

Line 468: , PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_ENC_NA

464: , c_ENTITY_TYPE_LINE
465: , p_line_id_tbl(i)
466: , c_QUANTITY
467: , TO_CHAR(p_quantity_tbl(i))
468: , PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_ENC_NA
469: --PBWC Message Change Impact: Removing a token
470: --, PO_MESSAGE_S.c_QTY_ORD_token
471: --, TO_CHAR(p_quantity_tbl(i))
472: , PO_MESSAGE_S.c_QTY_ENC_token

Line 470: --, PO_MESSAGE_S.c_QTY_ORD_token

466: , c_QUANTITY
467: , TO_CHAR(p_quantity_tbl(i))
468: , PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_ENC_NA
469: --PBWC Message Change Impact: Removing a token
470: --, PO_MESSAGE_S.c_QTY_ORD_token
471: --, TO_CHAR(p_quantity_tbl(i))
472: , PO_MESSAGE_S.c_QTY_ENC_token
473: , TO_CHAR(DIST_TOTAL.quantity_encumbered)
474: FROM

Line 472: , PO_MESSAGE_S.c_QTY_ENC_token

468: , PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_ENC_NA
469: --PBWC Message Change Impact: Removing a token
470: --, PO_MESSAGE_S.c_QTY_ORD_token
471: --, TO_CHAR(p_quantity_tbl(i))
472: , PO_MESSAGE_S.c_QTY_ENC_token
473: , TO_CHAR(DIST_TOTAL.quantity_encumbered)
474: FROM
475: ( SELECT NVL(SUM(POD.quantity_ordered),0) quantity_encumbered
476: FROM

Line 527: , p_message_name => PO_MESSAGE_S.PO_PO_NFC_QTY_CHANGE

523: p_calling_module => D_quantity_notif_change
524: , p_line_id_tbl => p_line_id_tbl
525: , p_quantity_tbl => p_quantity_tbl
526: , p_column_name => c_QUANTITY
527: , p_message_name => PO_MESSAGE_S.PO_PO_NFC_QTY_CHANGE
528: , x_result_set_id => x_result_set_id
529: , x_result_type => x_result_type
530: );
531:

Line 654: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA

650: , c_AMOUNT
651: , TO_CHAR(p_amount_tbl(i))
652: , (CASE
653: WHEN POLL_TOTAL.amt_bill_actuals = POLL_TOTAL.amt_executed
654: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
655: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_RCVD_NA
656: END
657: )
658: --PBWC Message Change Impact: Adding a token

Line 655: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_RCVD_NA

651: , TO_CHAR(p_amount_tbl(i))
652: , (CASE
653: WHEN POLL_TOTAL.amt_bill_actuals = POLL_TOTAL.amt_executed
654: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
655: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_RCVD_NA
656: END
657: )
658: --PBWC Message Change Impact: Adding a token
659: , (CASE

Line 661: THEN PO_MESSAGE_S.c_AMT_BILLED_TOKEN

657: )
658: --PBWC Message Change Impact: Adding a token
659: , (CASE
660: WHEN POLL_TOTAL.amt_bill_actuals = POLL_TOTAL.amt_executed
661: THEN PO_MESSAGE_S.c_AMT_BILLED_TOKEN
662: ELSE PO_MESSAGE_S.c_AMT_RCVD_TOKEN
663: END
664: )
665: , (CASE

Line 662: ELSE PO_MESSAGE_S.c_AMT_RCVD_TOKEN

658: --PBWC Message Change Impact: Adding a token
659: , (CASE
660: WHEN POLL_TOTAL.amt_bill_actuals = POLL_TOTAL.amt_executed
661: THEN PO_MESSAGE_S.c_AMT_BILLED_TOKEN
662: ELSE PO_MESSAGE_S.c_AMT_RCVD_TOKEN
663: END
664: )
665: , (CASE
666: WHEN POLL_TOTAL.amt_bill_actuals = POLL_TOTAL.amt_executed

Line 859: , p_message_name => PO_MESSAGE_S.PO_CHNG_OTL_INVALID_AMOUNT

855: p_entity_type => c_ENTITY_TYPE_LINE
856: , p_entity_id => l_line_id_tbl(i)
857: , p_column_name => c_AMOUNT
858: , p_column_val => TO_CHAR(l_amount_tbl(i))
859: , p_message_name => PO_MESSAGE_S.PO_CHNG_OTL_INVALID_AMOUNT
860: , p_token1_name => PO_MESSAGE_S.c_TOTAL_AMT_token
861: , p_token1_value => l_timecard_amount_sum
862: );
863:

Line 860: , p_token1_name => PO_MESSAGE_S.c_TOTAL_AMT_token

856: , p_entity_id => l_line_id_tbl(i)
857: , p_column_name => c_AMOUNT
858: , p_column_val => TO_CHAR(l_amount_tbl(i))
859: , p_message_name => PO_MESSAGE_S.PO_CHNG_OTL_INVALID_AMOUNT
860: , p_token1_name => PO_MESSAGE_S.c_TOTAL_AMT_token
861: , p_token1_value => l_timecard_amount_sum
862: );
863:
864: END IF;

Line 941: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

937: , p_value_tbl => p_line_num_tbl
938: , p_entity_id_tbl => p_line_id_tbl
939: , p_entity_type => c_ENTITY_TYPE_LINE
940: , p_column_name => c_LINE_NUM
941: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
942: , x_results => x_results
943: , x_result_type => x_result_type
944: );
945:

Line 1012: , PO_MESSAGE_S.PO_VMI_ASL_EXIST

1008: , c_ENTITY_TYPE_LINE
1009: , p_line_id_tbl(i)
1010: , c_ITEM_ID
1011: , TO_CHAR(p_item_id_tbl(i))
1012: , PO_MESSAGE_S.PO_VMI_ASL_EXIST
1013: FROM
1014: PO_APPROVED_SUPPLIER_LIS_VAL_V PASL
1015: , PO_ASL_ATTRIBUTES PAA
1016: , PO_ASL_STATUS_RULES_V PASR

Line 1083: , p_message_name => PO_MESSAGE_S.PO_SVC_ASSIGNMENT_DATES

1079: , p_entity_id_tbl => p_line_id_tbl
1080: , p_entity_type => c_ENTITY_TYPE_LINE
1081: , p_column_name => c_START_DATE
1082: , p_column_val_selector => NULL
1083: , p_message_name => PO_MESSAGE_S.PO_SVC_ASSIGNMENT_DATES
1084: , x_results => x_results
1085: , x_result_type => x_result_type
1086: );
1087:

Line 1115: , p_message_name => PO_MESSAGE_S.PO_CHNG_OTL_INVALID_START_DATE

1111: , p_line_id_tbl => p_line_id_tbl
1112: , p_start_date_tbl => p_start_date_tbl
1113: , p_expiration_date_tbl => NULL
1114: , p_column_name => c_START_DATE
1115: , p_message_name => PO_MESSAGE_S.PO_CHNG_OTL_INVALID_START_DATE
1116: , x_results => x_results
1117: , x_result_type => x_result_type
1118: );
1119:

Line 1148: , p_message_name => PO_MESSAGE_S.PO_CHNG_OTL_INVALID_END_DATE

1144: , p_line_id_tbl => p_line_id_tbl
1145: , p_start_date_tbl => NULL
1146: , p_expiration_date_tbl => p_expiration_date_tbl
1147: , p_column_name => c_EXPIRATION_DATE
1148: , p_message_name => PO_MESSAGE_S.PO_CHNG_OTL_INVALID_END_DATE
1149: , x_results => x_results
1150: , x_result_type => x_result_type
1151: );
1152:

Line 1210: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

1206: , p_value_tbl => l_unit_price_tbl
1207: , p_entity_id_tbl => l_line_id_tbl
1208: , p_entity_type => c_ENTITY_TYPE_LINE
1209: , p_column_name => c_UNIT_PRICE
1210: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
1211: , x_results => x_results
1212: , x_result_type => x_result_type
1213: );
1214:

Line 1244: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

1240: , p_value_tbl => p_list_price_per_unit_tbl
1241: , p_entity_id_tbl => p_line_id_tbl
1242: , p_entity_type => c_ENTITY_TYPE_LINE
1243: , p_column_name => c_LIST_PRICE_PER_UNIT
1244: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
1245: , x_results => x_results
1246: , x_result_type => x_result_type
1247: );
1248:

Line 1271: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

1267: , p_value_tbl => p_market_price_tbl
1268: , p_entity_id_tbl => p_line_id_tbl
1269: , p_entity_type => c_ENTITY_TYPE_LINE
1270: , p_column_name => c_MARKET_PRICE
1271: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
1272: , x_results => x_results
1273: , x_result_type => x_result_type
1274: );
1275:

Line 1404: , p_message_name => PO_MESSAGE_S.POX_EXPIRATION_DATES

1400: , p_entity_id_tbl => p_line_id_tbl
1401: , p_entity_type => c_entity_type_LINE
1402: , p_column_name => c_EXPIRATION_DATE
1403: , p_column_val_selector => PO_VALIDATION_HELPER.c_END_DATE
1404: , p_message_name => PO_MESSAGE_S.POX_EXPIRATION_DATES
1405: , x_results => x_results
1406: , x_result_type => x_result_type
1407: );
1408:

Line 1436: , p_message_name => PO_MESSAGE_S.POX_EXPIRATION_DATES

1432: , p_entity_id_tbl => p_line_id_tbl
1433: , p_entity_type => c_entity_type_LINE
1434: , p_column_name => c_EXPIRATION_DATE
1435: , p_column_val_selector => PO_VALIDATION_HELPER.c_START_DATE
1436: , p_message_name => PO_MESSAGE_S.POX_EXPIRATION_DATES
1437: , x_results => x_results
1438: , x_result_type => x_result_type
1439: );
1440:

Line 1466: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT

1462: , p_value_tbl => p_recoupment_rate_tbl
1463: , p_entity_id_tbl => p_line_id_tbl
1464: , p_entity_type => c_ENTITY_TYPE_LINE
1465: , p_column_name => c_RECOUPMENT_RATE
1466: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT
1467: , x_results => x_results
1468: , x_result_type => x_result_type
1469: );
1470:

Line 1489: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT

1485: , p_value_tbl => p_retainage_rate_tbl
1486: , p_entity_id_tbl => p_line_id_tbl
1487: , p_entity_type => c_ENTITY_TYPE_LINE
1488: , p_column_name => c_RETAINAGE_RATE
1489: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT
1490: , x_results => x_results
1491: , x_result_type => x_result_type
1492: );
1493:

Line 1512: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT

1508: , p_value_tbl => p_prog_pay_rate_tbl
1509: , p_entity_id_tbl => p_line_id_tbl
1510: , p_entity_type => c_ENTITY_TYPE_LINE
1511: , p_column_name => c_PROGRESS_PAYMENT_RATE
1512: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT
1513: , x_results => x_results
1514: , x_result_type => x_result_type
1515: );
1516:

Line 1548: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL

1544: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1545: END IF;
1546:
1547: -- : Fill in the following messages
1548: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL
1549: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_RECV
1550:
1551: FORALL i IN 1 .. p_line_id_tbl.COUNT
1552: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 1549: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_RECV

1545: END IF;
1546:
1547: -- : Fill in the following messages
1548: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL
1549: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_RECV
1550:
1551: FORALL i IN 1 .. p_line_id_tbl.COUNT
1552: INSERT INTO PO_VALIDATION_RESULTS_GT
1553: ( result_set_id

Line 1643: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL

1639: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1640: END IF;
1641:
1642: -- : Fill in the following messages
1643: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL
1644:
1645: FORALL i IN 1 .. p_line_id_tbl.COUNT
1646: INSERT INTO PO_VALIDATION_RESULTS_GT
1647: ( result_set_id

Line 1744: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1740: x_results.add_result(
1741: p_entity_type => c_ENTITY_TYPE_LINE
1742: , p_entity_id => p_line_id_tbl(i)
1743: , p_column_name => c_UNIT_MEAS_LOOKUP_CODE
1744: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1745: );
1746: END IF;
1747: END LOOP;
1748:

Line 1788: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1784: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_item_description_tbl)
1785: , p_entity_id_tbl => p_line_id_tbl
1786: , p_entity_type => c_entity_type_LINE
1787: , p_column_name => c_ITEM_DESCRIPTION
1788: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1789: , x_results => x_results
1790: , x_result_type => x_result_type
1791: );
1792:

Line 1814: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1810: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_category_id_tbl)
1811: , p_entity_id_tbl => p_line_id_tbl
1812: , p_entity_type => c_entity_type_LINE
1813: , p_column_name => c_CATEGORY_ID
1814: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1815: , x_results => x_results
1816: , x_result_type => x_result_type
1817: );
1818:

Line 1966: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1962: x_results.add_result(
1963: p_entity_type => c_ENTITY_TYPE_LINE
1964: , p_entity_id => p_line_id_tbl(i)
1965: , p_column_name => c_JOB_ID
1966: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1967: );
1968: END IF;
1969: END LOOP;
1970:

Line 2029: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

2025: x_results.add_result(
2026: p_entity_type => c_ENTITY_TYPE_LINE
2027: , p_entity_id => p_line_id_tbl(i)
2028: , p_column_name => c_FROM_LINE_ID
2029: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2030: );
2031: END IF;
2032: END LOOP;
2033:

Line 2071: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

2067: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_type_id_tbl)
2068: , p_entity_id_tbl => p_line_id_tbl
2069: , p_entity_type => c_entity_type_LINE
2070: , p_column_name => c_LINE_TYPE_ID
2071: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2072: , x_results => x_results
2073: , x_result_type => x_result_type
2074: );
2075:

Line 2115: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

2111: x_results.add_result(
2112: p_entity_type => c_ENTITY_TYPE_LINE
2113: , p_entity_id => p_line_id_tbl(i)
2114: , p_column_name => c_START_DATE
2115: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2116: );
2117: END IF;
2118: END LOOP;
2119:

Line 2328: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

2324: x_results.add_result(
2325: p_entity_type => c_ENTITY_TYPE_LINE
2326: , p_entity_id => p_line_id_tbl(i)
2327: , p_column_name => c_FROM_LINE_ID
2328: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2329: );
2330: END IF; -- IF ((l_src_doc_type_lookup_code = c_BLANKET
2331:
2332: END IF; -- IF (l_from_header_id <> NULL)

Line 2378: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

2374: , p_value_tbl => p_max_retain_amt_tbl
2375: , p_entity_id_tbl => p_line_id_tbl
2376: , p_entity_type => c_ENTITY_TYPE_LINE
2377: , p_column_name => c_MAX_RETAINAGE_AMOUNT
2378: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
2379: , x_results => x_results
2380: , x_result_type => x_result_type
2381: );
2382:

Line 2432: , PO_MESSAGE_S.PO_MAX_RET_AMT_GE_RETAINED

2428: , c_ENTITY_TYPE_LINE
2429: , p_line_id_tbl(i)
2430: , c_MAX_RETAINAGE_AMOUNT
2431: , TO_CHAR(p_max_retain_amt_tbl(i))
2432: , PO_MESSAGE_S.PO_MAX_RET_AMT_GE_RETAINED
2433: , PO_MESSAGE_S.c_MAX_RET_AMT_token
2434: , TO_CHAR(p_max_retain_amt_tbl(i))
2435: , PO_MESSAGE_S.c_AMT_RETAINED_token
2436: , TO_CHAR(LOCATIONS_TOTAL.amount_retained)

Line 2433: , PO_MESSAGE_S.c_MAX_RET_AMT_token

2429: , p_line_id_tbl(i)
2430: , c_MAX_RETAINAGE_AMOUNT
2431: , TO_CHAR(p_max_retain_amt_tbl(i))
2432: , PO_MESSAGE_S.PO_MAX_RET_AMT_GE_RETAINED
2433: , PO_MESSAGE_S.c_MAX_RET_AMT_token
2434: , TO_CHAR(p_max_retain_amt_tbl(i))
2435: , PO_MESSAGE_S.c_AMT_RETAINED_token
2436: , TO_CHAR(LOCATIONS_TOTAL.amount_retained)
2437: FROM

Line 2435: , PO_MESSAGE_S.c_AMT_RETAINED_token

2431: , TO_CHAR(p_max_retain_amt_tbl(i))
2432: , PO_MESSAGE_S.PO_MAX_RET_AMT_GE_RETAINED
2433: , PO_MESSAGE_S.c_MAX_RET_AMT_token
2434: , TO_CHAR(p_max_retain_amt_tbl(i))
2435: , PO_MESSAGE_S.c_AMT_RETAINED_token
2436: , TO_CHAR(LOCATIONS_TOTAL.amount_retained)
2437: FROM
2438: ( SELECT NVL(SUM(POLL.retainage_withheld_amount),0) amount_retained
2439: FROM