APPS.PON_PRINTING_PKG dependencies on FND_DOCUMENT_CATEGORIES

Line 2647: fnd_document_categories categories,

2643: ad.pk3_value,
2644: categories_tl.user_name category_name
2645: from fnd_documents_vl d,
2646: fnd_attached_documents ad,
2647: fnd_document_categories categories,
2648: fnd_document_categories_tl categories_tl,
2649: pon_auction_item_prices_all paip,
2650: financials_system_params_all fsp
2651: where d.document_id = ad.document_id

Line 2648: fnd_document_categories_tl categories_tl,

2644: categories_tl.user_name category_name
2645: from fnd_documents_vl d,
2646: fnd_attached_documents ad,
2647: fnd_document_categories categories,
2648: fnd_document_categories_tl categories_tl,
2649: pon_auction_item_prices_all paip,
2650: financials_system_params_all fsp
2651: where d.document_id = ad.document_id
2652: and

Line 2676: fnd_document_categories categories,

2672: ad.pk3_value,
2673: categories_tl.user_name category_name
2674: from fnd_documents_vl d,
2675: fnd_attached_documents ad,
2676: fnd_document_categories categories,
2677: fnd_document_categories_tl categories_tl
2678: where d.document_id = ad.document_id
2679: and
2680: ad.entity_name IN ('PON_AUCTION_ITEM_PRICES_ALL',

Line 2677: fnd_document_categories_tl categories_tl

2673: categories_tl.user_name category_name
2674: from fnd_documents_vl d,
2675: fnd_attached_documents ad,
2676: fnd_document_categories categories,
2677: fnd_document_categories_tl categories_tl
2678: where d.document_id = ad.document_id
2679: and
2680: ad.entity_name IN ('PON_AUCTION_ITEM_PRICES_ALL',
2681: 'PON_AUCTION_HEADERS_ALL')

Line 2702: fnd_document_categories categories,

2698: ad.pk3_value,
2699: categories_tl.user_name category_name
2700: from fnd_documents_vl d,
2701: fnd_attached_documents ad,
2702: fnd_document_categories categories,
2703: fnd_document_categories_tl categories_tl
2704: where d.document_id = ad.document_id
2705: and
2706: ad.entity_name IN ('PON_BID_HEADERS',

Line 2703: fnd_document_categories_tl categories_tl

2699: categories_tl.user_name category_name
2700: from fnd_documents_vl d,
2701: fnd_attached_documents ad,
2702: fnd_document_categories categories,
2703: fnd_document_categories_tl categories_tl
2704: where d.document_id = ad.document_id
2705: and
2706: ad.entity_name IN ('PON_BID_HEADERS',
2707: 'PON_BID_ITEM_PRICES')

Line 2732: fnd_document_categories categories,

2728: ad.pk3_value,
2729: categories_tl.user_name category_name
2730: from fnd_documents_vl d,
2731: fnd_attached_documents ad,
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')

Line 2733: fnd_document_categories_tl categories_tl

2729: categories_tl.user_name category_name
2730: from fnd_documents_vl d,
2731: fnd_attached_documents ad,
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)

Line 2759: fnd_document_categories categories,

2755: ad.pk3_value) pk3_value,
2756: categories_tl.user_name category_name
2757: from fnd_documents_vl d,
2758: fnd_attached_documents ad,
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')

Line 2760: fnd_document_categories_tl categories_tl

2756: categories_tl.user_name category_name
2757: from fnd_documents_vl d,
2758: fnd_attached_documents ad,
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)