429: a.msite2,
430: a.qtype,
431: a.currency_code,
432: decode(p_override_minisite_flag, 'Y', 'Yes', 'No'),
433: fnd_global.user_id,
434: SYSDATE,
435: fnd_global.user_id ,
436: SYSDATE,
437: fnd_global.Conc_Login_id,
431: a.currency_code,
432: decode(p_override_minisite_flag, 'Y', 'Yes', 'No'),
433: fnd_global.user_id,
434: SYSDATE,
435: fnd_global.user_id ,
436: SYSDATE,
437: fnd_global.Conc_Login_id,
438: fnd_global.conc_request_id ,
439: fnd_global.prog_appl_id,
433: fnd_global.user_id,
434: SYSDATE,
435: fnd_global.user_id ,
436: SYSDATE,
437: fnd_global.Conc_Login_id,
438: fnd_global.conc_request_id ,
439: fnd_global.prog_appl_id,
440: fnd_global.conc_program_id ,
441: SYSDATE
434: SYSDATE,
435: fnd_global.user_id ,
436: SYSDATE,
437: fnd_global.Conc_Login_id,
438: fnd_global.conc_request_id ,
439: fnd_global.prog_appl_id,
440: fnd_global.conc_program_id ,
441: SYSDATE
442: FROM
435: fnd_global.user_id ,
436: SYSDATE,
437: fnd_global.Conc_Login_id,
438: fnd_global.conc_request_id ,
439: fnd_global.prog_appl_id,
440: fnd_global.conc_program_id ,
441: SYSDATE
442: FROM
443: (SELECT qhdr.quote_header_id,
436: SYSDATE,
437: fnd_global.Conc_Login_id,
438: fnd_global.conc_request_id ,
439: fnd_global.prog_appl_id,
440: fnd_global.conc_program_id ,
441: SYSDATE
442: FROM
443: (SELECT qhdr.quote_header_id,
444: qhdr.org_id,
497: a.msite2,
498: a.qtype,
499: a.currency_code,
500: decode(p_override_minisite_flag, 'Y', 'Yes', 'No'),
501: fnd_global.user_id,
502: SYSDATE,
503: fnd_global.user_id ,
504: SYSDATE,
505: fnd_global.Conc_Login_id,
499: a.currency_code,
500: decode(p_override_minisite_flag, 'Y', 'Yes', 'No'),
501: fnd_global.user_id,
502: SYSDATE,
503: fnd_global.user_id ,
504: SYSDATE,
505: fnd_global.Conc_Login_id,
506: fnd_global.conc_request_id ,
507: fnd_global.prog_appl_id,
501: fnd_global.user_id,
502: SYSDATE,
503: fnd_global.user_id ,
504: SYSDATE,
505: fnd_global.Conc_Login_id,
506: fnd_global.conc_request_id ,
507: fnd_global.prog_appl_id,
508: fnd_global.conc_program_id ,
509: SYSDATE
502: SYSDATE,
503: fnd_global.user_id ,
504: SYSDATE,
505: fnd_global.Conc_Login_id,
506: fnd_global.conc_request_id ,
507: fnd_global.prog_appl_id,
508: fnd_global.conc_program_id ,
509: SYSDATE
510: FROM
503: fnd_global.user_id ,
504: SYSDATE,
505: fnd_global.Conc_Login_id,
506: fnd_global.conc_request_id ,
507: fnd_global.prog_appl_id,
508: fnd_global.conc_program_id ,
509: SYSDATE
510: FROM
511: (SELECT qhdr.quote_header_id,
504: SYSDATE,
505: fnd_global.Conc_Login_id,
506: fnd_global.conc_request_id ,
507: fnd_global.prog_appl_id,
508: fnd_global.conc_program_id ,
509: SYSDATE
510: FROM
511: (SELECT qhdr.quote_header_id,
512: qhdr.org_id,
570: null,
571: null,
572: qhdr.currency_code,
573: decode(p_override_minisite_flag, 'Y', 'Yes', 'No'),
574: fnd_global.user_id,
575: SYSDATE,
576: fnd_global.user_id ,
577: SYSDATE,
578: fnd_global.Conc_Login_id,
572: qhdr.currency_code,
573: decode(p_override_minisite_flag, 'Y', 'Yes', 'No'),
574: fnd_global.user_id,
575: SYSDATE,
576: fnd_global.user_id ,
577: SYSDATE,
578: fnd_global.Conc_Login_id,
579: fnd_global.conc_request_id ,
580: fnd_global.prog_appl_id,
574: fnd_global.user_id,
575: SYSDATE,
576: fnd_global.user_id ,
577: SYSDATE,
578: fnd_global.Conc_Login_id,
579: fnd_global.conc_request_id ,
580: fnd_global.prog_appl_id,
581: fnd_global.conc_program_id ,
582: SYSDATE
575: SYSDATE,
576: fnd_global.user_id ,
577: SYSDATE,
578: fnd_global.Conc_Login_id,
579: fnd_global.conc_request_id ,
580: fnd_global.prog_appl_id,
581: fnd_global.conc_program_id ,
582: SYSDATE
583: from aso_quote_headers_all qhdr,
576: fnd_global.user_id ,
577: SYSDATE,
578: fnd_global.Conc_Login_id,
579: fnd_global.conc_request_id ,
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
577: SYSDATE,
578: fnd_global.Conc_Login_id,
579: fnd_global.conc_request_id ,
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')
621: null,
622: null,
623: qhdr.currency_code,
624: decode(p_override_minisite_flag, 'Y', 'Yes', 'No'),
625: fnd_global.user_id,
626: SYSDATE,
627: fnd_global.user_id ,
628: SYSDATE,
629: fnd_global.Conc_Login_id,
623: qhdr.currency_code,
624: decode(p_override_minisite_flag, 'Y', 'Yes', 'No'),
625: fnd_global.user_id,
626: SYSDATE,
627: fnd_global.user_id ,
628: SYSDATE,
629: fnd_global.Conc_Login_id,
630: fnd_global.conc_request_id ,
631: fnd_global.prog_appl_id,
625: fnd_global.user_id,
626: SYSDATE,
627: fnd_global.user_id ,
628: SYSDATE,
629: fnd_global.Conc_Login_id,
630: fnd_global.conc_request_id ,
631: fnd_global.prog_appl_id,
632: fnd_global.conc_program_id ,
633: SYSDATE
626: SYSDATE,
627: fnd_global.user_id ,
628: SYSDATE,
629: fnd_global.Conc_Login_id,
630: fnd_global.conc_request_id ,
631: fnd_global.prog_appl_id,
632: fnd_global.conc_program_id ,
633: SYSDATE
634: from aso_quote_headers_all qhdr,
627: fnd_global.user_id ,
628: SYSDATE,
629: fnd_global.Conc_Login_id,
630: fnd_global.conc_request_id ,
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
628: SYSDATE,
629: fnd_global.Conc_Login_id,
630: fnd_global.conc_request_id ,
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')
931: LAST_UPDATE_DATE,
932: STATUS)
933: VALUES('IBE_MINISITE_MIGRATION',
934: 0,
935: FND_GLOBAL.user_id,
936: g_start_dt,
937: FND_GLOBAL.user_id,
938: SYSDATE,
939: p_status);
933: VALUES('IBE_MINISITE_MIGRATION',
934: 0,
935: FND_GLOBAL.user_id,
936: g_start_dt,
937: FND_GLOBAL.user_id,
938: SYSDATE,
939: p_status);
940:
941: