DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PON_BID_PAYMENTS_SHIPMENTS

Line 2486: pon_bid_payments_shipments pbp,

2482: fnd_user fuser,
2483: po_lookup_codes lkp1,
2484: fnd_territories_tl terr,
2485: mtl_units_of_measure_tl uom_tl,
2486: pon_bid_payments_shipments pbp,
2487: pon_bid_item_prices pbip
2488: WHERE
2489: pbp.bid_number = pbhs.bid_number
2490: AND pbp.auction_header_id = pay.auction_header_id(+)

Line 2736: ad.entity_name IN ('PON_BID_PAYMENTS_SHIPMENTS')

2732: fnd_document_categories categories,
2733: fnd_document_categories_tl categories_tl
2734: where d.document_id = ad.document_id
2735: and
2736: ad.entity_name IN ('PON_BID_PAYMENTS_SHIPMENTS')
2737: and ad.pk1_value = to_char(pbhs.bid_number)
2738: and categories.name = pon_auction_pkg.g_supplier_attachment
2739: and categories.category_id = d.category_id
2740: and categories.category_id = categories_tl.category_id

Line 2754: (select to_char(bid_payment_id) from PON_BID_PAYMENTS_SHIPMENTS pby where bid_number = p_bid_number and pby.auction_payment_id = to_number(ad.pk3_value)),

2750: ad.pk1_value,
2751: ad.pk2_value,
2752: --for bid pdf, it should be bid_payment_id instead of auction_payment_id,
2753: decode(l_is_bidpdf, 'Y',
2754: (select to_char(bid_payment_id) from PON_BID_PAYMENTS_SHIPMENTS pby where bid_number = p_bid_number and pby.auction_payment_id = to_number(ad.pk3_value)),
2755: ad.pk3_value) pk3_value,
2756: categories_tl.user_name category_name
2757: from fnd_documents_vl d,
2758: fnd_attached_documents ad,