[Home] [Help]
1: PACKAGE BODY QP_BULK_LOADER_PUB AS
2: /* $Header: QPXVBLKB.pls 120.24.12010000.5 2008/11/05 12:04:38 kdurgasi ship $ */
3:
4: FUNCTION GET_NULL_DATE RETURN DATE IS
5: BEGIN
474: global_flag
475: ) = ( select
476: decode(qpih.creation_date, null, qplh.creation_date,
477: decode(qpih.creation_date,
478: QP_BULK_LOADER_PUB.G_NULL_DATE,
479: null,
480: qpih.creation_date
481: )
482: ),
481: )
482: ),
483: decode(qpih.created_by, null, qplh.created_by,
484: decode(qpih.created_by,
485: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
486: null,
487: qpih.created_by
488: )
489: ),
488: )
489: ),
490: decode(qpih.program_application_id, null, qplh.program_application_id,
491: decode(qpih.program_application_id,
492: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
493: null,
494: qpih.program_application_id
495: )
496: ),
495: )
496: ),
497: decode(qpih.program_id, null, qplh.program_id,
498: decode(qpih.program_id,
499: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
500: null,
501: qpih.program_id
502: )
503: ),
502: )
503: ),
504: decode(qpih.program_update_date, null, qplh.program_update_date,
505: decode(qpih.program_update_date,
506: QP_BULK_LOADER_PUB.G_NULL_DATE,
507: null,
508: qpih.program_update_date
509: )
510: ),
509: )
510: ),
511: decode(qpih.list_type_code, null, qplh.list_type_code,
512: decode(qpih.list_type_code,
513: QP_BULK_LOADER_PUB.G_NULL_CHAR,
514: null,
515: qpih.list_type_code
516: )
517: ),
517: ),
518: --Bug# 5228368 RAVI
519: decode(qpih.start_date_active, null, to_char(qplh.start_date_active,'YYYY/MM/DD'),
520: decode(qpih.start_date_active,
521: QP_BULK_LOADER_PUB.G_NULL_CHAR,
522: null,
523: qpih.start_date_active
524: )
525: ),
525: ),
526: --Bug# 5228368 RAVI
527: decode(qpih.end_date_active, null, to_char(qplh.end_date_active,'YYYY/MM/DD'),
528: decode(qpih.end_date_active,
529: QP_BULK_LOADER_PUB.G_NULL_CHAR,
530: null,
531: qpih.end_date_active
532: )
533: ),
532: )
533: ),
534: decode(qpih.source_lang, null, userenv('lang'),
535: decode(qpih.source_lang,
536: QP_BULK_LOADER_PUB.G_NULL_CHAR,
537: null,
538: qpih.source_lang
539: )
540: ),
539: )
540: ),
541: decode(qpih.automatic_flag, null, qplh.automatic_flag,
542: decode(qpih.automatic_flag,
543: QP_BULK_LOADER_PUB.G_NULL_CHAR,
544: null,
545: qpih.automatic_flag
546: )
547: ),
546: )
547: ),
548: decode(qpih.name, null, qplh.name,
549: decode(qpih.name,
550: QP_BULK_LOADER_PUB.G_NULL_CHAR,
551: null,
552: qpih.name
553: )
554: ),
553: )
554: ),
555: decode(qpih.description, null, qplh.description,
556: decode(qpih.description,
557: QP_BULK_LOADER_PUB.G_NULL_CHAR,
558: null,
559: qpih.description
560: )
561: ),
560: )
561: ),
562: decode(qpih.currency_code, null, qplh.currency_code,
563: decode(qpih.currency_code,
564: QP_BULK_LOADER_PUB.G_NULL_CHAR,
565: null,
566: qpih.currency_code
567: )
568: ),
567: )
568: ),
569: decode(qpih.version_no, null, qplh.version_no,
570: decode(qpih.version_no,
571: QP_BULK_LOADER_PUB.G_NULL_CHAR,
572: null,
573: qpih.version_no
574: )
575: ),
574: )
575: ),
576: decode(qpih.rounding_factor, null, qplh.rounding_factor,
577: decode(qpih.rounding_factor,
578: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
579: null,
580: qpih.rounding_factor
581: )
582: ),
594: decode(qpih.ship_method,
595: null,
596: decode(qpih.ship_method_code, null, qplh.ship_method_code,
597: decode(qpih.ship_method_code,
598: QP_BULK_LOADER_PUB.G_NULL_CHAR,
599: null,
600: qpih.ship_method_code
601: )
602: ),
600: qpih.ship_method_code
601: )
602: ),
603: decode(qpih.ship_method_code, null, null,
604: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
605: qpih.ship_method_code
606: )
607: ),
608: decode(qpih.freight_terms,
608: decode(qpih.freight_terms,
609: null,
610: decode(qpih.freight_terms_code, null, qplh.freight_terms_code,
611: decode(qpih.freight_terms_code,
612: QP_BULK_LOADER_PUB.G_NULL_CHAR,
613: null,
614: qpih.freight_terms_code
615: )
616: ),
614: qpih.freight_terms_code
615: )
616: ),
617: decode(qpih.freight_terms_code, null, null,
618: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
619: qpih.freight_terms_code
620: )
621: ),
622: decode(qpih.terms,
622: decode(qpih.terms,
623: null,
624: decode(qpih.terms_id, null, qplh.terms_id,
625: decode(qpih.terms_id,
626: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
627: null,
628: qpih.terms_id
629: )
630: ),
628: qpih.terms_id
629: )
630: ),
631: decode(qpih.terms_id, null, null,
632: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
633: qpih.terms_id
634: )
635: ),
636: --Bug# 5412029 RAVI END
635: ),
636: --Bug# 5412029 RAVI END
637: decode(qpih.comments, null, qplh.comments,
638: decode(qpih.comments,
639: QP_BULK_LOADER_PUB.G_NULL_CHAR,
640: null,
641: qpih.comments
642: )
643: ),
642: )
643: ),
644: decode(qpih.discount_lines_flag, null, qplh.discount_lines_flag,
645: decode(qpih.discount_lines_flag,
646: QP_BULK_LOADER_PUB.G_NULL_CHAR,
647: null,
648: qpih.discount_lines_flag
649: )
650: ),
649: )
650: ),
651: decode(qpih.gsa_indicator, null, qplh.gsa_indicator,
652: decode(qpih.gsa_indicator,
653: QP_BULK_LOADER_PUB.G_NULL_CHAR,
654: null,
655: qpih.gsa_indicator
656: )
657: ),
656: )
657: ),
658: decode(qpih.prorate_flag, null, qplh.prorate_flag,
659: decode(qpih.prorate_flag,
660: QP_BULK_LOADER_PUB.G_NULL_CHAR,
661: null,
662: qpih.prorate_flag
663: )
664: ),
663: )
664: ),
665: decode(qpih.source_system_code, null, qplh.source_system_code,
666: decode(qpih.source_system_code,
667: QP_BULK_LOADER_PUB.G_NULL_CHAR,
668: null,
669: qpih.source_system_code
670: )
671: ),
670: )
671: ),
672: decode(qpih.ask_for_flag, null, qplh.ask_for_flag,
673: decode(qpih.ask_for_flag,
674: QP_BULK_LOADER_PUB.G_NULL_CHAR,
675: null,
676: qpih.ask_for_flag
677: )
678: ),
677: )
678: ),
679: decode(qpih.active_flag, null, qplh.active_flag,
680: decode(qpih.active_flag,
681: QP_BULK_LOADER_PUB.G_NULL_CHAR,
682: null,
683: qpih.active_flag
684: )
685: ),
684: )
685: ),
686: decode(qpih.parent_list_header_id, null, qplh.parent_list_header_id,
687: decode(qpih.parent_list_header_id,
688: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
689: null,
690: qpih.parent_list_header_id
691: )
692: ),
691: )
692: ),
693: decode(qpih.active_date_first_type, null, qplh.active_date_first_type,
694: decode(qpih.active_date_first_type,
695: QP_BULK_LOADER_PUB.G_NULL_CHAR,
696: null,
697: qpih.active_date_first_type
698: )
699: ),
698: )
699: ),
700: decode(qpih.start_date_active_first, null, qplh.start_date_active_first,
701: decode(qpih.start_date_active_first,
702: QP_BULK_LOADER_PUB.G_NULL_DATE,
703: null,
704: qpih.start_date_active_first
705: )
706: ),
705: )
706: ),
707: decode(qpih.end_date_active_first, null, qplh.end_date_active_first,
708: decode(qpih.end_date_active_first,
709: QP_BULK_LOADER_PUB.G_NULL_DATE,
710: null,
711: qpih.end_date_active_first
712: )
713: ),
712: )
713: ),
714: decode(qpih.active_date_second_type, null, qplh.active_date_second_type,
715: decode(qpih.active_date_second_type,
716: QP_BULK_LOADER_PUB.G_NULL_CHAR,
717: null,
718: qpih.active_date_second_type
719: )
720: ),
719: )
720: ),
721: decode(qpih.start_date_active_second, null, qplh.start_date_active_second,
722: decode(qpih.start_date_active_second,
723: QP_BULK_LOADER_PUB.G_NULL_DATE,
724: null,
725: qpih.start_date_active_second
726: )
727: ),
726: )
727: ),
728: decode(qpih.end_date_active_second, null, qplh.end_date_active_second,
729: decode(qpih.end_date_active_second,
730: QP_BULK_LOADER_PUB.G_NULL_DATE,
731: null,
732: qpih.end_date_active_second
733: )
734: ),
733: )
734: ),
735: decode(qpih.context, null, qplh.context,
736: decode(qpih.context,
737: QP_BULK_LOADER_PUB.G_NULL_CHAR,
738: null,
739: qpih.context
740: )
741: ),
740: )
741: ),
742: decode(qpih.attribute1, null, qplh.attribute1,
743: decode(qpih.attribute1,
744: QP_BULK_LOADER_PUB.G_NULL_CHAR,
745: null,
746: qpih.attribute1
747: )
748: ),
747: )
748: ),
749: decode(qpih.attribute2, null, qplh.attribute2,
750: decode(qpih.attribute2,
751: QP_BULK_LOADER_PUB.G_NULL_CHAR,
752: null,
753: qpih.attribute2
754: )
755: ),
754: )
755: ),
756: decode(qpih.attribute3, null, qplh.attribute3,
757: decode(qpih.attribute3,
758: QP_BULK_LOADER_PUB.G_NULL_CHAR,
759: null,
760: qpih.attribute3
761: )
762: ),
761: )
762: ),
763: decode(qpih.attribute4, null, qplh.attribute4,
764: decode(qpih.attribute4,
765: QP_BULK_LOADER_PUB.G_NULL_CHAR,
766: null,
767: qpih.attribute4
768: )
769: ),
768: )
769: ),
770: decode(qpih.attribute5, null, qplh.attribute5,
771: decode(qpih.attribute5,
772: QP_BULK_LOADER_PUB.G_NULL_CHAR,
773: null,
774: qpih.attribute5
775: )
776: ),
775: )
776: ),
777: decode(qpih.attribute6, null, qplh.attribute6,
778: decode(qpih.attribute6,
779: QP_BULK_LOADER_PUB.G_NULL_CHAR,
780: null,
781: qpih.attribute6
782: )
783: ),
782: )
783: ),
784: decode(qpih.attribute7, null, qplh.attribute7,
785: decode(qpih.attribute7,
786: QP_BULK_LOADER_PUB.G_NULL_CHAR,
787: null,
788: qpih.attribute7
789: )
790: ),
789: )
790: ),
791: decode(qpih.attribute8, null, qplh.attribute8,
792: decode(qpih.attribute8,
793: QP_BULK_LOADER_PUB.G_NULL_CHAR,
794: null,
795: qpih.attribute8
796: )
797: ),
796: )
797: ),
798: decode(qpih.attribute9, null, qplh.attribute9,
799: decode(qpih.attribute9,
800: QP_BULK_LOADER_PUB.G_NULL_CHAR,
801: null,
802: qpih.attribute9
803: )
804: ),
803: )
804: ),
805: decode(qpih.attribute10, null, qplh.attribute10,
806: decode(qpih.attribute10,
807: QP_BULK_LOADER_PUB.G_NULL_CHAR,
808: null,
809: qpih.attribute10
810: )
811: ),
810: )
811: ),
812: decode(qpih.attribute11, null, qplh.attribute11,
813: decode(qpih.attribute11,
814: QP_BULK_LOADER_PUB.G_NULL_CHAR,
815: null,
816: qpih.attribute11
817: )
818: ),
817: )
818: ),
819: decode(qpih.attribute12, null, qplh.attribute12,
820: decode(qpih.attribute12,
821: QP_BULK_LOADER_PUB.G_NULL_CHAR,
822: null,
823: qpih.attribute12
824: )
825: ),
824: )
825: ),
826: decode(qpih.attribute13, null, qplh.attribute13,
827: decode(qpih.attribute13,
828: QP_BULK_LOADER_PUB.G_NULL_CHAR,
829: null,
830: qpih.attribute13
831: )
832: ),
831: )
832: ),
833: decode(qpih.attribute14, null, qplh.attribute14,
834: decode(qpih.attribute14,
835: QP_BULK_LOADER_PUB.G_NULL_CHAR,
836: null,
837: qpih.attribute14
838: )
839: ),
838: )
839: ),
840: decode(qpih.attribute15, null, qplh.attribute15,
841: decode(qpih.attribute15,
842: QP_BULK_LOADER_PUB.G_NULL_CHAR,
843: null,
844: qpih.attribute15
845: )
846: ),
845: )
846: ),
847: decode(qpih.language, null, userenv('lang'),
848: decode(qpih.language,
849: QP_BULK_LOADER_PUB.G_NULL_CHAR,
850: null,
851: qpih.language
852: )
853: ),
852: )
853: ),
854: decode(qpih.mobile_download, null, qplh.mobile_download,
855: decode(qpih.mobile_download,
856: QP_BULK_LOADER_PUB.G_NULL_CHAR,
857: null,
858: qpih.mobile_download
859: )
860: ),
872: decode(qpih.currency_header,
873: null,
874: decode(qpih.currency_header_id, null, qplh.currency_header_id,
875: decode(qpih.currency_header_id,
876: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
877: null,
878: qpih.currency_header_id
879: )
880: ),
878: qpih.currency_header_id
879: )
880: ),
881: decode(qpih.currency_header_id, null, null,
882: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
883: qpih.currency_header_id
884: )
885: ),
886: --Bug# 5412029 RAVI END
885: ),
886: --Bug# 5412029 RAVI END
887: decode(qpih.orig_sys_header_ref, null, qplh.orig_system_header_ref,
888: decode(qpih.orig_sys_header_ref,
889: QP_BULK_LOADER_PUB.G_NULL_CHAR,
890: null,
891: qpih.orig_sys_header_ref
892: )
893: ),
892: )
893: ),
894: decode(qpih.orig_org_id, null, qplh.orig_org_id,
895: decode(qpih.orig_org_id,
896: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
897: null,
898: qpih.orig_org_id
899: )
900: ),
899: )
900: ),
901: decode(qpih.global_flag, null, qplh.global_flag,
902: decode(qpih.global_flag,
903: QP_BULK_LOADER_PUB.G_NULL_CHAR,
904: null,
905: qpih.global_flag
906: )
907: )
1091: global_flag
1092: ) = ( select
1093: decode(qpih.creation_date, null, qplh.creation_date,
1094: decode(qpih.creation_date,
1095: QP_BULK_LOADER_PUB.G_NULL_DATE,
1096: null,
1097: qpih.creation_date
1098: )
1099: ),
1098: )
1099: ),
1100: decode(qpih.created_by, null, qplh.created_by,
1101: decode(qpih.created_by,
1102: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1103: null,
1104: qpih.created_by
1105: )
1106: ),
1105: )
1106: ),
1107: decode(qpih.program_application_id, null, qplh.program_application_id,
1108: decode(qpih.program_application_id,
1109: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1110: null,
1111: qpih.program_application_id
1112: )
1113: ),
1112: )
1113: ),
1114: decode(qpih.program_id, null, qplh.program_id,
1115: decode(qpih.program_id,
1116: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1117: null,
1118: qpih.program_id
1119: )
1120: ),
1119: )
1120: ),
1121: decode(qpih.program_update_date, null, qplh.program_update_date,
1122: decode(qpih.program_update_date,
1123: QP_BULK_LOADER_PUB.G_NULL_DATE,
1124: null,
1125: qpih.program_update_date
1126: )
1127: ),
1126: )
1127: ),
1128: decode(qpih.list_type_code, null, qplh.list_type_code,
1129: decode(qpih.list_type_code,
1130: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1131: null,
1132: qpih.list_type_code
1133: )
1134: ),
1134: ),
1135: --Bug# 5228368 RAVI
1136: decode(qpih.start_date_active, null, to_char(qplh.start_date_active,'YYYY/MM/DD'),
1137: decode(qpih.start_date_active,
1138: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1139: null,
1140: qpih.start_date_active
1141: )
1142: ),
1142: ),
1143: --Bug# 5228368 RAVI
1144: decode(qpih.end_date_active, null, to_char(qplh.end_date_active,'YYYY/MM/DD'),
1145: decode(qpih.end_date_active,
1146: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1147: null,
1148: qpih.end_date_active
1149: )
1150: ),
1149: )
1150: ),
1151: decode(qpih.source_lang, null, userenv('lang'),
1152: decode(qpih.source_lang,
1153: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1154: null,
1155: qpih.source_lang
1156: )
1157: ),
1156: )
1157: ),
1158: decode(qpih.automatic_flag, null, qplh.automatic_flag,
1159: decode(qpih.automatic_flag,
1160: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1161: null,
1162: qpih.automatic_flag
1163: )
1164: ),
1163: )
1164: ),
1165: decode(qpih.name, null, qplh.name,
1166: decode(qpih.name,
1167: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1168: null,
1169: qpih.name
1170: )
1171: ),
1170: )
1171: ),
1172: decode(qpih.description, null, qplh.description,
1173: decode(qpih.description,
1174: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1175: null,
1176: qpih.description
1177: )
1178: ),
1177: )
1178: ),
1179: decode(qpih.currency_code, null, qplh.currency_code,
1180: decode(qpih.currency_code,
1181: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1182: null,
1183: qpih.currency_code
1184: )
1185: ),
1184: )
1185: ),
1186: decode(qpih.version_no, null, qplh.version_no,
1187: decode(qpih.version_no,
1188: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1189: null,
1190: qpih.version_no
1191: )
1192: ),
1191: )
1192: ),
1193: decode(qpih.rounding_factor, null, qplh.rounding_factor,
1194: decode(qpih.rounding_factor,
1195: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1196: null,
1197: qpih.rounding_factor
1198: )
1199: ),
1211: decode(qpih.ship_method,
1212: null,
1213: decode(qpih.ship_method_code, null, qplh.ship_method_code,
1214: decode(qpih.ship_method_code,
1215: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1216: null,
1217: qpih.ship_method_code
1218: )
1219: ),
1217: qpih.ship_method_code
1218: )
1219: ),
1220: decode(qpih.ship_method_code, null, null,
1221: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
1222: qpih.ship_method_code
1223: )
1224: ),
1225: decode(qpih.freight_terms,
1225: decode(qpih.freight_terms,
1226: null,
1227: decode(qpih.freight_terms_code, null, qplh.freight_terms_code,
1228: decode(qpih.freight_terms_code,
1229: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1230: null,
1231: qpih.freight_terms_code
1232: )
1233: ),
1231: qpih.freight_terms_code
1232: )
1233: ),
1234: decode(qpih.freight_terms_code, null, null,
1235: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
1236: qpih.freight_terms_code
1237: )
1238: ),
1239: decode(qpih.terms,
1239: decode(qpih.terms,
1240: null,
1241: decode(qpih.terms_id, null, qplh.terms_id,
1242: decode(qpih.terms_id,
1243: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1244: null,
1245: qpih.terms_id
1246: )
1247: ),
1245: qpih.terms_id
1246: )
1247: ),
1248: decode(qpih.terms_id, null, null,
1249: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
1250: qpih.terms_id
1251: )
1252: ),
1253: --Bug# 5412029 RAVI END
1252: ),
1253: --Bug# 5412029 RAVI END
1254: decode(qpih.comments, null, qplh.comments,
1255: decode(qpih.comments,
1256: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1257: null,
1258: qpih.comments
1259: )
1260: ),
1259: )
1260: ),
1261: decode(qpih.discount_lines_flag, null, qplh.discount_lines_flag,
1262: decode(qpih.discount_lines_flag,
1263: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1264: null,
1265: qpih.discount_lines_flag
1266: )
1267: ),
1266: )
1267: ),
1268: decode(qpih.gsa_indicator, null, qplh.gsa_indicator,
1269: decode(qpih.gsa_indicator,
1270: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1271: null,
1272: qpih.gsa_indicator
1273: )
1274: ),
1273: )
1274: ),
1275: decode(qpih.prorate_flag, null, qplh.prorate_flag,
1276: decode(qpih.prorate_flag,
1277: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1278: null,
1279: qpih.prorate_flag
1280: )
1281: ),
1280: )
1281: ),
1282: decode(qpih.source_system_code, null, qplh.source_system_code,
1283: decode(qpih.source_system_code,
1284: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1285: null,
1286: qpih.source_system_code
1287: )
1288: ),
1287: )
1288: ),
1289: decode(qpih.ask_for_flag, null, qplh.ask_for_flag,
1290: decode(qpih.ask_for_flag,
1291: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1292: null,
1293: qpih.ask_for_flag
1294: )
1295: ),
1294: )
1295: ),
1296: decode(qpih.active_flag, null, qplh.active_flag,
1297: decode(qpih.active_flag,
1298: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1299: null,
1300: qpih.active_flag
1301: )
1302: ),
1301: )
1302: ),
1303: decode(qpih.parent_list_header_id, null, qplh.parent_list_header_id,
1304: decode(qpih.parent_list_header_id,
1305: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1306: null,
1307: qpih.parent_list_header_id
1308: )
1309: ),
1308: )
1309: ),
1310: decode(qpih.active_date_first_type, null, qplh.active_date_first_type,
1311: decode(qpih.active_date_first_type,
1312: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1313: null,
1314: qpih.active_date_first_type
1315: )
1316: ),
1315: )
1316: ),
1317: decode(qpih.start_date_active_first, null, qplh.start_date_active_first,
1318: decode(qpih.start_date_active_first,
1319: QP_BULK_LOADER_PUB.G_NULL_DATE,
1320: null,
1321: qpih.start_date_active_first
1322: )
1323: ),
1322: )
1323: ),
1324: decode(qpih.end_date_active_first, null, qplh.end_date_active_first,
1325: decode(qpih.end_date_active_first,
1326: QP_BULK_LOADER_PUB.G_NULL_DATE,
1327: null,
1328: qpih.end_date_active_first
1329: )
1330: ),
1329: )
1330: ),
1331: decode(qpih.active_date_second_type, null, qplh.active_date_second_type,
1332: decode(qpih.active_date_second_type,
1333: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1334: null,
1335: qpih.active_date_second_type
1336: )
1337: ),
1336: )
1337: ),
1338: decode(qpih.start_date_active_second, null, qplh.start_date_active_second,
1339: decode(qpih.start_date_active_second,
1340: QP_BULK_LOADER_PUB.G_NULL_DATE,
1341: null,
1342: qpih.start_date_active_second
1343: )
1344: ),
1343: )
1344: ),
1345: decode(qpih.end_date_active_second, null, qplh.end_date_active_second,
1346: decode(qpih.end_date_active_second,
1347: QP_BULK_LOADER_PUB.G_NULL_DATE,
1348: null,
1349: qpih.end_date_active_second
1350: )
1351: ),
1350: )
1351: ),
1352: decode(qpih.context, null, qplh.context,
1353: decode(qpih.context,
1354: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1355: null,
1356: qpih.context
1357: )
1358: ),
1357: )
1358: ),
1359: decode(qpih.attribute1, null, qplh.attribute1,
1360: decode(qpih.attribute1,
1361: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1362: null,
1363: qpih.attribute1
1364: )
1365: ),
1364: )
1365: ),
1366: decode(qpih.attribute2, null, qplh.attribute2,
1367: decode(qpih.attribute2,
1368: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1369: null,
1370: qpih.attribute2
1371: )
1372: ),
1371: )
1372: ),
1373: decode(qpih.attribute3, null, qplh.attribute3,
1374: decode(qpih.attribute3,
1375: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1376: null,
1377: qpih.attribute3
1378: )
1379: ),
1378: )
1379: ),
1380: decode(qpih.attribute4, null, qplh.attribute4,
1381: decode(qpih.attribute4,
1382: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1383: null,
1384: qpih.attribute4
1385: )
1386: ),
1385: )
1386: ),
1387: decode(qpih.attribute5, null, qplh.attribute5,
1388: decode(qpih.attribute5,
1389: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1390: null,
1391: qpih.attribute5
1392: )
1393: ),
1392: )
1393: ),
1394: decode(qpih.attribute6, null, qplh.attribute6,
1395: decode(qpih.attribute6,
1396: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1397: null,
1398: qpih.attribute6
1399: )
1400: ),
1399: )
1400: ),
1401: decode(qpih.attribute7, null, qplh.attribute7,
1402: decode(qpih.attribute7,
1403: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1404: null,
1405: qpih.attribute7
1406: )
1407: ),
1406: )
1407: ),
1408: decode(qpih.attribute8, null, qplh.attribute8,
1409: decode(qpih.attribute8,
1410: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1411: null,
1412: qpih.attribute8
1413: )
1414: ),
1413: )
1414: ),
1415: decode(qpih.attribute9, null, qplh.attribute9,
1416: decode(qpih.attribute9,
1417: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1418: null,
1419: qpih.attribute9
1420: )
1421: ),
1420: )
1421: ),
1422: decode(qpih.attribute10, null, qplh.attribute10,
1423: decode(qpih.attribute10,
1424: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1425: null,
1426: qpih.attribute10
1427: )
1428: ),
1427: )
1428: ),
1429: decode(qpih.attribute11, null, qplh.attribute11,
1430: decode(qpih.attribute11,
1431: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1432: null,
1433: qpih.attribute11
1434: )
1435: ),
1434: )
1435: ),
1436: decode(qpih.attribute12, null, qplh.attribute12,
1437: decode(qpih.attribute12,
1438: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1439: null,
1440: qpih.attribute12
1441: )
1442: ),
1441: )
1442: ),
1443: decode(qpih.attribute13, null, qplh.attribute13,
1444: decode(qpih.attribute13,
1445: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1446: null,
1447: qpih.attribute13
1448: )
1449: ),
1448: )
1449: ),
1450: decode(qpih.attribute14, null, qplh.attribute14,
1451: decode(qpih.attribute14,
1452: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1453: null,
1454: qpih.attribute14
1455: )
1456: ),
1455: )
1456: ),
1457: decode(qpih.attribute15, null, qplh.attribute15,
1458: decode(qpih.attribute15,
1459: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1460: null,
1461: qpih.attribute15
1462: )
1463: ),
1462: )
1463: ),
1464: decode(qpih.language, null, userenv('lang'),
1465: decode(qpih.language,
1466: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1467: null,
1468: qpih.language
1469: )
1470: ),
1469: )
1470: ),
1471: decode(qpih.mobile_download, null, qplh.mobile_download,
1472: decode(qpih.mobile_download,
1473: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1474: null,
1475: qpih.mobile_download
1476: )
1477: ),
1489: decode(qpih.currency_header,
1490: null,
1491: decode(qpih.currency_header_id, null, qplh.currency_header_id,
1492: decode(qpih.currency_header_id,
1493: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1494: null,
1495: qpih.currency_header_id
1496: )
1497: ),
1495: qpih.currency_header_id
1496: )
1497: ),
1498: decode(qpih.currency_header_id, null, null,
1499: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
1500: qpih.currency_header_id
1501: )
1502: ),
1503: --Bug# 5412029 RAVI END
1502: ),
1503: --Bug# 5412029 RAVI END
1504: decode(qpih.orig_sys_header_ref, null, qplh.orig_system_header_ref,
1505: decode(qpih.orig_sys_header_ref,
1506: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1507: null,
1508: qpih.orig_sys_header_ref
1509: )
1510: ),
1509: )
1510: ),
1511: decode(qpih.orig_org_id, null, qplh.orig_org_id,
1512: decode(qpih.orig_org_id,
1513: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1514: null,
1515: qpih.orig_org_id
1516: )
1517: ),
1516: )
1517: ),
1518: decode(qpih.global_flag, null, qplh.global_flag,
1519: decode(qpih.global_flag,
1520: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1521: null,
1522: qpih.global_flag
1523: )
1524: )
1659: --Bug# 5456164 RAVI
1660: qualifier_attr_value_code
1661: ) = ( select
1662: decode(qpiq.active_flag, null, qphq.active_flag,
1663: decode(qpiq.active_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1664: null,qpiq.active_flag
1665: )
1666: ),
1667: decode(qpiq.attribute1, null, qphq.attribute1,
1664: null,qpiq.active_flag
1665: )
1666: ),
1667: decode(qpiq.attribute1, null, qphq.attribute1,
1668: decode(qpiq.attribute1,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1669: null,qpiq.attribute1
1670: )
1671: ),
1672: decode(qpiq.attribute10, null, qphq.attribute10,
1669: null,qpiq.attribute1
1670: )
1671: ),
1672: decode(qpiq.attribute10, null, qphq.attribute10,
1673: decode(qpiq.attribute10,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1674: null,qpiq.attribute10
1675: )
1676: ),
1677: decode(qpiq.attribute11, null, qphq.attribute11,
1674: null,qpiq.attribute10
1675: )
1676: ),
1677: decode(qpiq.attribute11, null, qphq.attribute11,
1678: decode(qpiq.attribute11,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1679: null,qpiq.attribute11
1680: )
1681: ),
1682: decode(qpiq.attribute12, null, qphq.attribute12,
1679: null,qpiq.attribute11
1680: )
1681: ),
1682: decode(qpiq.attribute12, null, qphq.attribute12,
1683: decode(qpiq.attribute12,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1684: null,qpiq.attribute12
1685: )
1686: ),
1687: decode(qpiq.attribute13, null, qphq.attribute13,
1684: null,qpiq.attribute12
1685: )
1686: ),
1687: decode(qpiq.attribute13, null, qphq.attribute13,
1688: decode(qpiq.attribute13,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1689: null,qpiq.attribute13
1690: )
1691: ),
1692: decode(qpiq.attribute14, null, qphq.attribute14,
1689: null,qpiq.attribute13
1690: )
1691: ),
1692: decode(qpiq.attribute14, null, qphq.attribute14,
1693: decode(qpiq.attribute14,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1694: null,qpiq.attribute14
1695: )
1696: ),
1697: decode(qpiq.attribute15, null, qphq.attribute15,
1694: null,qpiq.attribute14
1695: )
1696: ),
1697: decode(qpiq.attribute15, null, qphq.attribute15,
1698: decode(qpiq.attribute15,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1699: null,qpiq.attribute15
1700: )
1701: ),
1702: decode(qpiq.attribute2, null, qphq.attribute2,
1699: null,qpiq.attribute15
1700: )
1701: ),
1702: decode(qpiq.attribute2, null, qphq.attribute2,
1703: decode(qpiq.attribute2,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1704: null,qpiq.attribute2
1705: )
1706: ),
1707: decode(qpiq.attribute3, null, qphq.attribute3,
1704: null,qpiq.attribute2
1705: )
1706: ),
1707: decode(qpiq.attribute3, null, qphq.attribute3,
1708: decode(qpiq.attribute3,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1709: null,qpiq.attribute3
1710: )
1711: ),
1712: decode(qpiq.attribute4, null, qphq.attribute4,
1709: null,qpiq.attribute3
1710: )
1711: ),
1712: decode(qpiq.attribute4, null, qphq.attribute4,
1713: decode(qpiq.attribute4,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1714: null,qpiq.attribute4
1715: )
1716: ),
1717: decode(qpiq.attribute5, null, qphq.attribute5,
1714: null,qpiq.attribute4
1715: )
1716: ),
1717: decode(qpiq.attribute5, null, qphq.attribute5,
1718: decode(qpiq.attribute5,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1719: null,qpiq.attribute5
1720: )
1721: ),
1722: decode(qpiq.attribute6, null, qphq.attribute6,
1719: null,qpiq.attribute5
1720: )
1721: ),
1722: decode(qpiq.attribute6, null, qphq.attribute6,
1723: decode(qpiq.attribute6,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1724: null,qpiq.attribute6
1725: )
1726: ),
1727: decode(qpiq.attribute7, null, qphq.attribute7,
1724: null,qpiq.attribute6
1725: )
1726: ),
1727: decode(qpiq.attribute7, null, qphq.attribute7,
1728: decode(qpiq.attribute7,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1729: null,qpiq.attribute7
1730: )
1731: ),
1732: decode(qpiq.attribute8, null, qphq.attribute8,
1729: null,qpiq.attribute7
1730: )
1731: ),
1732: decode(qpiq.attribute8, null, qphq.attribute8,
1733: decode(qpiq.attribute8,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1734: null,qpiq.attribute8
1735: )
1736: ),
1737: decode(qpiq.attribute9, null, qphq.attribute9,
1734: null,qpiq.attribute8
1735: )
1736: ),
1737: decode(qpiq.attribute9, null, qphq.attribute9,
1738: decode(qpiq.attribute9,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1739: null,qpiq.attribute9
1740: )
1741: ),
1742: decode(qpiq.comparison_operator_code, null, qphq.comparison_operator_code,
1739: null,qpiq.attribute9
1740: )
1741: ),
1742: decode(qpiq.comparison_operator_code, null, qphq.comparison_operator_code,
1743: decode(qpiq.comparison_operator_code,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1744: null,qpiq.comparison_operator_code
1745: )
1746: ),
1747: decode(qpiq.context, null, qphq.context,
1744: null,qpiq.comparison_operator_code
1745: )
1746: ),
1747: decode(qpiq.context, null, qphq.context,
1748: decode(qpiq.context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1749: null,qpiq.context
1750: )
1751: ),
1752: decode(qpiq.created_by, null, qphq.created_by,
1749: null,qpiq.context
1750: )
1751: ),
1752: decode(qpiq.created_by, null, qphq.created_by,
1753: decode(qpiq.created_by,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1754: null,qpiq.created_by
1755: )
1756: ),
1757: --Bug# 5456164 RAVI START
1768: decode(qpiq.created_from_rule,
1769: null,
1770: decode(qpiq.created_from_rule_id, null, qphq.created_from_rule_id,
1771: decode(qpiq.created_from_rule_id,
1772: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1773: null,
1774: qpiq.created_from_rule_id
1775: )
1776: ),
1774: qpiq.created_from_rule_id
1775: )
1776: ),
1777: decode(qpiq.created_from_rule_id, null, null,
1778: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
1779: qpiq.created_from_rule_id
1780: )
1781: ),
1782: --Bug# 5456164 RAVI END
1780: )
1781: ),
1782: --Bug# 5456164 RAVI END
1783: decode(qpiq.creation_date, null, qphq.creation_date,
1784: decode(qpiq.creation_date,QP_BULK_LOADER_PUB.G_NULL_DATE,
1785: null,qpiq.creation_date
1786: )
1787: ),
1788: decode(qpiq.distinct_row_count, null, qphq.distinct_row_count,
1785: null,qpiq.creation_date
1786: )
1787: ),
1788: decode(qpiq.distinct_row_count, null, qphq.distinct_row_count,
1789: decode(qpiq.distinct_row_count,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1790: null,qpiq.distinct_row_count
1791: )
1792: ),
1793: decode(qpiq.end_date_active, null, qphq.end_date_active,
1790: null,qpiq.distinct_row_count
1791: )
1792: ),
1793: decode(qpiq.end_date_active, null, qphq.end_date_active,
1794: decode(qpiq.end_date_active,QP_BULK_LOADER_PUB.G_NULL_DATE,
1795: null,qpiq.end_date_active
1796: )
1797: ),
1798: decode(qpiq.excluder_flag, null, qphq.excluder_flag,
1795: null,qpiq.end_date_active
1796: )
1797: ),
1798: decode(qpiq.excluder_flag, null, qphq.excluder_flag,
1799: decode(qpiq.excluder_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1800: null,qpiq.excluder_flag
1801: )
1802: ),
1803: decode(qpiq.header_quals_exist_flag, null, qphq.header_quals_exist_flag,
1800: null,qpiq.excluder_flag
1801: )
1802: ),
1803: decode(qpiq.header_quals_exist_flag, null, qphq.header_quals_exist_flag,
1804: decode(qpiq.header_quals_exist_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1805: null,qpiq.header_quals_exist_flag
1806: )
1807: ),
1808: decode(qpiq.list_header_id, null, qphq.list_header_id,
1805: null,qpiq.header_quals_exist_flag
1806: )
1807: ),
1808: decode(qpiq.list_header_id, null, qphq.list_header_id,
1809: decode(qpiq.list_header_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1810: null,qpiq.list_header_id
1811: )
1812: ),
1813: decode(qpiq.list_line_id, null, qphq.list_line_id,
1810: null,qpiq.list_header_id
1811: )
1812: ),
1813: decode(qpiq.list_line_id, null, qphq.list_line_id,
1814: decode(qpiq.list_line_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1815: null,qpiq.list_line_id
1816: )
1817: ),
1818: decode(qpiq.list_type_code, null, qphq.list_type_code,
1815: null,qpiq.list_line_id
1816: )
1817: ),
1818: decode(qpiq.list_type_code, null, qphq.list_type_code,
1819: decode(qpiq.list_type_code,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1820: null,qpiq.list_type_code
1821: )
1822: ),
1823: decode(qpiq.orig_sys_header_ref, null, qphq.orig_sys_header_ref,
1820: null,qpiq.list_type_code
1821: )
1822: ),
1823: decode(qpiq.orig_sys_header_ref, null, qphq.orig_sys_header_ref,
1824: decode(qpiq.orig_sys_header_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1825: null,qpiq.orig_sys_header_ref
1826: )
1827: ),
1828: decode(qpiq.orig_sys_line_ref, null, qphq.orig_sys_line_ref,
1825: null,qpiq.orig_sys_header_ref
1826: )
1827: ),
1828: decode(qpiq.orig_sys_line_ref, null, qphq.orig_sys_line_ref,
1829: decode(qpiq.orig_sys_line_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1830: null,qpiq.orig_sys_line_ref
1831: )
1832: ),
1833: decode(qpiq.orig_sys_qualifier_ref, null, qphq.orig_sys_qualifier_ref,
1830: null,qpiq.orig_sys_line_ref
1831: )
1832: ),
1833: decode(qpiq.orig_sys_qualifier_ref, null, qphq.orig_sys_qualifier_ref,
1834: decode(qpiq.orig_sys_qualifier_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1835: null,qpiq.orig_sys_qualifier_ref
1836: )
1837: ),
1838: decode(qpiq.program_application_id, null, qphq.program_application_id,
1835: null,qpiq.orig_sys_qualifier_ref
1836: )
1837: ),
1838: decode(qpiq.program_application_id, null, qphq.program_application_id,
1839: decode(qpiq.program_application_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1840: null,qpiq.program_application_id
1841: )
1842: ),
1843: decode(qpiq.program_id, null, qphq.program_id,
1840: null,qpiq.program_application_id
1841: )
1842: ),
1843: decode(qpiq.program_id, null, qphq.program_id,
1844: decode(qpiq.program_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1845: null,qpiq.program_id
1846: )
1847: ),
1848: decode(qpiq.program_update_date, null, qphq.program_update_date,
1845: null,qpiq.program_id
1846: )
1847: ),
1848: decode(qpiq.program_update_date, null, qphq.program_update_date,
1849: decode(qpiq.program_update_date,QP_BULK_LOADER_PUB.G_NULL_DATE,
1850: null,qpiq.program_update_date
1851: )
1852: ),
1853: decode(qpiq.qual_attr_value_from_number, null, qphq.qual_attr_value_from_number,
1850: null,qpiq.program_update_date
1851: )
1852: ),
1853: decode(qpiq.qual_attr_value_from_number, null, qphq.qual_attr_value_from_number,
1854: decode(qpiq.qual_attr_value_from_number,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1855: null,qpiq.qual_attr_value_from_number
1856: )
1857: ),
1858: decode(qpiq.qual_attr_value_to_number, null, qphq.qual_attr_value_to_number,
1855: null,qpiq.qual_attr_value_from_number
1856: )
1857: ),
1858: decode(qpiq.qual_attr_value_to_number, null, qphq.qual_attr_value_to_number,
1859: decode(qpiq.qual_attr_value_to_number,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1860: null,qpiq.qual_attr_value_to_number
1861: )
1862: ),
1863: --Bug# 5456164 RAVI START
1874: decode(qpiq.qualifier_attr_value_code,
1875: null,
1876: decode(qpiq.qualifier_attr_value, null, qphq.qualifier_attr_value,
1877: decode(qpiq.qualifier_attr_value,
1878: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1879: null,
1880: qpiq.qualifier_attr_value
1881: )
1882: ),
1880: qpiq.qualifier_attr_value
1881: )
1882: ),
1883: decode(qpiq.qualifier_attr_value, null, null,
1884: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
1885: qpiq.qualifier_attr_value
1886: )
1887: ),
1888: decode(qpiq.qualifier_attribute_code,
1888: decode(qpiq.qualifier_attribute_code,
1889: null,
1890: decode(qpiq.qualifier_attribute, null, qphq.qualifier_attribute,
1891: decode(qpiq.qualifier_attribute,
1892: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1893: null,
1894: qpiq.qualifier_attribute
1895: )
1896: ),
1894: qpiq.qualifier_attribute
1895: )
1896: ),
1897: decode(qpiq.qualifier_attribute, null, null,
1898: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
1899: qpiq.qualifier_attribute
1900: )
1901: ),
1902: --Bug# 5456164 RAVI END
1900: )
1901: ),
1902: --Bug# 5456164 RAVI END
1903: decode(qpiq.qualifier_context, null, qphq.qualifier_context,
1904: decode(qpiq.qualifier_context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1905: null,qpiq.qualifier_context
1906: )
1907: ),
1908: decode(qpiq.qualifier_datatype, null, qphq.qualifier_datatype,
1905: null,qpiq.qualifier_context
1906: )
1907: ),
1908: decode(qpiq.qualifier_datatype, null, qphq.qualifier_datatype,
1909: decode(qpiq.qualifier_datatype,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1910: null,qpiq.qualifier_datatype
1911: )
1912: ),
1913: decode(qpiq.qualifier_group_cnt, null, qphq.qualifier_group_cnt,
1910: null,qpiq.qualifier_datatype
1911: )
1912: ),
1913: decode(qpiq.qualifier_group_cnt, null, qphq.qualifier_group_cnt,
1914: decode(qpiq.qualifier_group_cnt,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1915: null,qpiq.qualifier_group_cnt
1916: )
1917: ),
1918: decode(qpiq.qualifier_grouping_no, null, qphq.qualifier_grouping_no,
1915: null,qpiq.qualifier_group_cnt
1916: )
1917: ),
1918: decode(qpiq.qualifier_grouping_no, null, qphq.qualifier_grouping_no,
1919: decode(qpiq.qualifier_grouping_no,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1920: null,qpiq.qualifier_grouping_no
1921: )
1922: ),
1923: decode(qpiq.qualifier_id, null, qphq.qualifier_id,
1920: null,qpiq.qualifier_grouping_no
1921: )
1922: ),
1923: decode(qpiq.qualifier_id, null, qphq.qualifier_id,
1924: decode(qpiq.qualifier_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1925: null,qpiq.qualifier_id
1926: )
1927: ),
1928: decode(qpiq.qualifier_precedence, null, qphq.qualifier_precedence,
1925: null,qpiq.qualifier_id
1926: )
1927: ),
1928: decode(qpiq.qualifier_precedence, null, qphq.qualifier_precedence,
1929: decode(qpiq.qualifier_precedence,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1930: null,qpiq.qualifier_precedence
1931: )
1932: ),
1933: --Bug# 5456164 RAVI START
1944: decode(qpiq.qualifier_rule,
1945: null,
1946: decode(qpiq.qualifier_rule_id, null, qphq.qualifier_rule_id,
1947: decode(qpiq.qualifier_rule_id,
1948: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1949: null,
1950: qpiq.qualifier_rule_id
1951: )
1952: ),
1950: qpiq.qualifier_rule_id
1951: )
1952: ),
1953: decode(qpiq.qualifier_rule_id, null, null,
1954: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
1955: qpiq.qualifier_rule_id
1956: )
1957: ),
1958: --Bug# 5456164 RAVI END
1956: )
1957: ),
1958: --Bug# 5456164 RAVI END
1959: decode(qpiq.qualify_hier_descendents_flag, null, qphq.qualify_hier_descendents_flag,
1960: decode(qpiq.qualify_hier_descendents_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1961: null,qpiq.qualify_hier_descendents_flag
1962: )
1963: ),
1964: decode(qpiq.search_ind, null, qphq.search_ind,
1961: null,qpiq.qualify_hier_descendents_flag
1962: )
1963: ),
1964: decode(qpiq.search_ind, null, qphq.search_ind,
1965: decode(qpiq.search_ind,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1966: null,qpiq.search_ind
1967: )
1968: ),
1969: decode(qpiq.start_date_active, null, qphq.start_date_active,
1966: null,qpiq.search_ind
1967: )
1968: ),
1969: decode(qpiq.start_date_active, null, qphq.start_date_active,
1970: decode(qpiq.start_date_active,QP_BULK_LOADER_PUB.G_NULL_DATE,
1971: null,qpiq.start_date_active
1972: )
1973: ),
1974: --Bug# 5456164 RAVI
1972: )
1973: ),
1974: --Bug# 5456164 RAVI
1975: decode(qpiq.qualifier_attr_value_code,
1976: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
1977: qpiq.qualifier_attr_value_code
1978: )
1979: from qp_qualifiers qphq,
1980: qp_list_headers_b qplh
2162: substitution_value
2163: ) = ( select
2164: decode(qpil.accrual_conversion_rate, null, qpll.accrual_conversion_rate,
2165: decode(qpil.accrual_conversion_rate,
2166: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2167: null,
2168: qpil.accrual_conversion_rate
2169: )
2170: ),
2169: )
2170: ),
2171: decode(qpil.accrual_flag, null, qpll.accrual_flag,
2172: decode(qpil.accrual_flag,
2173: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2174: null,
2175: qpil.accrual_flag
2176: )
2177: ),
2176: )
2177: ),
2178: decode(qpil.accrual_qty, null, qpll.accrual_qty,
2179: decode(qpil.accrual_qty,
2180: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2181: null,
2182: qpil.accrual_qty
2183: )
2184: ),
2183: )
2184: ),
2185: decode(qpil.accrual_uom_code, null, qpll.accrual_uom_code,
2186: decode(qpil.accrual_uom_code,
2187: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2188: null,
2189: qpil.accrual_uom_code
2190: )
2191: ),
2190: )
2191: ),
2192: decode(qpil.arithmetic_operator, null, qpll.arithmetic_operator,
2193: decode(qpil.arithmetic_operator,
2194: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2195: null,
2196: qpil.arithmetic_operator
2197: )
2198: ),
2197: )
2198: ),
2199: decode(qpil.attribute1, null, qpll.attribute1,
2200: decode(qpil.attribute1,
2201: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2202: null,
2203: qpil.attribute1
2204: )
2205: ),
2204: )
2205: ),
2206: decode(qpil.attribute10, null, qpll.attribute10,
2207: decode(qpil.attribute10,
2208: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2209: null,
2210: qpil.attribute10
2211: )
2212: ),
2211: )
2212: ),
2213: decode(qpil.attribute11, null, qpll.attribute11,
2214: decode(qpil.attribute11,
2215: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2216: null,
2217: qpil.attribute11
2218: )
2219: ),
2218: )
2219: ),
2220: decode(qpil.attribute12, null, qpll.attribute12,
2221: decode(qpil.attribute12,
2222: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2223: null,
2224: qpil.attribute12
2225: )
2226: ),
2225: )
2226: ),
2227: decode(qpil.attribute13, null, qpll.attribute13,
2228: decode(qpil.attribute13,
2229: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2230: null,
2231: qpil.attribute13
2232: )
2233: ),
2232: )
2233: ),
2234: decode(qpil.attribute14, null, qpll.attribute14,
2235: decode(qpil.attribute14,
2236: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2237: null,
2238: qpil.attribute14
2239: )
2240: ),
2239: )
2240: ),
2241: decode(qpil.attribute15, null, qpll.attribute15,
2242: decode(qpil.attribute15,
2243: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2244: null,
2245: qpil.attribute15
2246: )
2247: ),
2246: )
2247: ),
2248: decode(qpil.attribute2, null, qpll.attribute2,
2249: decode(qpil.attribute2,
2250: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2251: null,
2252: qpil.attribute2
2253: )
2254: ),
2253: )
2254: ),
2255: decode(qpil.attribute3, null, qpll.attribute3,
2256: decode(qpil.attribute3,
2257: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2258: null,
2259: qpil.attribute3
2260: )
2261: ),
2260: )
2261: ),
2262: decode(qpil.attribute4, null, qpll.attribute4,
2263: decode(qpil.attribute4,
2264: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2265: null,
2266: qpil.attribute4
2267: )
2268: ),
2267: )
2268: ),
2269: decode(qpil.attribute5, null, qpll.attribute5,
2270: decode(qpil.attribute5,
2271: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2272: null,
2273: qpil.attribute5
2274: )
2275: ),
2274: )
2275: ),
2276: decode(qpil.attribute6, null, qpll.attribute6,
2277: decode(qpil.attribute6,
2278: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2279: null,
2280: qpil.attribute6
2281: )
2282: ),
2281: )
2282: ),
2283: decode(qpil.attribute7, null, qpll.attribute7,
2284: decode(qpil.attribute7,
2285: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2286: null,
2287: qpil.attribute7
2288: )
2289: ),
2288: )
2289: ),
2290: decode(qpil.attribute8, null, qpll.attribute8,
2291: decode(qpil.attribute8,
2292: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2293: null,
2294: qpil.attribute8
2295: )
2296: ),
2295: )
2296: ),
2297: decode(qpil.attribute9, null, qpll.attribute9,
2298: decode(qpil.attribute9,
2299: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2300: null,
2301: qpil.attribute9
2302: )
2303: ),
2302: )
2303: ),
2304: decode(qpil.automatic_flag, null, qpll.automatic_flag,
2305: decode(qpil.automatic_flag,
2306: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2307: null,
2308: qpil.automatic_flag
2309: )
2310: ),
2309: )
2310: ),
2311: decode(qpil.base_qty, null, qpll.base_qty,
2312: decode(qpil.base_qty,
2313: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2314: null,
2315: qpil.base_qty
2316: )
2317: ),
2316: )
2317: ),
2318: decode(qpil.base_uom_code, null, qpll.base_uom_code,
2319: decode(qpil.base_uom_code,
2320: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2321: null,
2322: qpil.base_uom_code
2323: )
2324: ),
2323: )
2324: ),
2325: decode(qpil.benefit_limit, null, qpll.benefit_limit,
2326: decode(qpil.benefit_limit,
2327: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2328: null,
2329: qpil.benefit_limit
2330: )
2331: ),
2330: )
2331: ),
2332: decode(qpil.benefit_price_list_line_id, null, qpll.benefit_price_list_line_id,
2333: decode(qpil.benefit_price_list_line_id,
2334: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2335: null,
2336: qpil.benefit_price_list_line_id
2337: )
2338: ),
2337: )
2338: ),
2339: decode(qpil.benefit_qty, null, qpll.benefit_qty,
2340: decode(qpil.benefit_qty,
2341: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2342: null,
2343: qpil.benefit_qty
2344: )
2345: ),
2344: )
2345: ),
2346: decode(qpil.benefit_uom_code, null, qpll.benefit_uom_code,
2347: decode(qpil.benefit_uom_code,
2348: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2349: null,
2350: qpil.benefit_uom_code
2351: )
2352: ),
2351: )
2352: ),
2353: decode(qpil.charge_subtype_code, null, qpll.charge_subtype_code,
2354: decode(qpil.charge_subtype_code,
2355: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2356: null,
2357: qpil.charge_subtype_code
2358: )
2359: ),
2358: )
2359: ),
2360: decode(qpil.charge_type_code, null, qpll.charge_type_code,
2361: decode(qpil.charge_type_code,
2362: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2363: null,
2364: qpil.charge_type_code
2365: )
2366: ),
2365: )
2366: ),
2367: decode(qpil.comments, null, qpll.comments,
2368: decode(qpil.comments,
2369: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2370: null,
2371: qpil.comments
2372: )
2373: ),
2372: )
2373: ),
2374: decode(qpil.context, null, qpll.context,
2375: decode(qpil.context,
2376: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2377: null,
2378: qpil.context
2379: )
2380: ),
2379: )
2380: ),
2381: decode(qpil.continuous_price_break_flag, null, qpll.continuous_price_break_flag,
2382: decode(qpil.continuous_price_break_flag,
2383: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2384: null,
2385: qpil.continuous_price_break_flag
2386: )
2387: ),
2386: )
2387: ),
2388: decode(qpil.created_by, null, qpll.created_by,
2389: decode(qpil.created_by,
2390: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2391: null,
2392: qpil.created_by
2393: )
2394: ),
2393: )
2394: ),
2395: decode(qpil.creation_date, null, qpll.creation_date,
2396: decode(qpil.creation_date,
2397: QP_BULK_LOADER_PUB.G_NULL_DATE,
2398: null,
2399: qpil.creation_date
2400: )
2401: ),
2400: )
2401: ),
2402: decode(qpil.effective_period_uom, null, qpll.effective_period_uom,
2403: decode(qpil.effective_period_uom,
2404: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2405: null,
2406: qpil.effective_period_uom
2407: )
2408: ),
2407: )
2408: ),
2409: decode(qpil.end_date_active, null, qpll.end_date_active,
2410: decode(qpil.end_date_active,
2411: QP_BULK_LOADER_PUB.G_NULL_DATE,
2412: null,
2413: qpil.end_date_active
2414: )
2415: ),
2414: )
2415: ),
2416: decode(qpil.estim_accrual_rate, null, qpll.estim_accrual_rate,
2417: decode(qpil.estim_accrual_rate,
2418: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2419: null,
2420: qpil.estim_accrual_rate
2421: )
2422: ),
2421: )
2422: ),
2423: decode(qpil.estim_gl_value, null, qpll.estim_gl_value,
2424: decode(qpil.estim_gl_value,
2425: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2426: null,
2427: qpil.estim_gl_value
2428: )
2429: ),
2428: )
2429: ),
2430: decode(qpil.expiration_date, null, qpll.expiration_date,
2431: decode(qpil.expiration_date,
2432: QP_BULK_LOADER_PUB.G_NULL_DATE,
2433: null,
2434: qpil.expiration_date
2435: )
2436: ),
2435: )
2436: ),
2437: decode(qpil.expiration_period_start_date, null, qpll.expiration_period_start_date,
2438: decode(qpil.expiration_period_start_date,
2439: QP_BULK_LOADER_PUB.G_NULL_DATE,
2440: null,
2441: qpil.expiration_period_start_date
2442: )
2443: ),
2442: )
2443: ),
2444: decode(qpil.expiration_period_uom, null, qpll.expiration_period_uom,
2445: decode(qpil.expiration_period_uom,
2446: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2447: null,
2448: qpil.expiration_period_uom
2449: )
2450: ),
2462: decode(qpil.generate_using_formula,
2463: null,
2464: decode(qpil.generate_using_formula_id, null, qpll.generate_using_formula_id,
2465: decode(qpil.generate_using_formula_id,
2466: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2467: null,
2468: qpil.generate_using_formula_id
2469: )
2470: ),
2468: qpil.generate_using_formula_id
2469: )
2470: ),
2471: decode(qpil.generate_using_formula_id, null, null,
2472: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
2473: qpil.generate_using_formula_id
2474: )
2475: ),
2476: --Bug# 5412029 RAVI END
2475: ),
2476: --Bug# 5412029 RAVI END
2477: decode(qpil.include_on_returns_flag, null, qpll.include_on_returns_flag,
2478: decode(qpil.include_on_returns_flag,
2479: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2480: null,
2481: qpil.include_on_returns_flag
2482: )
2483: ),
2482: )
2483: ),
2484: decode(qpil.incompatibility_grp_code, null, qpll.incompatibility_grp_code,
2485: decode(qpil.incompatibility_grp_code,
2486: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2487: null,
2488: qpil.incompatibility_grp_code
2489: )
2490: ),
2489: )
2490: ),
2491: decode(qpil.inventory_item_id, null, qpll.inventory_item_id,
2492: decode(qpil.inventory_item_id,
2493: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2494: null,
2495: qpil.inventory_item_id
2496: )
2497: ),
2496: )
2497: ),
2498: decode(qpil.list_header_id, null, qpll.list_header_id,
2499: decode(qpil.list_header_id,
2500: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2501: null,
2502: qpil.list_header_id
2503: )
2504: ),
2503: )
2504: ),
2505: decode(qpil.list_line_id, null, qpll.list_line_id,
2506: decode(qpil.list_line_id,
2507: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2508: null,
2509: qpil.list_line_id
2510: )
2511: ),
2510: )
2511: ),
2512: decode(qpil.list_line_no, null, qpll.list_line_no,
2513: decode(qpil.list_line_no,
2514: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2515: null,
2516: qpil.list_line_no
2517: )
2518: ),
2517: )
2518: ),
2519: decode(qpil.list_line_type_code, null, qpll.list_line_type_code,
2520: decode(qpil.list_line_type_code,
2521: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2522: null,
2523: qpil.list_line_type_code
2524: )
2525: ),
2524: )
2525: ),
2526: decode(qpil.list_price, null, qpll.list_price,
2527: decode(qpil.list_price,
2528: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2529: null,
2530: qpil.list_price
2531: )
2532: ),
2531: )
2532: ),
2533: decode(qpil.list_price_uom_code, null, qpll.list_price_uom_code,
2534: decode(qpil.list_price_uom_code,
2535: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2536: null,
2537: qpil.list_price_uom_code
2538: )
2539: ),
2538: )
2539: ),
2540: decode(qpil.modifier_level_code, null, qpll.modifier_level_code,
2541: decode(qpil.modifier_level_code,
2542: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2543: null,
2544: qpil.modifier_level_code
2545: )
2546: ),
2545: )
2546: ),
2547: decode(qpil.net_amount_flag, null, qpll.net_amount_flag,
2548: decode(qpil.net_amount_flag,
2549: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2550: null,
2551: qpil.net_amount_flag
2552: )
2553: ),
2552: )
2553: ),
2554: decode(qpil.number_effective_periods, null, qpll.number_effective_periods,
2555: decode(qpil.number_effective_periods,
2556: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2557: null,
2558: qpil.number_effective_periods
2559: )
2560: ),
2559: )
2560: ),
2561: decode(qpil.number_expiration_periods, null, qpll.number_expiration_periods,
2562: decode(qpil.number_expiration_periods,
2563: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2564: null,
2565: qpil.number_expiration_periods
2566: )
2567: ),
2566: )
2567: ),
2568: decode(qpil.operand, null, qpll.operand,
2569: decode(qpil.operand,
2570: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2571: null,
2572: qpil.operand
2573: )
2574: ),
2573: )
2574: ),
2575: decode(qpil.organization_id, null, qpll.organization_id,
2576: decode(qpil.organization_id,
2577: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2578: null,
2579: qpil.organization_id
2580: )
2581: ),
2580: )
2581: ),
2582: decode(qpil.orig_sys_header_ref, null, qpll.orig_sys_header_ref,
2583: decode(qpil.orig_sys_header_ref,
2584: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2585: null,
2586: qpil.orig_sys_header_ref
2587: )
2588: ),
2587: )
2588: ),
2589: decode(qpil.orig_sys_line_ref, null, qpll.orig_sys_line_ref,
2590: decode(qpil.orig_sys_line_ref,
2591: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2592: null,
2593: qpil.orig_sys_line_ref
2594: )
2595: ),
2594: )
2595: ),
2596: decode(qpil.override_flag, null, qpll.override_flag,
2597: decode(qpil.override_flag,
2598: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2599: null,
2600: qpil.override_flag
2601: )
2602: ),
2601: )
2602: ),
2603: decode(qpil.percent_price, null, qpll.percent_price,
2604: decode(qpil.percent_price,
2605: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2606: null,
2607: qpil.percent_price
2608: )
2609: ),
2614: and rm.from_rltd_modifier_id = pll.list_line_id
2615: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
2616: ),
2617: decode(qpil.price_break_header_ref,
2618: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2619: null,
2620: qpil.price_break_header_ref
2621: )
2622: ),
2621: )
2622: ),
2623: decode(qpil.price_break_type_code, null, qpll.price_break_type_code,
2624: decode(qpil.price_break_type_code,
2625: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2626: null,
2627: qpil.price_break_type_code
2628: )
2629: ),
2641: decode(qpil.price_by_formula,
2642: null,
2643: decode(qpil.price_by_formula_id, null, qpll.price_by_formula_id,
2644: decode(qpil.price_by_formula_id,
2645: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2646: null,
2647: qpil.price_by_formula_id
2648: )
2649: ),
2647: qpil.price_by_formula_id
2648: )
2649: ),
2650: decode(qpil.price_by_formula_id, null, null,
2651: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
2652: qpil.price_by_formula_id
2653: )
2654: ),
2655: --Bug# 5412029 RAVI END
2654: ),
2655: --Bug# 5412029 RAVI END
2656: decode(qpil.pricing_group_sequence, null, qpll.pricing_group_sequence,
2657: decode(qpil.pricing_group_sequence,
2658: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2659: null,
2660: qpil.pricing_group_sequence
2661: )
2662: ),
2661: )
2662: ),
2663: decode(qpil.pricing_phase_id, null, qpll.pricing_phase_id,
2664: decode(qpil.pricing_phase_id,
2665: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2666: null,
2667: qpil.pricing_phase_id
2668: )
2669: ),
2668: )
2669: ),
2670: decode(qpil.primary_uom_flag, null, qpll.primary_uom_flag,
2671: decode(qpil.primary_uom_flag,
2672: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2673: null,
2674: qpil.primary_uom_flag
2675: )
2676: ),
2675: )
2676: ),
2677: decode(qpil.print_on_invoice_flag, null, qpll.print_on_invoice_flag,
2678: decode(qpil.print_on_invoice_flag,
2679: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2680: null,
2681: qpil.print_on_invoice_flag
2682: )
2683: ),
2682: )
2683: ),
2684: decode(qpil.product_precedence, null, qpll.product_precedence,
2685: decode(qpil.product_precedence,
2686: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2687: null,
2688: qpil.product_precedence
2689: )
2690: ),
2689: )
2690: ),
2691: decode(qpil.program_application_id, null, qpll.program_application_id,
2692: decode(qpil.program_application_id,
2693: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2694: null,
2695: qpil.program_application_id
2696: )
2697: ),
2696: )
2697: ),
2698: decode(qpil.program_id, null, qpll.program_id,
2699: decode(qpil.program_id,
2700: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2701: null,
2702: qpil.program_id
2703: )
2704: ),
2703: )
2704: ),
2705: decode(qpil.program_update_date, null, qpll.program_update_date,
2706: decode(qpil.program_update_date,
2707: QP_BULK_LOADER_PUB.G_NULL_DATE,
2708: null,
2709: qpil.program_update_date
2710: )
2711: ),
2710: )
2711: ),
2712: decode(qpil.proration_type_code, null, qpll.proration_type_code,
2713: decode(qpil.proration_type_code,
2714: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2715: null,
2716: qpil.proration_type_code
2717: )
2718: ),
2717: )
2718: ),
2719: decode(qpil.qualification_ind, null, qpll.qualification_ind,
2720: decode(qpil.qualification_ind,
2721: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2722: null,
2723: qpil.qualification_ind
2724: )
2725: ),
2724: )
2725: ),
2726: decode(qpil.rebate_transaction_type_code, null, qpll.rebate_transaction_type_code,
2727: decode(qpil.rebate_transaction_type_code,
2728: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2729: null,
2730: qpil.rebate_transaction_type_code
2731: )
2732: ),
2731: )
2732: ),
2733: decode(qpil.recurring_flag, null, qpll.recurring_flag,
2734: decode(qpil.recurring_flag,
2735: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2736: null,
2737: qpil.recurring_flag
2738: )
2739: ),
2738: )
2739: ),
2740: decode(qpil.recurring_value, null, qpll.recurring_value,
2741: decode(qpil.recurring_value,
2742: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2743: null,
2744: qpil.recurring_value
2745: )
2746: ),
2745: )
2746: ),
2747: decode(qpil.related_item_id, null, qpll.related_item_id,
2748: decode(qpil.related_item_id,
2749: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2750: null,
2751: qpil.related_item_id
2752: )
2753: ),
2752: )
2753: ),
2754: decode(qpil.relationship_type_id, null, qpll.relationship_type_id,
2755: decode(qpil.relationship_type_id,
2756: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2757: null,
2758: qpil.relationship_type_id
2759: )
2760: ),
2759: )
2760: ),
2761: decode(qpil.reprice_flag, null, qpll.reprice_flag,
2762: decode(qpil.reprice_flag,
2763: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2764: null,
2765: qpil.reprice_flag
2766: )
2767: ),
2766: )
2767: ),
2768: decode(qpil.revision, null, qpll.revision,
2769: decode(qpil.revision,
2770: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2771: null,
2772: qpil.revision
2773: )
2774: ),
2773: )
2774: ),
2775: decode(qpil.revision_date, null, qpll.revision_date,
2776: decode(qpil.revision_date,
2777: QP_BULK_LOADER_PUB.G_NULL_DATE,
2778: null,
2779: qpil.revision_date
2780: )
2781: ),
2780: )
2781: ),
2782: decode(qpil.revision_reason_code, null, qpll.revision_reason_code,
2783: decode(qpil.revision_reason_code,
2784: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2785: null,
2786: qpil.revision_reason_code
2787: )
2788: ),
2793: and rm.from_rltd_modifier_id = pll.list_line_id
2794: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
2795: ),
2796: decode(qpil.rltd_modifier_grp_type,
2797: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2798: null,
2799: qpil.rltd_modifier_grp_type
2800: )
2801: ),
2800: )
2801: ),
2802: decode(qpil.start_date_active, null, qpll.start_date_active,
2803: decode(qpil.start_date_active,
2804: QP_BULK_LOADER_PUB.G_NULL_DATE,
2805: null,
2806: qpil.start_date_active
2807: )
2808: ),
2807: )
2808: ),
2809: decode(qpil.substitution_attribute, null, qpll.substitution_attribute,
2810: decode(qpil.substitution_attribute,
2811: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2812: null,
2813: qpil.substitution_attribute
2814: )
2815: ),
2814: )
2815: ),
2816: decode(qpil.substitution_context, null, qpll.substitution_context,
2817: decode(qpil.substitution_context,
2818: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2819: null,
2820: qpil.substitution_context
2821: )
2822: ),
2821: )
2822: ),
2823: decode(qpil.substitution_value, null, qpll.substitution_value,
2824: decode(qpil.substitution_value,
2825: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2826: null,
2827: qpil.substitution_value
2828: )
2829: )
2956: pricing_attr_value_to_disp
2957: --Bug#5456164 RAVI START
2958: ) = ( select
2959: decode(qpip.accumulate_flag, null, qppa.accumulate_flag,
2960: decode(qpip.accumulate_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
2961: null,qpip.accumulate_flag
2962: )
2963: ),
2964: decode(qpip.attribute_grouping_no, null, qppa.attribute_grouping_no,
2961: null,qpip.accumulate_flag
2962: )
2963: ),
2964: decode(qpip.attribute_grouping_no, null, qppa.attribute_grouping_no,
2965: decode(qpip.attribute_grouping_no,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2966: null,qpip.attribute_grouping_no
2967: )
2968: ),
2969: decode(qpip.attribute1, null, qppa.attribute1,
2966: null,qpip.attribute_grouping_no
2967: )
2968: ),
2969: decode(qpip.attribute1, null, qppa.attribute1,
2970: decode(qpip.attribute1,QP_BULK_LOADER_PUB.G_NULL_CHAR,
2971: null,qpip.attribute1
2972: )
2973: ),
2974: decode(qpip.attribute10, null, qppa.attribute10,
2971: null,qpip.attribute1
2972: )
2973: ),
2974: decode(qpip.attribute10, null, qppa.attribute10,
2975: decode(qpip.attribute10,QP_BULK_LOADER_PUB.G_NULL_CHAR,
2976: null,qpip.attribute10
2977: )
2978: ),
2979: decode(qpip.attribute11, null, qppa.attribute11,
2976: null,qpip.attribute10
2977: )
2978: ),
2979: decode(qpip.attribute11, null, qppa.attribute11,
2980: decode(qpip.attribute11,QP_BULK_LOADER_PUB.G_NULL_CHAR,
2981: null,qpip.attribute11
2982: )
2983: ),
2984: decode(qpip.attribute12, null, qppa.attribute12,
2981: null,qpip.attribute11
2982: )
2983: ),
2984: decode(qpip.attribute12, null, qppa.attribute12,
2985: decode(qpip.attribute12,QP_BULK_LOADER_PUB.G_NULL_CHAR,
2986: null,qpip.attribute12
2987: )
2988: ),
2989: decode(qpip.attribute13, null, qppa.attribute13,
2986: null,qpip.attribute12
2987: )
2988: ),
2989: decode(qpip.attribute13, null, qppa.attribute13,
2990: decode(qpip.attribute13,QP_BULK_LOADER_PUB.G_NULL_CHAR,
2991: null,qpip.attribute13
2992: )
2993: ),
2994: decode(qpip.attribute14, null, qppa.attribute14,
2991: null,qpip.attribute13
2992: )
2993: ),
2994: decode(qpip.attribute14, null, qppa.attribute14,
2995: decode(qpip.attribute14,QP_BULK_LOADER_PUB.G_NULL_CHAR,
2996: null,qpip.attribute14
2997: )
2998: ),
2999: decode(qpip.attribute15, null, qppa.attribute15,
2996: null,qpip.attribute14
2997: )
2998: ),
2999: decode(qpip.attribute15, null, qppa.attribute15,
3000: decode(qpip.attribute15,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3001: null,qpip.attribute15
3002: )
3003: ),
3004: decode(qpip.attribute2, null, qppa.attribute2,
3001: null,qpip.attribute15
3002: )
3003: ),
3004: decode(qpip.attribute2, null, qppa.attribute2,
3005: decode(qpip.attribute2,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3006: null,qpip.attribute2
3007: )
3008: ),
3009: decode(qpip.attribute3, null, qppa.attribute3,
3006: null,qpip.attribute2
3007: )
3008: ),
3009: decode(qpip.attribute3, null, qppa.attribute3,
3010: decode(qpip.attribute3,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3011: null,qpip.attribute3
3012: )
3013: ),
3014: decode(qpip.attribute4, null, qppa.attribute4,
3011: null,qpip.attribute3
3012: )
3013: ),
3014: decode(qpip.attribute4, null, qppa.attribute4,
3015: decode(qpip.attribute4,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3016: null,qpip.attribute4
3017: )
3018: ),
3019: decode(qpip.attribute5, null, qppa.attribute5,
3016: null,qpip.attribute4
3017: )
3018: ),
3019: decode(qpip.attribute5, null, qppa.attribute5,
3020: decode(qpip.attribute5,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3021: null,qpip.attribute5
3022: )
3023: ),
3024: decode(qpip.attribute6, null, qppa.attribute6,
3021: null,qpip.attribute5
3022: )
3023: ),
3024: decode(qpip.attribute6, null, qppa.attribute6,
3025: decode(qpip.attribute6,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3026: null,qpip.attribute6
3027: )
3028: ),
3029: decode(qpip.attribute7, null, qppa.attribute7,
3026: null,qpip.attribute6
3027: )
3028: ),
3029: decode(qpip.attribute7, null, qppa.attribute7,
3030: decode(qpip.attribute7,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3031: null,qpip.attribute7
3032: )
3033: ),
3034: decode(qpip.attribute8, null, qppa.attribute8,
3031: null,qpip.attribute7
3032: )
3033: ),
3034: decode(qpip.attribute8, null, qppa.attribute8,
3035: decode(qpip.attribute8,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3036: null,qpip.attribute8
3037: )
3038: ),
3039: decode(qpip.attribute9, null, qppa.attribute9,
3036: null,qpip.attribute8
3037: )
3038: ),
3039: decode(qpip.attribute9, null, qppa.attribute9,
3040: decode(qpip.attribute9,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3041: null,qpip.attribute9
3042: )
3043: ),
3044: decode(qpip.comparison_operator_code, null, qppa.comparison_operator_code,
3041: null,qpip.attribute9
3042: )
3043: ),
3044: decode(qpip.comparison_operator_code, null, qppa.comparison_operator_code,
3045: decode(qpip.comparison_operator_code,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3046: null,qpip.comparison_operator_code
3047: )
3048: ),
3049: decode(qpip.context, null, qppa.context,
3046: null,qpip.comparison_operator_code
3047: )
3048: ),
3049: decode(qpip.context, null, qppa.context,
3050: decode(qpip.context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3051: null,qpip.context
3052: )
3053: ),
3054: decode(qpip.created_by, null, qppa.created_by,
3051: null,qpip.context
3052: )
3053: ),
3054: decode(qpip.created_by, null, qppa.created_by,
3055: decode(qpip.created_by,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3056: null,qpip.created_by
3057: )
3058: ),
3059: decode(qpip.excluder_flag, null, qppa.excluder_flag,
3056: null,qpip.created_by
3057: )
3058: ),
3059: decode(qpip.excluder_flag, null, qppa.excluder_flag,
3060: decode(qpip.excluder_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3061: null,qpip.excluder_flag
3062: )
3063: ),
3064: decode(qpip.list_header_id, null, qppa.list_header_id,
3061: null,qpip.excluder_flag
3062: )
3063: ),
3064: decode(qpip.list_header_id, null, qppa.list_header_id,
3065: decode(qpip.list_header_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3066: null,qpip.list_header_id
3067: )
3068: ),
3069: decode(qpip.list_line_id, null, qppa.list_line_id,
3066: null,qpip.list_header_id
3067: )
3068: ),
3069: decode(qpip.list_line_id, null, qppa.list_line_id,
3070: decode(qpip.list_line_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3071: null,qpip.list_line_id
3072: )
3073: ),
3074: decode(qpip.orig_sys_header_ref, null, qppa.orig_sys_header_ref,
3071: null,qpip.list_line_id
3072: )
3073: ),
3074: decode(qpip.orig_sys_header_ref, null, qppa.orig_sys_header_ref,
3075: decode(qpip.orig_sys_header_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3076: null,qpip.orig_sys_header_ref
3077: )
3078: ),
3079: decode(qpip.orig_sys_line_ref, null, qppa.orig_sys_line_ref,
3076: null,qpip.orig_sys_header_ref
3077: )
3078: ),
3079: decode(qpip.orig_sys_line_ref, null, qppa.orig_sys_line_ref,
3080: decode(qpip.orig_sys_line_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3081: null,qpip.orig_sys_line_ref
3082: )
3083: ),
3084: decode(qpip.orig_sys_pricing_attr_ref, null, qppa.orig_sys_pricing_attr_ref,
3081: null,qpip.orig_sys_line_ref
3082: )
3083: ),
3084: decode(qpip.orig_sys_pricing_attr_ref, null, qppa.orig_sys_pricing_attr_ref,
3085: decode(qpip.orig_sys_pricing_attr_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3086: null,qpip.orig_sys_pricing_attr_ref
3087: )
3088: ),
3089: --Bug# 5456164 RAVI START
3100: decode(qpip.pricing_attr_value_from_disp,
3101: null,
3102: decode(qpip.pricing_attr_value_from, null, qppa.pricing_attr_value_from,
3103: decode(qpip.pricing_attr_value_from,
3104: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3105: null,
3106: qpip.pricing_attr_value_from
3107: )
3108: ),
3106: qpip.pricing_attr_value_from
3107: )
3108: ),
3109: decode(qpip.pricing_attr_value_from, null, null,
3110: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
3111: qpip.pricing_attr_value_from
3112: )
3113: ),
3114: --Bug# 5456164 RAVI END
3112: )
3113: ),
3114: --Bug# 5456164 RAVI END
3115: decode(qpip.pricing_attr_value_from_number, null, qppa.pricing_attr_value_from_number,
3116: decode(qpip.pricing_attr_value_from_number,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3117: null,qpip.pricing_attr_value_from_number
3118: )
3119: ),
3120: --Bug# 5456164 RAVI START
3131: decode(qpip.pricing_attr_value_to_disp,
3132: null,
3133: decode(qpip.pricing_attr_value_to, null, qppa.pricing_attr_value_to,
3134: decode(qpip.pricing_attr_value_to,
3135: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3136: null,
3137: qpip.pricing_attr_value_to
3138: )
3139: ),
3137: qpip.pricing_attr_value_to
3138: )
3139: ),
3140: decode(qpip.pricing_attr_value_to, null, null,
3141: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
3142: qpip.pricing_attr_value_to
3143: )
3144: ),
3145: --Bug# 5456164 RAVI END
3143: )
3144: ),
3145: --Bug# 5456164 RAVI END
3146: decode(qpip.pricing_attr_value_to_number, null, qppa.pricing_attr_value_to_number,
3147: decode(qpip.pricing_attr_value_to_number,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3148: null,qpip.pricing_attr_value_to_number
3149: )
3150: ),
3151: --Bug# 5456164 RAVI START
3162: decode(qpip.pricing_attr_code,
3163: null,
3164: decode(qpip.pricing_attribute, null, qppa.pricing_attribute,
3165: decode(qpip.pricing_attribute,
3166: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3167: null,
3168: qpip.pricing_attribute
3169: )
3170: ),
3168: qpip.pricing_attribute
3169: )
3170: ),
3171: decode(qpip.pricing_attribute, null, null,
3172: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
3173: qpip.pricing_attribute
3174: )
3175: ),
3176: --Bug# 5456164 RAVI END
3174: )
3175: ),
3176: --Bug# 5456164 RAVI END
3177: decode(qpip.pricing_attribute_context, null, qppa.pricing_attribute_context,
3178: decode(qpip.pricing_attribute_context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3179: null,qpip.pricing_attribute_context
3180: )
3181: ),
3182: decode(qpip.pricing_attribute_datatype, null, qppa.pricing_attribute_datatype,
3179: null,qpip.pricing_attribute_context
3180: )
3181: ),
3182: decode(qpip.pricing_attribute_datatype, null, qppa.pricing_attribute_datatype,
3183: decode(qpip.pricing_attribute_datatype,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3184: null,qpip.pricing_attribute_datatype
3185: )
3186: ),
3187: decode(qpip.pricing_attribute_id, null, qppa.pricing_attribute_id,
3184: null,qpip.pricing_attribute_datatype
3185: )
3186: ),
3187: decode(qpip.pricing_attribute_id, null, qppa.pricing_attribute_id,
3188: decode(qpip.pricing_attribute_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3189: null,qpip.pricing_attribute_id
3190: )
3191: ),
3192: decode(qpip.pricing_phase_id, null, qppa.pricing_phase_id,
3189: null,qpip.pricing_attribute_id
3190: )
3191: ),
3192: decode(qpip.pricing_phase_id, null, qppa.pricing_phase_id,
3193: decode(qpip.pricing_phase_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3194: null,qpip.pricing_phase_id
3195: )
3196: ),
3197: --Bug# 5456164 RAVI START
3208: decode(qpip.product_attr_val_disp,
3209: null,
3210: decode(qpip.product_attr_value, null, qppa.product_attr_value,
3211: decode(qpip.product_attr_value,
3212: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3213: null,
3214: qpip.product_attr_value
3215: )
3216: ),
3214: qpip.product_attr_value
3215: )
3216: ),
3217: decode(qpip.product_attr_value, null, null,
3218: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
3219: qpip.product_attr_value
3220: )
3221: ),
3222: decode(qpip.product_attr_code,
3222: decode(qpip.product_attr_code,
3223: null,
3224: decode(qpip.product_attribute, null, qppa.product_attribute,
3225: decode(qpip.product_attribute,
3226: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3227: null,
3228: qpip.product_attribute
3229: )
3230: ),
3228: qpip.product_attribute
3229: )
3230: ),
3231: decode(qpip.product_attribute, null, null,
3232: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
3233: qpip.product_attribute
3234: )
3235: ),
3236: --Bug# 5456164 RAVI END
3234: )
3235: ),
3236: --Bug# 5456164 RAVI END
3237: decode(qpip.product_attribute_context, null, qppa.product_attribute_context,
3238: decode(qpip.product_attribute_context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3239: null,qpip.product_attribute_context
3240: )
3241: ),
3242: decode(qpip.product_attribute_datatype, null, qppa.product_attribute_datatype,
3239: null,qpip.product_attribute_context
3240: )
3241: ),
3242: decode(qpip.product_attribute_datatype, null, qppa.product_attribute_datatype,
3243: decode(qpip.product_attribute_datatype,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3244: null,qpip.product_attribute_datatype
3245: )
3246: ),
3247: decode(qpip.product_uom_code, null, qppa.product_uom_code,
3244: null,qpip.product_attribute_datatype
3245: )
3246: ),
3247: decode(qpip.product_uom_code, null, qppa.product_uom_code,
3248: decode(qpip.product_uom_code,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3249: null,qpip.product_uom_code
3250: )
3251: ),
3252: decode(qpip.program_application_id, null, qppa.program_application_id,
3249: null,qpip.product_uom_code
3250: )
3251: ),
3252: decode(qpip.program_application_id, null, qppa.program_application_id,
3253: decode(qpip.program_application_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3254: null,qpip.program_application_id
3255: )
3256: ),
3257: decode(qpip.program_id, null, qppa.program_id,
3254: null,qpip.program_application_id
3255: )
3256: ),
3257: decode(qpip.program_id, null, qppa.program_id,
3258: decode(qpip.program_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3259: null,qpip.program_id
3260: )
3261: ),
3262: decode(qpip.program_update_date, null, qppa.program_update_date,
3259: null,qpip.program_id
3260: )
3261: ),
3262: decode(qpip.program_update_date, null, qppa.program_update_date,
3263: decode(qpip.program_update_date,QP_BULK_LOADER_PUB.G_NULL_DATE,
3264: null,qpip.program_update_date
3265: )
3266: ),
3267: decode(qpip.qualification_ind, null, qppa.qualification_ind,
3264: null,qpip.program_update_date
3265: )
3266: ),
3267: decode(qpip.qualification_ind, null, qppa.qualification_ind,
3268: decode(qpip.qualification_ind,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3269: null,qpip.qualification_ind
3270: )
3271: ),
3272: --Bug# 5456164 RAVI START
3271: ),
3272: --Bug# 5456164 RAVI START
3273: --If ID in ID_to_VAL is G_CHAR then set it null
3274: decode(qpip.product_attr_val_disp,
3275: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3276: qpip.product_attr_val_disp
3277: ),
3278: decode(qpip.pricing_attr_value_from_disp,
3279: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3275: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3276: qpip.product_attr_val_disp
3277: ),
3278: decode(qpip.pricing_attr_value_from_disp,
3279: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3280: qpip.pricing_attr_value_from_disp
3281: ),
3282: decode(qpip.pricing_attr_value_to_disp,
3283: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3279: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3280: qpip.pricing_attr_value_from_disp
3281: ),
3282: decode(qpip.pricing_attr_value_to_disp,
3283: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3284: qpip.pricing_attr_value_to_disp
3285: )
3286: --Bug# 5456164 RAVI END
3287: from qp_pricing_attributes qppa,
3577: substitution_value
3578: ) = ( select
3579: decode(qpil.accrual_conversion_rate, null, qpll.accrual_conversion_rate,
3580: decode(qpil.accrual_conversion_rate,
3581: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3582: null,
3583: qpil.accrual_conversion_rate
3584: )
3585: ),
3584: )
3585: ),
3586: decode(qpil.accrual_flag, null, qpll.accrual_flag,
3587: decode(qpil.accrual_flag,
3588: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3589: null,
3590: qpil.accrual_flag
3591: )
3592: ),
3591: )
3592: ),
3593: decode(qpil.accrual_qty, null, qpll.accrual_qty,
3594: decode(qpil.accrual_qty,
3595: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3596: null,
3597: qpil.accrual_qty
3598: )
3599: ),
3598: )
3599: ),
3600: decode(qpil.accrual_uom_code, null, qpll.accrual_uom_code,
3601: decode(qpil.accrual_uom_code,
3602: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3603: null,
3604: qpil.accrual_uom_code
3605: )
3606: ),
3605: )
3606: ),
3607: decode(qpil.arithmetic_operator, null, qpll.arithmetic_operator,
3608: decode(qpil.arithmetic_operator,
3609: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3610: null,
3611: qpil.arithmetic_operator
3612: )
3613: ),
3612: )
3613: ),
3614: decode(qpil.attribute1, null, qpll.attribute1,
3615: decode(qpil.attribute1,
3616: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3617: null,
3618: qpil.attribute1
3619: )
3620: ),
3619: )
3620: ),
3621: decode(qpil.attribute10, null, qpll.attribute10,
3622: decode(qpil.attribute10,
3623: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3624: null,
3625: qpil.attribute10
3626: )
3627: ),
3626: )
3627: ),
3628: decode(qpil.attribute11, null, qpll.attribute11,
3629: decode(qpil.attribute11,
3630: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3631: null,
3632: qpil.attribute11
3633: )
3634: ),
3633: )
3634: ),
3635: decode(qpil.attribute12, null, qpll.attribute12,
3636: decode(qpil.attribute12,
3637: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3638: null,
3639: qpil.attribute12
3640: )
3641: ),
3640: )
3641: ),
3642: decode(qpil.attribute13, null, qpll.attribute13,
3643: decode(qpil.attribute13,
3644: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3645: null,
3646: qpil.attribute13
3647: )
3648: ),
3647: )
3648: ),
3649: decode(qpil.attribute14, null, qpll.attribute14,
3650: decode(qpil.attribute14,
3651: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3652: null,
3653: qpil.attribute14
3654: )
3655: ),
3654: )
3655: ),
3656: decode(qpil.attribute15, null, qpll.attribute15,
3657: decode(qpil.attribute15,
3658: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3659: null,
3660: qpil.attribute15
3661: )
3662: ),
3661: )
3662: ),
3663: decode(qpil.attribute2, null, qpll.attribute2,
3664: decode(qpil.attribute2,
3665: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3666: null,
3667: qpil.attribute2
3668: )
3669: ),
3668: )
3669: ),
3670: decode(qpil.attribute3, null, qpll.attribute3,
3671: decode(qpil.attribute3,
3672: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3673: null,
3674: qpil.attribute3
3675: )
3676: ),
3675: )
3676: ),
3677: decode(qpil.attribute4, null, qpll.attribute4,
3678: decode(qpil.attribute4,
3679: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3680: null,
3681: qpil.attribute4
3682: )
3683: ),
3682: )
3683: ),
3684: decode(qpil.attribute5, null, qpll.attribute5,
3685: decode(qpil.attribute5,
3686: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3687: null,
3688: qpil.attribute5
3689: )
3690: ),
3689: )
3690: ),
3691: decode(qpil.attribute6, null, qpll.attribute6,
3692: decode(qpil.attribute6,
3693: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3694: null,
3695: qpil.attribute6
3696: )
3697: ),
3696: )
3697: ),
3698: decode(qpil.attribute7, null, qpll.attribute7,
3699: decode(qpil.attribute7,
3700: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3701: null,
3702: qpil.attribute7
3703: )
3704: ),
3703: )
3704: ),
3705: decode(qpil.attribute8, null, qpll.attribute8,
3706: decode(qpil.attribute8,
3707: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3708: null,
3709: qpil.attribute8
3710: )
3711: ),
3710: )
3711: ),
3712: decode(qpil.attribute9, null, qpll.attribute9,
3713: decode(qpil.attribute9,
3714: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3715: null,
3716: qpil.attribute9
3717: )
3718: ),
3717: )
3718: ),
3719: decode(qpil.automatic_flag, null, qpll.automatic_flag,
3720: decode(qpil.automatic_flag,
3721: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3722: null,
3723: qpil.automatic_flag
3724: )
3725: ),
3724: )
3725: ),
3726: decode(qpil.base_qty, null, qpll.base_qty,
3727: decode(qpil.base_qty,
3728: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3729: null,
3730: qpil.base_qty
3731: )
3732: ),
3731: )
3732: ),
3733: decode(qpil.base_uom_code, null, qpll.base_uom_code,
3734: decode(qpil.base_uom_code,
3735: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3736: null,
3737: qpil.base_uom_code
3738: )
3739: ),
3738: )
3739: ),
3740: decode(qpil.benefit_limit, null, qpll.benefit_limit,
3741: decode(qpil.benefit_limit,
3742: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3743: null,
3744: qpil.benefit_limit
3745: )
3746: ),
3745: )
3746: ),
3747: decode(qpil.benefit_price_list_line_id, null, qpll.benefit_price_list_line_id,
3748: decode(qpil.benefit_price_list_line_id,
3749: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3750: null,
3751: qpil.benefit_price_list_line_id
3752: )
3753: ),
3752: )
3753: ),
3754: decode(qpil.benefit_qty, null, qpll.benefit_qty,
3755: decode(qpil.benefit_qty,
3756: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3757: null,
3758: qpil.benefit_qty
3759: )
3760: ),
3759: )
3760: ),
3761: decode(qpil.benefit_uom_code, null, qpll.benefit_uom_code,
3762: decode(qpil.benefit_uom_code,
3763: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3764: null,
3765: qpil.benefit_uom_code
3766: )
3767: ),
3766: )
3767: ),
3768: decode(qpil.charge_subtype_code, null, qpll.charge_subtype_code,
3769: decode(qpil.charge_subtype_code,
3770: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3771: null,
3772: qpil.charge_subtype_code
3773: )
3774: ),
3773: )
3774: ),
3775: decode(qpil.charge_type_code, null, qpll.charge_type_code,
3776: decode(qpil.charge_type_code,
3777: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3778: null,
3779: qpil.charge_type_code
3780: )
3781: ),
3780: )
3781: ),
3782: decode(qpil.comments, null, qpll.comments,
3783: decode(qpil.comments,
3784: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3785: null,
3786: qpil.comments
3787: )
3788: ),
3787: )
3788: ),
3789: decode(qpil.context, null, qpll.context,
3790: decode(qpil.context,
3791: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3792: null,
3793: qpil.context
3794: )
3795: ),
3794: )
3795: ),
3796: decode(qpil.continuous_price_break_flag, null, qpll.continuous_price_break_flag,
3797: decode(qpil.continuous_price_break_flag,
3798: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3799: null,
3800: qpil.continuous_price_break_flag
3801: )
3802: ),
3801: )
3802: ),
3803: decode(qpil.created_by, null, qpll.created_by,
3804: decode(qpil.created_by,
3805: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3806: null,
3807: qpil.created_by
3808: )
3809: ),
3808: )
3809: ),
3810: decode(qpil.creation_date, null, qpll.creation_date,
3811: decode(qpil.creation_date,
3812: QP_BULK_LOADER_PUB.G_NULL_DATE,
3813: null,
3814: qpil.creation_date
3815: )
3816: ),
3815: )
3816: ),
3817: decode(qpil.effective_period_uom, null, qpll.effective_period_uom,
3818: decode(qpil.effective_period_uom,
3819: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3820: null,
3821: qpil.effective_period_uom
3822: )
3823: ),
3822: )
3823: ),
3824: decode(qpil.end_date_active, null, qpll.end_date_active,
3825: decode(qpil.end_date_active,
3826: QP_BULK_LOADER_PUB.G_NULL_DATE,
3827: null,
3828: qpil.end_date_active
3829: )
3830: ),
3829: )
3830: ),
3831: decode(qpil.estim_accrual_rate, null, qpll.estim_accrual_rate,
3832: decode(qpil.estim_accrual_rate,
3833: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3834: null,
3835: qpil.estim_accrual_rate
3836: )
3837: ),
3836: )
3837: ),
3838: decode(qpil.estim_gl_value, null, qpll.estim_gl_value,
3839: decode(qpil.estim_gl_value,
3840: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3841: null,
3842: qpil.estim_gl_value
3843: )
3844: ),
3843: )
3844: ),
3845: decode(qpil.expiration_date, null, qpll.expiration_date,
3846: decode(qpil.expiration_date,
3847: QP_BULK_LOADER_PUB.G_NULL_DATE,
3848: null,
3849: qpil.expiration_date
3850: )
3851: ),
3850: )
3851: ),
3852: decode(qpil.expiration_period_start_date, null, qpll.expiration_period_start_date,
3853: decode(qpil.expiration_period_start_date,
3854: QP_BULK_LOADER_PUB.G_NULL_DATE,
3855: null,
3856: qpil.expiration_period_start_date
3857: )
3858: ),
3857: )
3858: ),
3859: decode(qpil.expiration_period_uom, null, qpll.expiration_period_uom,
3860: decode(qpil.expiration_period_uom,
3861: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3862: null,
3863: qpil.expiration_period_uom
3864: )
3865: ),
3864: )
3865: ),
3866: decode(qpil.generate_using_formula_id, null, qpll.generate_using_formula_id,
3867: decode(qpil.generate_using_formula_id,
3868: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3869: null,
3870: qpil.generate_using_formula_id
3871: )
3872: ),
3871: )
3872: ),
3873: decode(qpil.include_on_returns_flag, null, qpll.include_on_returns_flag,
3874: decode(qpil.include_on_returns_flag,
3875: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3876: null,
3877: qpil.include_on_returns_flag
3878: )
3879: ),
3878: )
3879: ),
3880: decode(qpil.incompatibility_grp_code, null, qpll.incompatibility_grp_code,
3881: decode(qpil.incompatibility_grp_code,
3882: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3883: null,
3884: qpil.incompatibility_grp_code
3885: )
3886: ),
3885: )
3886: ),
3887: decode(qpil.inventory_item_id, null, qpll.inventory_item_id,
3888: decode(qpil.inventory_item_id,
3889: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3890: null,
3891: qpil.inventory_item_id
3892: )
3893: ),
3892: )
3893: ),
3894: decode(qpil.list_header_id, null, qpll.list_header_id,
3895: decode(qpil.list_header_id,
3896: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3897: null,
3898: qpil.list_header_id
3899: )
3900: ),
3899: )
3900: ),
3901: decode(qpil.list_line_id, null, qpll.list_line_id,
3902: decode(qpil.list_line_id,
3903: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3904: null,
3905: qpil.list_line_id
3906: )
3907: ),
3906: )
3907: ),
3908: decode(qpil.list_line_no, null, qpll.list_line_no,
3909: decode(qpil.list_line_no,
3910: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3911: null,
3912: qpil.list_line_no
3913: )
3914: ),
3913: )
3914: ),
3915: decode(qpil.list_line_type_code, null, qpll.list_line_type_code,
3916: decode(qpil.list_line_type_code,
3917: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3918: null,
3919: qpil.list_line_type_code
3920: )
3921: ),
3920: )
3921: ),
3922: decode(qpil.list_price, null, qpll.list_price,
3923: decode(qpil.list_price,
3924: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3925: null,
3926: qpil.list_price
3927: )
3928: ),
3927: )
3928: ),
3929: decode(qpil.list_price_uom_code, null, qpll.list_price_uom_code,
3930: decode(qpil.list_price_uom_code,
3931: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3932: null,
3933: qpil.list_price_uom_code
3934: )
3935: ),
3934: )
3935: ),
3936: decode(qpil.modifier_level_code, null, qpll.modifier_level_code,
3937: decode(qpil.modifier_level_code,
3938: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3939: null,
3940: qpil.modifier_level_code
3941: )
3942: ),
3941: )
3942: ),
3943: decode(qpil.net_amount_flag, null, qpll.net_amount_flag,
3944: decode(qpil.net_amount_flag,
3945: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3946: null,
3947: qpil.net_amount_flag
3948: )
3949: ),
3948: )
3949: ),
3950: decode(qpil.number_effective_periods, null, qpll.number_effective_periods,
3951: decode(qpil.number_effective_periods,
3952: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3953: null,
3954: qpil.number_effective_periods
3955: )
3956: ),
3955: )
3956: ),
3957: decode(qpil.number_expiration_periods, null, qpll.number_expiration_periods,
3958: decode(qpil.number_expiration_periods,
3959: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3960: null,
3961: qpil.number_expiration_periods
3962: )
3963: ),
3962: )
3963: ),
3964: decode(qpil.operand, null, qpll.operand,
3965: decode(qpil.operand,
3966: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3967: null,
3968: qpil.operand
3969: )
3970: ),
3969: )
3970: ),
3971: decode(qpil.organization_id, null, qpll.organization_id,
3972: decode(qpil.organization_id,
3973: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3974: null,
3975: qpil.organization_id
3976: )
3977: ),
3976: )
3977: ),
3978: decode(qpil.orig_sys_header_ref, null, qpll.orig_sys_header_ref,
3979: decode(qpil.orig_sys_header_ref,
3980: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3981: null,
3982: qpil.orig_sys_header_ref
3983: )
3984: ),
3983: )
3984: ),
3985: decode(qpil.orig_sys_line_ref, null, qpll.orig_sys_line_ref,
3986: decode(qpil.orig_sys_line_ref,
3987: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3988: null,
3989: qpil.orig_sys_line_ref
3990: )
3991: ),
3990: )
3991: ),
3992: decode(qpil.override_flag, null, qpll.override_flag,
3993: decode(qpil.override_flag,
3994: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3995: null,
3996: qpil.override_flag
3997: )
3998: ),
3997: )
3998: ),
3999: decode(qpil.percent_price, null, qpll.percent_price,
4000: decode(qpil.percent_price,
4001: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4002: null,
4003: qpil.percent_price
4004: )
4005: ),
4010: and rm.from_rltd_modifier_id = pll.list_line_id
4011: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
4012: ),
4013: decode(qpil.price_break_header_ref,
4014: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4015: null,
4016: qpil.price_break_header_ref
4017: )
4018: ),
4017: )
4018: ),
4019: decode(qpil.price_break_type_code, null, qpll.price_break_type_code,
4020: decode(qpil.price_break_type_code,
4021: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4022: null,
4023: qpil.price_break_type_code
4024: )
4025: ),
4024: )
4025: ),
4026: decode(qpil.price_by_formula_id, null, qpll.price_by_formula_id,
4027: decode(qpil.price_by_formula_id,
4028: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4029: null,
4030: qpil.price_by_formula_id
4031: )
4032: ),
4031: )
4032: ),
4033: decode(qpil.pricing_group_sequence, null, qpll.pricing_group_sequence,
4034: decode(qpil.pricing_group_sequence,
4035: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4036: null,
4037: qpil.pricing_group_sequence
4038: )
4039: ),
4038: )
4039: ),
4040: decode(qpil.pricing_phase_id, null, qpll.pricing_phase_id,
4041: decode(qpil.pricing_phase_id,
4042: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4043: null,
4044: qpil.pricing_phase_id
4045: )
4046: ),
4045: )
4046: ),
4047: decode(qpil.primary_uom_flag, null, qpll.primary_uom_flag,
4048: decode(qpil.primary_uom_flag,
4049: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4050: null,
4051: qpil.primary_uom_flag
4052: )
4053: ),
4052: )
4053: ),
4054: decode(qpil.print_on_invoice_flag, null, qpll.print_on_invoice_flag,
4055: decode(qpil.print_on_invoice_flag,
4056: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4057: null,
4058: qpil.print_on_invoice_flag
4059: )
4060: ),
4059: )
4060: ),
4061: decode(qpil.product_precedence, null, qpll.product_precedence,
4062: decode(qpil.product_precedence,
4063: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4064: null,
4065: qpil.product_precedence
4066: )
4067: ),
4066: )
4067: ),
4068: decode(qpil.program_application_id, null, qpll.program_application_id,
4069: decode(qpil.program_application_id,
4070: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4071: null,
4072: qpil.program_application_id
4073: )
4074: ),
4073: )
4074: ),
4075: decode(qpil.program_id, null, qpll.program_id,
4076: decode(qpil.program_id,
4077: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4078: null,
4079: qpil.program_id
4080: )
4081: ),
4080: )
4081: ),
4082: decode(qpil.program_update_date, null, qpll.program_update_date,
4083: decode(qpil.program_update_date,
4084: QP_BULK_LOADER_PUB.G_NULL_DATE,
4085: null,
4086: qpil.program_update_date
4087: )
4088: ),
4087: )
4088: ),
4089: decode(qpil.proration_type_code, null, qpll.proration_type_code,
4090: decode(qpil.proration_type_code,
4091: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4092: null,
4093: qpil.proration_type_code
4094: )
4095: ),
4094: )
4095: ),
4096: decode(qpil.qualification_ind, null, qpll.qualification_ind,
4097: decode(qpil.qualification_ind,
4098: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4099: null,
4100: qpil.qualification_ind
4101: )
4102: ),
4101: )
4102: ),
4103: decode(qpil.rebate_transaction_type_code, null, qpll.rebate_transaction_type_code,
4104: decode(qpil.rebate_transaction_type_code,
4105: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4106: null,
4107: qpil.rebate_transaction_type_code
4108: )
4109: ),
4108: )
4109: ),
4110: decode(qpil.recurring_flag, null, qpll.recurring_flag,
4111: decode(qpil.recurring_flag,
4112: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4113: null,
4114: qpil.recurring_flag
4115: )
4116: ),
4115: )
4116: ),
4117: decode(qpil.recurring_value, null, qpll.recurring_value,
4118: decode(qpil.recurring_value,
4119: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4120: null,
4121: qpil.recurring_value
4122: )
4123: ),
4122: )
4123: ),
4124: decode(qpil.related_item_id, null, qpll.related_item_id,
4125: decode(qpil.related_item_id,
4126: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4127: null,
4128: qpil.related_item_id
4129: )
4130: ),
4129: )
4130: ),
4131: decode(qpil.relationship_type_id, null, qpll.relationship_type_id,
4132: decode(qpil.relationship_type_id,
4133: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4134: null,
4135: qpil.relationship_type_id
4136: )
4137: ),
4136: )
4137: ),
4138: decode(qpil.reprice_flag, null, qpll.reprice_flag,
4139: decode(qpil.reprice_flag,
4140: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4141: null,
4142: qpil.reprice_flag
4143: )
4144: ),
4143: )
4144: ),
4145: decode(qpil.revision, null, qpll.revision,
4146: decode(qpil.revision,
4147: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4148: null,
4149: qpil.revision
4150: )
4151: ),
4150: )
4151: ),
4152: decode(qpil.revision_date, null, qpll.revision_date,
4153: decode(qpil.revision_date,
4154: QP_BULK_LOADER_PUB.G_NULL_DATE,
4155: null,
4156: qpil.revision_date
4157: )
4158: ),
4157: )
4158: ),
4159: decode(qpil.revision_reason_code, null, qpll.revision_reason_code,
4160: decode(qpil.revision_reason_code,
4161: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4162: null,
4163: qpil.revision_reason_code
4164: )
4165: ),
4170: and rm.from_rltd_modifier_id = pll.list_line_id
4171: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
4172: ),
4173: decode(qpil.rltd_modifier_grp_type,
4174: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4175: null,
4176: qpil.rltd_modifier_grp_type
4177: )
4178: ),
4177: )
4178: ),
4179: decode(qpil.start_date_active, null, qpll.start_date_active,
4180: decode(qpil.start_date_active,
4181: QP_BULK_LOADER_PUB.G_NULL_DATE,
4182: null,
4183: qpil.start_date_active
4184: )
4185: ),
4184: )
4185: ),
4186: decode(qpil.substitution_attribute, null, qpll.substitution_attribute,
4187: decode(qpil.substitution_attribute,
4188: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4189: null,
4190: qpil.substitution_attribute
4191: )
4192: ),
4191: )
4192: ),
4193: decode(qpil.substitution_context, null, qpll.substitution_context,
4194: decode(qpil.substitution_context,
4195: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4196: null,
4197: qpil.substitution_context
4198: )
4199: ),
4198: )
4199: ),
4200: decode(qpil.substitution_value, null, qpll.substitution_value,
4201: decode(qpil.substitution_value,
4202: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4203: null,
4204: qpil.substitution_value
4205: )
4206: )
4312: program_update_date,
4313: qualification_ind
4314: ) = ( select
4315: decode(qpip.accumulate_flag, null, qppa.accumulate_flag,
4316: decode(qpip.accumulate_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4317: null,qpip.accumulate_flag
4318: )
4319: ),
4320: decode(qpip.attribute_grouping_no, null, qppa.attribute_grouping_no,
4317: null,qpip.accumulate_flag
4318: )
4319: ),
4320: decode(qpip.attribute_grouping_no, null, qppa.attribute_grouping_no,
4321: decode(qpip.attribute_grouping_no,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4322: null,qpip.attribute_grouping_no
4323: )
4324: ),
4325: decode(qpip.attribute1, null, qppa.attribute1,
4322: null,qpip.attribute_grouping_no
4323: )
4324: ),
4325: decode(qpip.attribute1, null, qppa.attribute1,
4326: decode(qpip.attribute1,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4327: null,qpip.attribute1
4328: )
4329: ),
4330: decode(qpip.attribute10, null, qppa.attribute10,
4327: null,qpip.attribute1
4328: )
4329: ),
4330: decode(qpip.attribute10, null, qppa.attribute10,
4331: decode(qpip.attribute10,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4332: null,qpip.attribute10
4333: )
4334: ),
4335: decode(qpip.attribute11, null, qppa.attribute11,
4332: null,qpip.attribute10
4333: )
4334: ),
4335: decode(qpip.attribute11, null, qppa.attribute11,
4336: decode(qpip.attribute11,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4337: null,qpip.attribute11
4338: )
4339: ),
4340: decode(qpip.attribute12, null, qppa.attribute12,
4337: null,qpip.attribute11
4338: )
4339: ),
4340: decode(qpip.attribute12, null, qppa.attribute12,
4341: decode(qpip.attribute12,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4342: null,qpip.attribute12
4343: )
4344: ),
4345: decode(qpip.attribute13, null, qppa.attribute13,
4342: null,qpip.attribute12
4343: )
4344: ),
4345: decode(qpip.attribute13, null, qppa.attribute13,
4346: decode(qpip.attribute13,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4347: null,qpip.attribute13
4348: )
4349: ),
4350: decode(qpip.attribute14, null, qppa.attribute14,
4347: null,qpip.attribute13
4348: )
4349: ),
4350: decode(qpip.attribute14, null, qppa.attribute14,
4351: decode(qpip.attribute14,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4352: null,qpip.attribute14
4353: )
4354: ),
4355: decode(qpip.attribute15, null, qppa.attribute15,
4352: null,qpip.attribute14
4353: )
4354: ),
4355: decode(qpip.attribute15, null, qppa.attribute15,
4356: decode(qpip.attribute15,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4357: null,qpip.attribute15
4358: )
4359: ),
4360: decode(qpip.attribute2, null, qppa.attribute2,
4357: null,qpip.attribute15
4358: )
4359: ),
4360: decode(qpip.attribute2, null, qppa.attribute2,
4361: decode(qpip.attribute2,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4362: null,qpip.attribute2
4363: )
4364: ),
4365: decode(qpip.attribute3, null, qppa.attribute3,
4362: null,qpip.attribute2
4363: )
4364: ),
4365: decode(qpip.attribute3, null, qppa.attribute3,
4366: decode(qpip.attribute3,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4367: null,qpip.attribute3
4368: )
4369: ),
4370: decode(qpip.attribute4, null, qppa.attribute4,
4367: null,qpip.attribute3
4368: )
4369: ),
4370: decode(qpip.attribute4, null, qppa.attribute4,
4371: decode(qpip.attribute4,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4372: null,qpip.attribute4
4373: )
4374: ),
4375: decode(qpip.attribute5, null, qppa.attribute5,
4372: null,qpip.attribute4
4373: )
4374: ),
4375: decode(qpip.attribute5, null, qppa.attribute5,
4376: decode(qpip.attribute5,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4377: null,qpip.attribute5
4378: )
4379: ),
4380: decode(qpip.attribute6, null, qppa.attribute6,
4377: null,qpip.attribute5
4378: )
4379: ),
4380: decode(qpip.attribute6, null, qppa.attribute6,
4381: decode(qpip.attribute6,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4382: null,qpip.attribute6
4383: )
4384: ),
4385: decode(qpip.attribute7, null, qppa.attribute7,
4382: null,qpip.attribute6
4383: )
4384: ),
4385: decode(qpip.attribute7, null, qppa.attribute7,
4386: decode(qpip.attribute7,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4387: null,qpip.attribute7
4388: )
4389: ),
4390: decode(qpip.attribute8, null, qppa.attribute8,
4387: null,qpip.attribute7
4388: )
4389: ),
4390: decode(qpip.attribute8, null, qppa.attribute8,
4391: decode(qpip.attribute8,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4392: null,qpip.attribute8
4393: )
4394: ),
4395: decode(qpip.attribute9, null, qppa.attribute9,
4392: null,qpip.attribute8
4393: )
4394: ),
4395: decode(qpip.attribute9, null, qppa.attribute9,
4396: decode(qpip.attribute9,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4397: null,qpip.attribute9
4398: )
4399: ),
4400: decode(qpip.comparison_operator_code, null, qppa.comparison_operator_code,
4397: null,qpip.attribute9
4398: )
4399: ),
4400: decode(qpip.comparison_operator_code, null, qppa.comparison_operator_code,
4401: decode(qpip.comparison_operator_code,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4402: null,qpip.comparison_operator_code
4403: )
4404: ),
4405: decode(qpip.context, null, qppa.context,
4402: null,qpip.comparison_operator_code
4403: )
4404: ),
4405: decode(qpip.context, null, qppa.context,
4406: decode(qpip.context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4407: null,qpip.context
4408: )
4409: ),
4410: decode(qpip.created_by, null, qppa.created_by,
4407: null,qpip.context
4408: )
4409: ),
4410: decode(qpip.created_by, null, qppa.created_by,
4411: decode(qpip.created_by,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4412: null,qpip.created_by
4413: )
4414: ),
4415: decode(qpip.excluder_flag, null, qppa.excluder_flag,
4412: null,qpip.created_by
4413: )
4414: ),
4415: decode(qpip.excluder_flag, null, qppa.excluder_flag,
4416: decode(qpip.excluder_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4417: null,qpip.excluder_flag
4418: )
4419: ),
4420: decode(qpip.list_header_id, null, qppa.list_header_id,
4417: null,qpip.excluder_flag
4418: )
4419: ),
4420: decode(qpip.list_header_id, null, qppa.list_header_id,
4421: decode(qpip.list_header_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4422: null,qpip.list_header_id
4423: )
4424: ),
4425: decode(qpip.list_line_id, null, qppa.list_line_id,
4422: null,qpip.list_header_id
4423: )
4424: ),
4425: decode(qpip.list_line_id, null, qppa.list_line_id,
4426: decode(qpip.list_line_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4427: null,qpip.list_line_id
4428: )
4429: ),
4430: decode(qpip.orig_sys_header_ref, null, qppa.orig_sys_header_ref,
4427: null,qpip.list_line_id
4428: )
4429: ),
4430: decode(qpip.orig_sys_header_ref, null, qppa.orig_sys_header_ref,
4431: decode(qpip.orig_sys_header_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4432: null,qpip.orig_sys_header_ref
4433: )
4434: ),
4435: decode(qpip.orig_sys_line_ref, null, qppa.orig_sys_line_ref,
4432: null,qpip.orig_sys_header_ref
4433: )
4434: ),
4435: decode(qpip.orig_sys_line_ref, null, qppa.orig_sys_line_ref,
4436: decode(qpip.orig_sys_line_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4437: null,qpip.orig_sys_line_ref
4438: )
4439: ),
4440: decode(qpip.orig_sys_pricing_attr_ref, null, qppa.orig_sys_pricing_attr_ref,
4437: null,qpip.orig_sys_line_ref
4438: )
4439: ),
4440: decode(qpip.orig_sys_pricing_attr_ref, null, qppa.orig_sys_pricing_attr_ref,
4441: decode(qpip.orig_sys_pricing_attr_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4442: null,qpip.orig_sys_pricing_attr_ref
4443: )
4444: ),
4445: decode(qpip.pricing_attr_value_from, null, qppa.pricing_attr_value_from,
4442: null,qpip.orig_sys_pricing_attr_ref
4443: )
4444: ),
4445: decode(qpip.pricing_attr_value_from, null, qppa.pricing_attr_value_from,
4446: decode(qpip.pricing_attr_value_from,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4447: null,qpip.pricing_attr_value_from
4448: )
4449: ),
4450: decode(qpip.pricing_attr_value_from_number, null, qppa.pricing_attr_value_from_number,
4447: null,qpip.pricing_attr_value_from
4448: )
4449: ),
4450: decode(qpip.pricing_attr_value_from_number, null, qppa.pricing_attr_value_from_number,
4451: decode(qpip.pricing_attr_value_from_number,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4452: null,qpip.pricing_attr_value_from_number
4453: )
4454: ),
4455: decode(qpip.pricing_attr_value_to, null, qppa.pricing_attr_value_to,
4452: null,qpip.pricing_attr_value_from_number
4453: )
4454: ),
4455: decode(qpip.pricing_attr_value_to, null, qppa.pricing_attr_value_to,
4456: decode(qpip.pricing_attr_value_to,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4457: null,qpip.pricing_attr_value_to
4458: )
4459: ),
4460: decode(qpip.pricing_attr_value_to_number, null, qppa.pricing_attr_value_to_number,
4457: null,qpip.pricing_attr_value_to
4458: )
4459: ),
4460: decode(qpip.pricing_attr_value_to_number, null, qppa.pricing_attr_value_to_number,
4461: decode(qpip.pricing_attr_value_to_number,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4462: null,qpip.pricing_attr_value_to_number
4463: )
4464: ),
4465: decode(qpip.pricing_attribute, null, qppa.pricing_attribute,
4462: null,qpip.pricing_attr_value_to_number
4463: )
4464: ),
4465: decode(qpip.pricing_attribute, null, qppa.pricing_attribute,
4466: decode(qpip.pricing_attribute,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4467: null,qpip.pricing_attribute
4468: )
4469: ),
4470: decode(qpip.pricing_attribute_context, null, qppa.pricing_attribute_context,
4467: null,qpip.pricing_attribute
4468: )
4469: ),
4470: decode(qpip.pricing_attribute_context, null, qppa.pricing_attribute_context,
4471: decode(qpip.pricing_attribute_context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4472: null,qpip.pricing_attribute_context
4473: )
4474: ),
4475: decode(qpip.pricing_attribute_datatype, null, qppa.pricing_attribute_datatype,
4472: null,qpip.pricing_attribute_context
4473: )
4474: ),
4475: decode(qpip.pricing_attribute_datatype, null, qppa.pricing_attribute_datatype,
4476: decode(qpip.pricing_attribute_datatype,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4477: null,qpip.pricing_attribute_datatype
4478: )
4479: ),
4480: decode(qpip.pricing_attribute_id, null, qppa.pricing_attribute_id,
4477: null,qpip.pricing_attribute_datatype
4478: )
4479: ),
4480: decode(qpip.pricing_attribute_id, null, qppa.pricing_attribute_id,
4481: decode(qpip.pricing_attribute_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4482: null,qpip.pricing_attribute_id
4483: )
4484: ),
4485: decode(qpip.pricing_phase_id, null, qppa.pricing_phase_id,
4482: null,qpip.pricing_attribute_id
4483: )
4484: ),
4485: decode(qpip.pricing_phase_id, null, qppa.pricing_phase_id,
4486: decode(qpip.pricing_phase_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4487: null,qpip.pricing_phase_id
4488: )
4489: ),
4490: decode(qpip.product_attr_value, null, qppa.product_attr_value,
4487: null,qpip.pricing_phase_id
4488: )
4489: ),
4490: decode(qpip.product_attr_value, null, qppa.product_attr_value,
4491: decode(qpip.product_attr_value,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4492: null,qpip.product_attr_value
4493: )
4494: ),
4495: decode(qpip.product_attribute, null, qppa.product_attribute,
4492: null,qpip.product_attr_value
4493: )
4494: ),
4495: decode(qpip.product_attribute, null, qppa.product_attribute,
4496: decode(qpip.product_attribute,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4497: null,qpip.product_attribute
4498: )
4499: ),
4500: decode(qpip.product_attribute_context, null, qppa.product_attribute_context,
4497: null,qpip.product_attribute
4498: )
4499: ),
4500: decode(qpip.product_attribute_context, null, qppa.product_attribute_context,
4501: decode(qpip.product_attribute_context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4502: null,qpip.product_attribute_context
4503: )
4504: ),
4505: decode(qpip.product_attribute_datatype, null, qppa.product_attribute_datatype,
4502: null,qpip.product_attribute_context
4503: )
4504: ),
4505: decode(qpip.product_attribute_datatype, null, qppa.product_attribute_datatype,
4506: decode(qpip.product_attribute_datatype,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4507: null,qpip.product_attribute_datatype
4508: )
4509: ),
4510: decode(qpip.product_uom_code, null, qppa.product_uom_code,
4507: null,qpip.product_attribute_datatype
4508: )
4509: ),
4510: decode(qpip.product_uom_code, null, qppa.product_uom_code,
4511: decode(qpip.product_uom_code,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4512: null,qpip.product_uom_code
4513: )
4514: ),
4515: decode(qpip.program_application_id, null, qppa.program_application_id,
4512: null,qpip.product_uom_code
4513: )
4514: ),
4515: decode(qpip.program_application_id, null, qppa.program_application_id,
4516: decode(qpip.program_application_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4517: null,qpip.program_application_id
4518: )
4519: ),
4520: decode(qpip.program_id, null, qppa.program_id,
4517: null,qpip.program_application_id
4518: )
4519: ),
4520: decode(qpip.program_id, null, qppa.program_id,
4521: decode(qpip.program_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4522: null,qpip.program_id
4523: )
4524: ),
4525: decode(qpip.program_update_date, null, qppa.program_update_date,
4522: null,qpip.program_id
4523: )
4524: ),
4525: decode(qpip.program_update_date, null, qppa.program_update_date,
4526: decode(qpip.program_update_date,QP_BULK_LOADER_PUB.G_NULL_DATE,
4527: null,qpip.program_update_date
4528: )
4529: ),
4530: decode(qpip.qualification_ind, null, qppa.qualification_ind,
4527: null,qpip.program_update_date
4528: )
4529: ),
4530: decode(qpip.qualification_ind, null, qppa.qualification_ind,
4531: decode(qpip.qualification_ind,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4532: null,qpip.qualification_ind
4533: )
4534: )
4535: from qp_pricing_attributes qppa,
6807: from qp_list_lines pl, qp_rltd_modifiers rltd
6808: where rltd.from_rltd_modifier_id = l.list_line_id
6809: and pl.list_line_id = rltd.to_rltd_modifier_id);
6810:
6811: l_list_line_id_tbl QP_BULK_LOADER_PUB.num_type;
6812: l_orig_sys_line_ref_tbl QP_BULK_LOADER_PUB.char50_type;
6813: l_orig_sys_header_ref_tbl QP_BULK_LOADER_PUB.char50_type;
6814: l_msg_txt VARCHAR2(2000);
6815:
6808: where rltd.from_rltd_modifier_id = l.list_line_id
6809: and pl.list_line_id = rltd.to_rltd_modifier_id);
6810:
6811: l_list_line_id_tbl QP_BULK_LOADER_PUB.num_type;
6812: l_orig_sys_line_ref_tbl QP_BULK_LOADER_PUB.char50_type;
6813: l_orig_sys_header_ref_tbl QP_BULK_LOADER_PUB.char50_type;
6814: l_msg_txt VARCHAR2(2000);
6815:
6816: BEGIN
6809: and pl.list_line_id = rltd.to_rltd_modifier_id);
6810:
6811: l_list_line_id_tbl QP_BULK_LOADER_PUB.num_type;
6812: l_orig_sys_line_ref_tbl QP_BULK_LOADER_PUB.char50_type;
6813: l_orig_sys_header_ref_tbl QP_BULK_LOADER_PUB.char50_type;
6814: l_msg_txt VARCHAR2(2000);
6815:
6816: BEGIN
6817:
7202: FND_FILE.PUT_LINE(FND_FILE.LOG, log_text);
7203: END IF;
7204: END;
7205:
7206: END QP_BULK_LOADER_PUB;