DBA Data[Home] [Help]

APPS.PON_SOURCING_OPENAPI_GRP dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 1561: FROM pon_auction_item_prices_ext_b ext,po_uda_ag_template_usages usage

1557: BEGIN
1558: UPDATE pon_auction_item_prices_all paip
1559: SET clm_amount =
1560: (SELECT N_EXT_ATTR20
1561: FROM pon_auction_item_prices_ext_b ext,po_uda_ag_template_usages usage
1562: WHERE ext.auction_header_id = paip.auction_header_id
1563: AND ext.line_number = paip.LINE_NUMBER
1564: AND usage.TEMPLATE_ID = paip.UDA_TEMPLATE_ID
1565: AND usage.ATTRIBUTE1 = paip.CLM_IDC_TYPE