APPS.PON_SGD_PKG dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 267: FROM EGO_FND_DSC_FLX_CTX_EXT AG, pon_auction_item_prices_all L,

263: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
264: ATTR_GROUP_ID,
265: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW
266: MULTI_ROW
267: FROM EGO_FND_DSC_FLX_CTX_EXT AG, pon_auction_item_prices_all L,
268: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
269: WHERE L.auction_header_id = p_auction_header_id
270: AND L.LINE_NUMBER = p_line_id
271: AND L.UDA_TEMPLATE_ID = POT.TEMPLATE_ID

Line 607: FROM pon_auction_item_prices_all

603: else fromline || '-' || toline end ) line_display
604: FROM (
605: SELECT min(line) fromline, max(line) toline, 'A' orderseq
606: FROM (SELECT line_num_display line, line_num_display -row_number() over(order by to_number(line_num_display)) rn, group_line_id
607: FROM pon_auction_item_prices_all
608: WHERE group_line_id is null
609: and auction_header_id = mod_pk1_value
610: and line_number IN (select mod_doc_pk2_val FROM po_entity_rollup_gt d
611: WHERE d.document_type = p_document_type

Line 626: FROM pon_auction_item_prices_all mod,

622: UNION ALL
623:
624: SELECT min(line) fromline, max(line) toline, null orderseq
625: FROM (SELECT mod.line_num_display line, mod.group_line_id, base.rank - row_number() over(partition by mod.group_line_id order by mod.line_num_display) rn
626: FROM pon_auction_item_prices_all mod,
627: (SELECT paip.line_num_display, rank() over(partition by paip.group_line_id order by paip.line_num_display) rank, paip.line_number
628: FROM pon_auction_item_prices_all paip, pon_auction_headers_all pah
629: WHERE paip.group_line_id is not null and pah.auction_header_id = mod_pk1_value
630: and paip.auction_header_id = pah.auction_header_id_prev_amend

Line 628: FROM pon_auction_item_prices_all paip, pon_auction_headers_all pah

624: SELECT min(line) fromline, max(line) toline, null orderseq
625: FROM (SELECT mod.line_num_display line, mod.group_line_id, base.rank - row_number() over(partition by mod.group_line_id order by mod.line_num_display) rn
626: FROM pon_auction_item_prices_all mod,
627: (SELECT paip.line_num_display, rank() over(partition by paip.group_line_id order by paip.line_num_display) rank, paip.line_number
628: FROM pon_auction_item_prices_all paip, pon_auction_headers_all pah
629: WHERE paip.group_line_id is not null and pah.auction_header_id = mod_pk1_value
630: and paip.auction_header_id = pah.auction_header_id_prev_amend
631: ) base
632: WHERE mod.line_number = base.line_number