DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PON_AUC_PAYMENTS_SHIPMENTS

Line 2959: pon_auc_payments_shipments pay,

2955: ,null amount_display
2956: ,null bid_promised_date
2957:
2958: FROM
2959: pon_auc_payments_shipments pay,
2960: pa_projects_all proj,
2961: pa_tasks_expend_v task,
2962: gms_awards_all awrd,
2963: hr_locations_all hrl,

Line 3034: pon_auc_payments_shipments pay,

3030: ,decode(p_user_view_type, 'BUYER', pon_printing_pkg.format_price(pbp.price, l_price_mask,l_price_precision), pon_printing_pkg.format_price(pbp.bid_currency_price,l_price_mask,l_price_precision)) pay_item_price
3031: ,to_char(decode(pbp.quantity,null,decode(pbip.quantity, null, 1,pbip.quantity),pbp.quantity)*decode(p_user_view_type, 'BUYER',pbp.price,pbp.bid_currency_price), l_amount_mask) amount_display
3032: ,pon_oa_util_pkg.display_date_time(pbp.promised_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') bid_promised_date
3033: FROM
3034: pon_auc_payments_shipments pay,
3035: pa_projects_all proj,
3036: pa_tasks_expend_v task,
3037: gms_awards_all awrd,
3038: hr_locations_all hrl,

Line 4354: ad.entity_name IN ('PON_AUC_PAYMENTS_SHIPMENTS')

4350: fnd_document_categories categories,
4351: fnd_document_categories_tl categories_tl
4352: where d.document_id = ad.document_id
4353: and
4354: ad.entity_name IN ('PON_AUC_PAYMENTS_SHIPMENTS')
4355: and ad.pk1_value = to_char(p_auction_header_id)
4356: and (l_is_buyer_negpdf = 'Y' or categories.name = 'Vendor')
4357: and categories.category_id = d.category_id
4358: and categories.category_id = categories_tl.category_id