DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PON_AUC_PAYMENTS_SHIPMENTS

Line 2400: pon_auc_payments_shipments pay,

2396: ,null amount_display
2397: ,null bid_promised_date
2398:
2399: FROM
2400: pon_auc_payments_shipments pay,
2401: pa_projects_all proj,
2402: pa_tasks task,
2403: gms_awards_all awrd,
2404: hr_locations_all hrl,

Line 2476: pon_auc_payments_shipments pay,

2472: ,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
2473: ,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
2474: ,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
2475: FROM
2476: pon_auc_payments_shipments pay,
2477: pa_projects_all proj,
2478: pa_tasks task,
2479: gms_awards_all awrd,
2480: hr_locations_all hrl,

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

2759: fnd_document_categories categories,
2760: fnd_document_categories_tl categories_tl
2761: where d.document_id = ad.document_id
2762: and
2763: ad.entity_name IN ('PON_AUC_PAYMENTS_SHIPMENTS')
2764: and ad.pk1_value = to_char(p_auction_header_id)
2765: and (l_is_buyer_negpdf = 'Y' or categories.name = 'Vendor')
2766: and categories.category_id = d.category_id
2767: and categories.category_id = categories_tl.category_id