DBA Data[Home] [Help]

APPS.PON_SGD_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 10: FROM EGO_FND_DSC_FLX_CTX_EXT AG, pon_auction_headers_all H,

6: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
7: ATTR_GROUP_ID,
8: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW
9: MULTI_ROW
10: FROM EGO_FND_DSC_FLX_CTX_EXT AG, pon_auction_headers_all H,
11: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
12: WHERE H.auction_header_id = p_auction_header_id
13: AND H.UDA_TEMPLATE_ID = POT.TEMPLATE_ID
14: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID

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