DBA Data[Home] [Help]

APPS.PON_SGD_PKG dependencies on PON_AUCTION_ITEM_PRICES_EXT_B

Line 275: and potu.attribute_group_id in (select distinct attr_group_id from PON_AUCTION_ITEM_PRICES_EXT_B

271: AND L.UDA_TEMPLATE_ID = POT.TEMPLATE_ID
272: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
273: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
274: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
275: and potu.attribute_group_id in (select distinct attr_group_id from PON_AUCTION_ITEM_PRICES_EXT_B
276: where AUCTION_HEADER_ID = L.auction_header_id and LINE_NUMBER=L.LINE_NUMBER and attr_group_id = potu.attribute_group_id)
277: ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;
278:
279: CURSOR C_ATTR_MD(P_ATTR_GROUP VARCHAR2, P_DESC_FLEXFLD_NAME VARCHAR2) IS

Line 312: p_object_name varchar2(200) := 'PON_AUCTION_ITEM_PRICES_EXT_B';

308: p_attr_internal_name varchar2(100);
309: p_attr_group_type varchar2(200) := 'PON_AUC_PRICES_EXT_ATTRS';
310: p_attr_group_int_name varchar2(200);
311:
312: p_object_name varchar2(200) := 'PON_AUCTION_ITEM_PRICES_EXT_B';
313:
314: p_pk1_column_name varchar2(200) := 'AUCTION_HEADER_ID';
315: p_pk1_value number := p_auction_header_id;
316: p_pk2_column_name varchar2(200) := 'LINE_NUMBER';