DBA Data[Home] [Help]

APPS.PON_ATTR_MAPPING dependencies on PON_AUCTION_ATTR_MAPPING_B

Line 296: FROM PON_AUCTION_ATTR_MAPPING_B

292: SELECT DISTINCT
293: ATTR_GROUP_ID
294: , DATA_LEVEL_ID
295: , LINE_NUMBER
296: FROM PON_AUCTION_ATTR_MAPPING_B
297: WHERE AUCTION_HEADER_ID = p_header_id
298: AND MAPPING_TYPE IN ('DOC_HEADER','DOC_REQ', 'CAT_LINE', 'DOC_SEC_SCORE'); --Bug13471195 Header Mapping Issue
299:
300: CURSOR supp_mapping_setup_cursor(p_header_id IN NUMBER

Line 310: FROM PON_AUCTION_ATTR_MAPPING_B

306: , SEQUENCE_NUMBER
307: , MAPPING_TYPE
308: , RESPONSE
309: , ATTR_INT_NAME
310: FROM PON_AUCTION_ATTR_MAPPING_B
311: WHERE AUCTION_HEADER_ID = p_header_id
312: AND ATTR_GROUP_ID = p_attr_group_id
313: AND DATA_LEVEL_ID = p_data_level_id
314: AND ( ( LINE_NUMBER = p_line_number AND mapping_type IN ('DOC_REQ', 'CAT_LINE', 'DOC_SEC_SCORE') )

Line 323: FROM PON_AUCTION_ATTR_MAPPING_B

319: SELECT DISTINCT
320: ATTR_GROUP_ID
321: , DATA_LEVEL_ID
322: , LINE_NUMBER
323: FROM PON_AUCTION_ATTR_MAPPING_B
324: WHERE AUCTION_HEADER_ID = p_header_id
325: AND MAPPING_TYPE IN ('ITEM_LINE','ITEM_HEADER'); ----Bug13471195 Header Mapping Issue
326:
327: CURSOR item_mapping_setup_cursor(p_header_id IN NUMBER

Line 336: FROM PON_AUCTION_ATTR_MAPPING_B

332: SELECT SEQUENCE_NUMBER
333: , MAPPING_TYPE
334: , RESPONSE
335: , ATTR_INT_NAME
336: FROM PON_AUCTION_ATTR_MAPPING_B
337: WHERE AUCTION_HEADER_ID = p_header_id
338: AND ATTR_GROUP_ID = p_attr_group_id
339: AND DATA_LEVEL_ID = p_data_level_id
340: AND ( ( LINE_NUMBER = p_line_number AND mapping_type = 'ITEM_LINE' )