APPS.PON_PRINTING_PKG dependencies on FND_DOCUMENT_CATEGORIES

Line 4231: fnd_document_categories categories,

4227: categories_tl.user_name category_name
4228: from pon_auction_headers_all pah,
4229: fnd_documents_vl d,
4230: fnd_attached_documents ad,
4231: fnd_document_categories categories,
4232: fnd_document_categories_tl categories_tl,
4233: pon_auction_item_prices_all paip,
4234: financials_system_params_all fsp
4235: where d.document_id = ad.document_id

Line 4232: fnd_document_categories_tl categories_tl,

4228: from pon_auction_headers_all pah,
4229: fnd_documents_vl d,
4230: fnd_attached_documents ad,
4231: fnd_document_categories categories,
4232: fnd_document_categories_tl categories_tl,
4233: pon_auction_item_prices_all paip,
4234: financials_system_params_all fsp
4235: where d.document_id = ad.document_id
4236: and

Line 4261: fnd_document_categories categories,

4257: ad.pk3_value,
4258: categories_tl.user_name category_name
4259: from fnd_documents_vl d,
4260: fnd_attached_documents ad,
4261: fnd_document_categories categories,
4262: fnd_document_categories_tl categories_tl
4263: where d.document_id = ad.document_id
4264: and
4265: ad.entity_name IN ('PON_AUCTION_ITEM_PRICES_ALL',

Line 4262: fnd_document_categories_tl categories_tl

4258: categories_tl.user_name category_name
4259: from fnd_documents_vl d,
4260: fnd_attached_documents ad,
4261: fnd_document_categories categories,
4262: fnd_document_categories_tl categories_tl
4263: where d.document_id = ad.document_id
4264: and
4265: ad.entity_name IN ('PON_AUCTION_ITEM_PRICES_ALL',
4266: 'PON_AUCTION_HEADERS_ALL')

Line 4288: fnd_document_categories categories,

4284: categories_tl.user_name category_name
4285: from pon_bid_headers pbhs,
4286: fnd_documents_vl d,
4287: fnd_attached_documents ad,
4288: fnd_document_categories categories,
4289: fnd_document_categories_tl categories_tl
4290: where d.document_id = ad.document_id
4291: AND
4292: pbhs.auction_header_id (+) = p_auction_header_id

Line 4289: fnd_document_categories_tl categories_tl

4285: from pon_bid_headers pbhs,
4286: fnd_documents_vl d,
4287: fnd_attached_documents ad,
4288: fnd_document_categories categories,
4289: fnd_document_categories_tl categories_tl
4290: where d.document_id = ad.document_id
4291: AND
4292: pbhs.auction_header_id (+) = p_auction_header_id
4293: and pbhs.bid_number (+) = p_bid_number

Line 4321: fnd_document_categories categories,

4317: categories_tl.user_name category_name
4318: from pon_bid_headers pbhs,
4319: fnd_documents_vl d,
4320: fnd_attached_documents ad,
4321: fnd_document_categories categories,
4322: fnd_document_categories_tl categories_tl
4323: where d.document_id = ad.document_id
4324: and pbhs.auction_header_id (+) = p_auction_header_id
4325: and pbhs.bid_number (+) = p_bid_number

Line 4322: fnd_document_categories_tl categories_tl

4318: from pon_bid_headers pbhs,
4319: fnd_documents_vl d,
4320: fnd_attached_documents ad,
4321: fnd_document_categories categories,
4322: fnd_document_categories_tl categories_tl
4323: where d.document_id = ad.document_id
4324: and pbhs.auction_header_id (+) = p_auction_header_id
4325: and pbhs.bid_number (+) = p_bid_number
4326: and

Line 4350: fnd_document_categories categories,

4346: ad.pk3_value) pk3_value,
4347: categories_tl.user_name category_name
4348: from fnd_documents_vl d,
4349: fnd_attached_documents ad,
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')

Line 4351: fnd_document_categories_tl categories_tl

4347: categories_tl.user_name category_name
4348: from fnd_documents_vl d,
4349: fnd_attached_documents ad,
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)