APPS.IBE_BI_STR_MIG_PVT dependencies on HZ_PARTIES

Line 456: hz_parties hp

452: qhdr.currency_code,
453: RANK() OVER (PARTITION BY qhdr.quote_header_id ORDER BY qlin.quote_line_id ASC NULLS LAST) RANK
454: FROM aso_quote_headers_all QHDR,
455: aso_quote_lines_all QLIN,
456: hz_parties hp
457: WHERE qhdr.quote_header_id = qlin.quote_header_id(+)
458: AND (qhdr.quote_source_code like 'IStore%' or qhdr.publish_flag = 'Y')
459: AND qhdr.party_id = hp.party_id) a
460: where a.rank <= 1;

Line 524: hz_parties hp

520: qhdr.currency_code,
521: RANK() OVER (PARTITION BY qhdr.quote_header_id ORDER BY qlin.quote_line_id ASC NULLS LAST) RANK
522: FROM aso_quote_headers_all QHDR,
523: aso_quote_lines_all QLIN,
524: hz_parties hp
525: WHERE qhdr.quote_header_id = qlin.quote_header_id(+)
526: AND (qhdr.quote_source_code like 'IStore%' or qhdr.publish_flag = 'Y')
527: AND qhdr.party_id = hp.party_id) a
528: where a.rank <= 1

Line 584: hz_parties hp

580: fnd_global.prog_appl_id,
581: fnd_global.conc_program_id ,
582: SYSDATE
583: from aso_quote_headers_all qhdr,
584: hz_parties hp
585: where (qhdr.quote_source_code like 'IStore%' OR qhdr.publish_flag = 'Y')
586: AND qhdr.party_id = hp.party_id ;
587: ELSE
588:

Line 635: hz_parties hp

631: fnd_global.prog_appl_id,
632: fnd_global.conc_program_id ,
633: SYSDATE
634: from aso_quote_headers_all qhdr,
635: hz_parties hp
636: where (qhdr.quote_source_code like 'IStore%' OR qhdr.publish_flag = 'Y')
637: AND qhdr.party_id = hp.party_id
638: AND qhdr.minisite_id IS NULL;
639: END IF;