[Home] [Help]
1: PACKAGE BODY QP_BULK_LOADER_PUB AS
2: /* $Header: QPXVBLKB.pls 120.39.12020000.2 2012/07/04 12:14:15 smbalara ship $ */
3:
4: FUNCTION GET_NULL_DATE RETURN DATE IS
5: BEGIN
586: global_flag
587: ) = ( select
588: decode(qpih.creation_date, null, qplh.creation_date,
589: decode(qpih.creation_date,
590: QP_BULK_LOADER_PUB.G_NULL_DATE,
591: null,
592: qpih.creation_date
593: )
594: ),
593: )
594: ),
595: decode(qpih.created_by, null, qplh.created_by,
596: decode(qpih.created_by,
597: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
598: null,
599: qpih.created_by
600: )
601: ),
600: )
601: ),
602: decode(qpih.program_application_id, null, qplh.program_application_id,
603: decode(qpih.program_application_id,
604: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
605: null,
606: qpih.program_application_id
607: )
608: ),
607: )
608: ),
609: decode(qpih.program_id, null, qplh.program_id,
610: decode(qpih.program_id,
611: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
612: null,
613: qpih.program_id
614: )
615: ),
614: )
615: ),
616: decode(qpih.program_update_date, null, qplh.program_update_date,
617: decode(qpih.program_update_date,
618: QP_BULK_LOADER_PUB.G_NULL_DATE,
619: null,
620: qpih.program_update_date
621: )
622: ),
621: )
622: ),
623: decode(qpih.list_type_code, null, qplh.list_type_code,
624: decode(qpih.list_type_code,
625: QP_BULK_LOADER_PUB.G_NULL_CHAR,
626: null,
627: qpih.list_type_code
628: )
629: ),
629: ),
630: --Bug# 5228368 RAVI
631: decode(qpih.start_date_active, null, to_char(qplh.start_date_active,'YYYY/MM/DD'),
632: decode(qpih.start_date_active,
633: QP_BULK_LOADER_PUB.G_NULL_CHAR,
634: null,
635: qpih.start_date_active
636: )
637: ),
637: ),
638: --Bug# 5228368 RAVI
639: decode(qpih.end_date_active, null, to_char(qplh.end_date_active,'YYYY/MM/DD'),
640: decode(qpih.end_date_active,
641: QP_BULK_LOADER_PUB.G_NULL_CHAR,
642: null,
643: qpih.end_date_active
644: )
645: ),
644: )
645: ),
646: decode(qpih.source_lang, null, userenv('lang'),
647: decode(qpih.source_lang,
648: QP_BULK_LOADER_PUB.G_NULL_CHAR,
649: null,
650: qpih.source_lang
651: )
652: ),
651: )
652: ),
653: decode(qpih.automatic_flag, null, qplh.automatic_flag,
654: decode(qpih.automatic_flag,
655: QP_BULK_LOADER_PUB.G_NULL_CHAR,
656: null,
657: qpih.automatic_flag
658: )
659: ),
658: )
659: ),
660: decode(qpih.name, null, qplh.name,
661: decode(qpih.name,
662: QP_BULK_LOADER_PUB.G_NULL_CHAR,
663: null,
664: qpih.name
665: )
666: ),
665: )
666: ),
667: decode(qpih.description, null, qplh.description,
668: decode(qpih.description,
669: QP_BULK_LOADER_PUB.G_NULL_CHAR,
670: null,
671: qpih.description
672: )
673: ),
672: )
673: ),
674: decode(qpih.currency_code, null, qplh.currency_code,
675: decode(qpih.currency_code,
676: QP_BULK_LOADER_PUB.G_NULL_CHAR,
677: null,
678: qpih.currency_code
679: )
680: ),
679: )
680: ),
681: decode(qpih.version_no, null, qplh.version_no,
682: decode(qpih.version_no,
683: QP_BULK_LOADER_PUB.G_NULL_CHAR,
684: null,
685: qpih.version_no
686: )
687: ),
686: )
687: ),
688: decode(qpih.rounding_factor, null, qplh.rounding_factor,
689: decode(qpih.rounding_factor,
690: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
691: null,
692: qpih.rounding_factor
693: )
694: ),
706: decode(qpih.ship_method,
707: null,
708: decode(qpih.ship_method_code, null, qplh.ship_method_code,
709: decode(qpih.ship_method_code,
710: QP_BULK_LOADER_PUB.G_NULL_CHAR,
711: null,
712: qpih.ship_method_code
713: )
714: ),
712: qpih.ship_method_code
713: )
714: ),
715: decode(qpih.ship_method_code, null, null,
716: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
717: qpih.ship_method_code
718: )
719: ),
720: decode(qpih.freight_terms,
720: decode(qpih.freight_terms,
721: null,
722: decode(qpih.freight_terms_code, null, qplh.freight_terms_code,
723: decode(qpih.freight_terms_code,
724: QP_BULK_LOADER_PUB.G_NULL_CHAR,
725: null,
726: qpih.freight_terms_code
727: )
728: ),
726: qpih.freight_terms_code
727: )
728: ),
729: decode(qpih.freight_terms_code, null, null,
730: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
731: qpih.freight_terms_code
732: )
733: ),
734: decode(qpih.terms,
734: decode(qpih.terms,
735: null,
736: decode(qpih.terms_id, null, qplh.terms_id,
737: decode(qpih.terms_id,
738: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
739: null,
740: qpih.terms_id
741: )
742: ),
740: qpih.terms_id
741: )
742: ),
743: decode(qpih.terms_id, null, null,
744: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
745: qpih.terms_id
746: )
747: ),
748: --Bug# 5412029 RAVI END
747: ),
748: --Bug# 5412029 RAVI END
749: decode(qpih.comments, null, qplh.comments,
750: decode(qpih.comments,
751: QP_BULK_LOADER_PUB.G_NULL_CHAR,
752: null,
753: qpih.comments
754: )
755: ),
754: )
755: ),
756: decode(qpih.discount_lines_flag, null, qplh.discount_lines_flag,
757: decode(qpih.discount_lines_flag,
758: QP_BULK_LOADER_PUB.G_NULL_CHAR,
759: null,
760: qpih.discount_lines_flag
761: )
762: ),
761: )
762: ),
763: decode(qpih.gsa_indicator, null, qplh.gsa_indicator,
764: decode(qpih.gsa_indicator,
765: QP_BULK_LOADER_PUB.G_NULL_CHAR,
766: null,
767: qpih.gsa_indicator
768: )
769: ),
768: )
769: ),
770: decode(qpih.prorate_flag, null, qplh.prorate_flag,
771: decode(qpih.prorate_flag,
772: QP_BULK_LOADER_PUB.G_NULL_CHAR,
773: null,
774: qpih.prorate_flag
775: )
776: ),
775: )
776: ),
777: decode(qpih.source_system_code, null, qplh.source_system_code,
778: decode(qpih.source_system_code,
779: QP_BULK_LOADER_PUB.G_NULL_CHAR,
780: null,
781: qpih.source_system_code
782: )
783: ),
782: )
783: ),
784: decode(qpih.ask_for_flag, null, qplh.ask_for_flag,
785: decode(qpih.ask_for_flag,
786: QP_BULK_LOADER_PUB.G_NULL_CHAR,
787: null,
788: qpih.ask_for_flag
789: )
790: ),
789: )
790: ),
791: decode(qpih.active_flag, null, qplh.active_flag,
792: decode(qpih.active_flag,
793: QP_BULK_LOADER_PUB.G_NULL_CHAR,
794: null,
795: qpih.active_flag
796: )
797: ),
796: )
797: ),
798: decode(qpih.parent_list_header_id, null, qplh.parent_list_header_id,
799: decode(qpih.parent_list_header_id,
800: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
801: null,
802: qpih.parent_list_header_id
803: )
804: ),
803: )
804: ),
805: decode(qpih.active_date_first_type, null, qplh.active_date_first_type,
806: decode(qpih.active_date_first_type,
807: QP_BULK_LOADER_PUB.G_NULL_CHAR,
808: null,
809: qpih.active_date_first_type
810: )
811: ),
810: )
811: ),
812: decode(qpih.start_date_active_first, null, qplh.start_date_active_first,
813: decode(qpih.start_date_active_first,
814: QP_BULK_LOADER_PUB.G_NULL_DATE,
815: null,
816: qpih.start_date_active_first
817: )
818: ),
817: )
818: ),
819: decode(qpih.end_date_active_first, null, qplh.end_date_active_first,
820: decode(qpih.end_date_active_first,
821: QP_BULK_LOADER_PUB.G_NULL_DATE,
822: null,
823: qpih.end_date_active_first
824: )
825: ),
824: )
825: ),
826: decode(qpih.active_date_second_type, null, qplh.active_date_second_type,
827: decode(qpih.active_date_second_type,
828: QP_BULK_LOADER_PUB.G_NULL_CHAR,
829: null,
830: qpih.active_date_second_type
831: )
832: ),
831: )
832: ),
833: decode(qpih.start_date_active_second, null, qplh.start_date_active_second,
834: decode(qpih.start_date_active_second,
835: QP_BULK_LOADER_PUB.G_NULL_DATE,
836: null,
837: qpih.start_date_active_second
838: )
839: ),
838: )
839: ),
840: decode(qpih.end_date_active_second, null, qplh.end_date_active_second,
841: decode(qpih.end_date_active_second,
842: QP_BULK_LOADER_PUB.G_NULL_DATE,
843: null,
844: qpih.end_date_active_second
845: )
846: ),
845: )
846: ),
847: decode(qpih.context, null, qplh.context,
848: decode(qpih.context,
849: QP_BULK_LOADER_PUB.G_NULL_CHAR,
850: null,
851: qpih.context
852: )
853: ),
852: )
853: ),
854: decode(qpih.attribute1, null, qplh.attribute1,
855: decode(qpih.attribute1,
856: QP_BULK_LOADER_PUB.G_NULL_CHAR,
857: null,
858: qpih.attribute1
859: )
860: ),
859: )
860: ),
861: decode(qpih.attribute2, null, qplh.attribute2,
862: decode(qpih.attribute2,
863: QP_BULK_LOADER_PUB.G_NULL_CHAR,
864: null,
865: qpih.attribute2
866: )
867: ),
866: )
867: ),
868: decode(qpih.attribute3, null, qplh.attribute3,
869: decode(qpih.attribute3,
870: QP_BULK_LOADER_PUB.G_NULL_CHAR,
871: null,
872: qpih.attribute3
873: )
874: ),
873: )
874: ),
875: decode(qpih.attribute4, null, qplh.attribute4,
876: decode(qpih.attribute4,
877: QP_BULK_LOADER_PUB.G_NULL_CHAR,
878: null,
879: qpih.attribute4
880: )
881: ),
880: )
881: ),
882: decode(qpih.attribute5, null, qplh.attribute5,
883: decode(qpih.attribute5,
884: QP_BULK_LOADER_PUB.G_NULL_CHAR,
885: null,
886: qpih.attribute5
887: )
888: ),
887: )
888: ),
889: decode(qpih.attribute6, null, qplh.attribute6,
890: decode(qpih.attribute6,
891: QP_BULK_LOADER_PUB.G_NULL_CHAR,
892: null,
893: qpih.attribute6
894: )
895: ),
894: )
895: ),
896: decode(qpih.attribute7, null, qplh.attribute7,
897: decode(qpih.attribute7,
898: QP_BULK_LOADER_PUB.G_NULL_CHAR,
899: null,
900: qpih.attribute7
901: )
902: ),
901: )
902: ),
903: decode(qpih.attribute8, null, qplh.attribute8,
904: decode(qpih.attribute8,
905: QP_BULK_LOADER_PUB.G_NULL_CHAR,
906: null,
907: qpih.attribute8
908: )
909: ),
908: )
909: ),
910: decode(qpih.attribute9, null, qplh.attribute9,
911: decode(qpih.attribute9,
912: QP_BULK_LOADER_PUB.G_NULL_CHAR,
913: null,
914: qpih.attribute9
915: )
916: ),
915: )
916: ),
917: decode(qpih.attribute10, null, qplh.attribute10,
918: decode(qpih.attribute10,
919: QP_BULK_LOADER_PUB.G_NULL_CHAR,
920: null,
921: qpih.attribute10
922: )
923: ),
922: )
923: ),
924: decode(qpih.attribute11, null, qplh.attribute11,
925: decode(qpih.attribute11,
926: QP_BULK_LOADER_PUB.G_NULL_CHAR,
927: null,
928: qpih.attribute11
929: )
930: ),
929: )
930: ),
931: decode(qpih.attribute12, null, qplh.attribute12,
932: decode(qpih.attribute12,
933: QP_BULK_LOADER_PUB.G_NULL_CHAR,
934: null,
935: qpih.attribute12
936: )
937: ),
936: )
937: ),
938: decode(qpih.attribute13, null, qplh.attribute13,
939: decode(qpih.attribute13,
940: QP_BULK_LOADER_PUB.G_NULL_CHAR,
941: null,
942: qpih.attribute13
943: )
944: ),
943: )
944: ),
945: decode(qpih.attribute14, null, qplh.attribute14,
946: decode(qpih.attribute14,
947: QP_BULK_LOADER_PUB.G_NULL_CHAR,
948: null,
949: qpih.attribute14
950: )
951: ),
950: )
951: ),
952: decode(qpih.attribute15, null, qplh.attribute15,
953: decode(qpih.attribute15,
954: QP_BULK_LOADER_PUB.G_NULL_CHAR,
955: null,
956: qpih.attribute15
957: )
958: ),
957: )
958: ),
959: decode(qpih.language, null, userenv('lang'),
960: decode(qpih.language,
961: QP_BULK_LOADER_PUB.G_NULL_CHAR,
962: null,
963: qpih.language
964: )
965: ),
964: )
965: ),
966: decode(qpih.mobile_download, null, qplh.mobile_download,
967: decode(qpih.mobile_download,
968: QP_BULK_LOADER_PUB.G_NULL_CHAR,
969: null,
970: qpih.mobile_download
971: )
972: ),
984: decode(qpih.currency_header,
985: null,
986: decode(qpih.currency_header_id, null, qplh.currency_header_id,
987: decode(qpih.currency_header_id,
988: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
989: null,
990: qpih.currency_header_id
991: )
992: ),
990: qpih.currency_header_id
991: )
992: ),
993: decode(qpih.currency_header_id, null, null,
994: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
995: qpih.currency_header_id
996: )
997: ),
998: --Bug# 5412029 RAVI END
997: ),
998: --Bug# 5412029 RAVI END
999: decode(qpih.orig_sys_header_ref, null, qplh.orig_system_header_ref,
1000: decode(qpih.orig_sys_header_ref,
1001: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1002: null,
1003: qpih.orig_sys_header_ref
1004: )
1005: ),
1004: )
1005: ),
1006: decode(qpih.orig_org_id, null, qplh.orig_org_id,
1007: decode(qpih.orig_org_id,
1008: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1009: null,
1010: qpih.orig_org_id
1011: )
1012: ),
1011: )
1012: ),
1013: decode(qpih.global_flag, null, qplh.global_flag,
1014: decode(qpih.global_flag,
1015: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1016: null,
1017: qpih.global_flag
1018: )
1019: )
1203: global_flag
1204: ) = ( select
1205: decode(qpih.creation_date, null, qplh.creation_date,
1206: decode(qpih.creation_date,
1207: QP_BULK_LOADER_PUB.G_NULL_DATE,
1208: null,
1209: qpih.creation_date
1210: )
1211: ),
1210: )
1211: ),
1212: decode(qpih.created_by, null, qplh.created_by,
1213: decode(qpih.created_by,
1214: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1215: null,
1216: qpih.created_by
1217: )
1218: ),
1217: )
1218: ),
1219: decode(qpih.program_application_id, null, qplh.program_application_id,
1220: decode(qpih.program_application_id,
1221: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1222: null,
1223: qpih.program_application_id
1224: )
1225: ),
1224: )
1225: ),
1226: decode(qpih.program_id, null, qplh.program_id,
1227: decode(qpih.program_id,
1228: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1229: null,
1230: qpih.program_id
1231: )
1232: ),
1231: )
1232: ),
1233: decode(qpih.program_update_date, null, qplh.program_update_date,
1234: decode(qpih.program_update_date,
1235: QP_BULK_LOADER_PUB.G_NULL_DATE,
1236: null,
1237: qpih.program_update_date
1238: )
1239: ),
1238: )
1239: ),
1240: decode(qpih.list_type_code, null, qplh.list_type_code,
1241: decode(qpih.list_type_code,
1242: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1243: null,
1244: qpih.list_type_code
1245: )
1246: ),
1246: ),
1247: --Bug# 5228368 RAVI
1248: decode(qpih.start_date_active, null, to_char(qplh.start_date_active,'YYYY/MM/DD'),
1249: decode(qpih.start_date_active,
1250: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1251: null,
1252: qpih.start_date_active
1253: )
1254: ),
1254: ),
1255: --Bug# 5228368 RAVI
1256: decode(qpih.end_date_active, null, to_char(qplh.end_date_active,'YYYY/MM/DD'),
1257: decode(qpih.end_date_active,
1258: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1259: null,
1260: qpih.end_date_active
1261: )
1262: ),
1261: )
1262: ),
1263: decode(qpih.source_lang, null, userenv('lang'),
1264: decode(qpih.source_lang,
1265: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1266: null,
1267: qpih.source_lang
1268: )
1269: ),
1268: )
1269: ),
1270: decode(qpih.automatic_flag, null, qplh.automatic_flag,
1271: decode(qpih.automatic_flag,
1272: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1273: null,
1274: qpih.automatic_flag
1275: )
1276: ),
1275: )
1276: ),
1277: decode(qpih.name, null, qplh.name,
1278: decode(qpih.name,
1279: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1280: null,
1281: qpih.name
1282: )
1283: ),
1282: )
1283: ),
1284: decode(qpih.description, null, qplh.description,
1285: decode(qpih.description,
1286: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1287: null,
1288: qpih.description
1289: )
1290: ),
1289: )
1290: ),
1291: decode(qpih.currency_code, null, qplh.currency_code,
1292: decode(qpih.currency_code,
1293: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1294: null,
1295: qpih.currency_code
1296: )
1297: ),
1296: )
1297: ),
1298: decode(qpih.version_no, null, qplh.version_no,
1299: decode(qpih.version_no,
1300: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1301: null,
1302: qpih.version_no
1303: )
1304: ),
1303: )
1304: ),
1305: decode(qpih.rounding_factor, null, qplh.rounding_factor,
1306: decode(qpih.rounding_factor,
1307: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1308: null,
1309: qpih.rounding_factor
1310: )
1311: ),
1323: decode(qpih.ship_method,
1324: null,
1325: decode(qpih.ship_method_code, null, qplh.ship_method_code,
1326: decode(qpih.ship_method_code,
1327: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1328: null,
1329: qpih.ship_method_code
1330: )
1331: ),
1329: qpih.ship_method_code
1330: )
1331: ),
1332: decode(qpih.ship_method_code, null, null,
1333: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
1334: qpih.ship_method_code
1335: )
1336: ),
1337: decode(qpih.freight_terms,
1337: decode(qpih.freight_terms,
1338: null,
1339: decode(qpih.freight_terms_code, null, qplh.freight_terms_code,
1340: decode(qpih.freight_terms_code,
1341: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1342: null,
1343: qpih.freight_terms_code
1344: )
1345: ),
1343: qpih.freight_terms_code
1344: )
1345: ),
1346: decode(qpih.freight_terms_code, null, null,
1347: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
1348: qpih.freight_terms_code
1349: )
1350: ),
1351: decode(qpih.terms,
1351: decode(qpih.terms,
1352: null,
1353: decode(qpih.terms_id, null, qplh.terms_id,
1354: decode(qpih.terms_id,
1355: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1356: null,
1357: qpih.terms_id
1358: )
1359: ),
1357: qpih.terms_id
1358: )
1359: ),
1360: decode(qpih.terms_id, null, null,
1361: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
1362: qpih.terms_id
1363: )
1364: ),
1365: --Bug# 5412029 RAVI END
1364: ),
1365: --Bug# 5412029 RAVI END
1366: decode(qpih.comments, null, qplh.comments,
1367: decode(qpih.comments,
1368: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1369: null,
1370: qpih.comments
1371: )
1372: ),
1371: )
1372: ),
1373: decode(qpih.discount_lines_flag, null, qplh.discount_lines_flag,
1374: decode(qpih.discount_lines_flag,
1375: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1376: null,
1377: qpih.discount_lines_flag
1378: )
1379: ),
1378: )
1379: ),
1380: decode(qpih.gsa_indicator, null, qplh.gsa_indicator,
1381: decode(qpih.gsa_indicator,
1382: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1383: null,
1384: qpih.gsa_indicator
1385: )
1386: ),
1385: )
1386: ),
1387: decode(qpih.prorate_flag, null, qplh.prorate_flag,
1388: decode(qpih.prorate_flag,
1389: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1390: null,
1391: qpih.prorate_flag
1392: )
1393: ),
1392: )
1393: ),
1394: decode(qpih.source_system_code, null, qplh.source_system_code,
1395: decode(qpih.source_system_code,
1396: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1397: null,
1398: qpih.source_system_code
1399: )
1400: ),
1399: )
1400: ),
1401: decode(qpih.ask_for_flag, null, qplh.ask_for_flag,
1402: decode(qpih.ask_for_flag,
1403: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1404: null,
1405: qpih.ask_for_flag
1406: )
1407: ),
1406: )
1407: ),
1408: decode(qpih.active_flag, null, qplh.active_flag,
1409: decode(qpih.active_flag,
1410: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1411: null,
1412: qpih.active_flag
1413: )
1414: ),
1413: )
1414: ),
1415: decode(qpih.parent_list_header_id, null, qplh.parent_list_header_id,
1416: decode(qpih.parent_list_header_id,
1417: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1418: null,
1419: qpih.parent_list_header_id
1420: )
1421: ),
1420: )
1421: ),
1422: decode(qpih.active_date_first_type, null, qplh.active_date_first_type,
1423: decode(qpih.active_date_first_type,
1424: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1425: null,
1426: qpih.active_date_first_type
1427: )
1428: ),
1427: )
1428: ),
1429: decode(qpih.start_date_active_first, null, qplh.start_date_active_first,
1430: decode(qpih.start_date_active_first,
1431: QP_BULK_LOADER_PUB.G_NULL_DATE,
1432: null,
1433: qpih.start_date_active_first
1434: )
1435: ),
1434: )
1435: ),
1436: decode(qpih.end_date_active_first, null, qplh.end_date_active_first,
1437: decode(qpih.end_date_active_first,
1438: QP_BULK_LOADER_PUB.G_NULL_DATE,
1439: null,
1440: qpih.end_date_active_first
1441: )
1442: ),
1441: )
1442: ),
1443: decode(qpih.active_date_second_type, null, qplh.active_date_second_type,
1444: decode(qpih.active_date_second_type,
1445: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1446: null,
1447: qpih.active_date_second_type
1448: )
1449: ),
1448: )
1449: ),
1450: decode(qpih.start_date_active_second, null, qplh.start_date_active_second,
1451: decode(qpih.start_date_active_second,
1452: QP_BULK_LOADER_PUB.G_NULL_DATE,
1453: null,
1454: qpih.start_date_active_second
1455: )
1456: ),
1455: )
1456: ),
1457: decode(qpih.end_date_active_second, null, qplh.end_date_active_second,
1458: decode(qpih.end_date_active_second,
1459: QP_BULK_LOADER_PUB.G_NULL_DATE,
1460: null,
1461: qpih.end_date_active_second
1462: )
1463: ),
1462: )
1463: ),
1464: decode(qpih.context, null, qplh.context,
1465: decode(qpih.context,
1466: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1467: null,
1468: qpih.context
1469: )
1470: ),
1469: )
1470: ),
1471: decode(qpih.attribute1, null, qplh.attribute1,
1472: decode(qpih.attribute1,
1473: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1474: null,
1475: qpih.attribute1
1476: )
1477: ),
1476: )
1477: ),
1478: decode(qpih.attribute2, null, qplh.attribute2,
1479: decode(qpih.attribute2,
1480: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1481: null,
1482: qpih.attribute2
1483: )
1484: ),
1483: )
1484: ),
1485: decode(qpih.attribute3, null, qplh.attribute3,
1486: decode(qpih.attribute3,
1487: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1488: null,
1489: qpih.attribute3
1490: )
1491: ),
1490: )
1491: ),
1492: decode(qpih.attribute4, null, qplh.attribute4,
1493: decode(qpih.attribute4,
1494: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1495: null,
1496: qpih.attribute4
1497: )
1498: ),
1497: )
1498: ),
1499: decode(qpih.attribute5, null, qplh.attribute5,
1500: decode(qpih.attribute5,
1501: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1502: null,
1503: qpih.attribute5
1504: )
1505: ),
1504: )
1505: ),
1506: decode(qpih.attribute6, null, qplh.attribute6,
1507: decode(qpih.attribute6,
1508: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1509: null,
1510: qpih.attribute6
1511: )
1512: ),
1511: )
1512: ),
1513: decode(qpih.attribute7, null, qplh.attribute7,
1514: decode(qpih.attribute7,
1515: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1516: null,
1517: qpih.attribute7
1518: )
1519: ),
1518: )
1519: ),
1520: decode(qpih.attribute8, null, qplh.attribute8,
1521: decode(qpih.attribute8,
1522: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1523: null,
1524: qpih.attribute8
1525: )
1526: ),
1525: )
1526: ),
1527: decode(qpih.attribute9, null, qplh.attribute9,
1528: decode(qpih.attribute9,
1529: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1530: null,
1531: qpih.attribute9
1532: )
1533: ),
1532: )
1533: ),
1534: decode(qpih.attribute10, null, qplh.attribute10,
1535: decode(qpih.attribute10,
1536: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1537: null,
1538: qpih.attribute10
1539: )
1540: ),
1539: )
1540: ),
1541: decode(qpih.attribute11, null, qplh.attribute11,
1542: decode(qpih.attribute11,
1543: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1544: null,
1545: qpih.attribute11
1546: )
1547: ),
1546: )
1547: ),
1548: decode(qpih.attribute12, null, qplh.attribute12,
1549: decode(qpih.attribute12,
1550: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1551: null,
1552: qpih.attribute12
1553: )
1554: ),
1553: )
1554: ),
1555: decode(qpih.attribute13, null, qplh.attribute13,
1556: decode(qpih.attribute13,
1557: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1558: null,
1559: qpih.attribute13
1560: )
1561: ),
1560: )
1561: ),
1562: decode(qpih.attribute14, null, qplh.attribute14,
1563: decode(qpih.attribute14,
1564: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1565: null,
1566: qpih.attribute14
1567: )
1568: ),
1567: )
1568: ),
1569: decode(qpih.attribute15, null, qplh.attribute15,
1570: decode(qpih.attribute15,
1571: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1572: null,
1573: qpih.attribute15
1574: )
1575: ),
1574: )
1575: ),
1576: decode(qpih.language, null, userenv('lang'),
1577: decode(qpih.language,
1578: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1579: null,
1580: qpih.language
1581: )
1582: ),
1581: )
1582: ),
1583: decode(qpih.mobile_download, null, qplh.mobile_download,
1584: decode(qpih.mobile_download,
1585: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1586: null,
1587: qpih.mobile_download
1588: )
1589: ),
1601: decode(qpih.currency_header,
1602: null,
1603: decode(qpih.currency_header_id, null, qplh.currency_header_id,
1604: decode(qpih.currency_header_id,
1605: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1606: null,
1607: qpih.currency_header_id
1608: )
1609: ),
1607: qpih.currency_header_id
1608: )
1609: ),
1610: decode(qpih.currency_header_id, null, null,
1611: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
1612: qpih.currency_header_id
1613: )
1614: ),
1615: --Bug# 5412029 RAVI END
1614: ),
1615: --Bug# 5412029 RAVI END
1616: decode(qpih.orig_sys_header_ref, null, qplh.orig_system_header_ref,
1617: decode(qpih.orig_sys_header_ref,
1618: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1619: null,
1620: qpih.orig_sys_header_ref
1621: )
1622: ),
1621: )
1622: ),
1623: decode(qpih.orig_org_id, null, qplh.orig_org_id,
1624: decode(qpih.orig_org_id,
1625: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1626: null,
1627: qpih.orig_org_id
1628: )
1629: ),
1628: )
1629: ),
1630: decode(qpih.global_flag, null, qplh.global_flag,
1631: decode(qpih.global_flag,
1632: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1633: null,
1634: qpih.global_flag
1635: )
1636: )
1771: --Bug# 5456164 RAVI
1772: qualifier_attr_value_code
1773: ) = ( select
1774: decode(qpiq.active_flag, null, qphq.active_flag,
1775: decode(qpiq.active_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1776: null,qpiq.active_flag
1777: )
1778: ),
1779: decode(qpiq.attribute1, null, qphq.attribute1,
1776: null,qpiq.active_flag
1777: )
1778: ),
1779: decode(qpiq.attribute1, null, qphq.attribute1,
1780: decode(qpiq.attribute1,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1781: null,qpiq.attribute1
1782: )
1783: ),
1784: decode(qpiq.attribute10, null, qphq.attribute10,
1781: null,qpiq.attribute1
1782: )
1783: ),
1784: decode(qpiq.attribute10, null, qphq.attribute10,
1785: decode(qpiq.attribute10,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1786: null,qpiq.attribute10
1787: )
1788: ),
1789: decode(qpiq.attribute11, null, qphq.attribute11,
1786: null,qpiq.attribute10
1787: )
1788: ),
1789: decode(qpiq.attribute11, null, qphq.attribute11,
1790: decode(qpiq.attribute11,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1791: null,qpiq.attribute11
1792: )
1793: ),
1794: decode(qpiq.attribute12, null, qphq.attribute12,
1791: null,qpiq.attribute11
1792: )
1793: ),
1794: decode(qpiq.attribute12, null, qphq.attribute12,
1795: decode(qpiq.attribute12,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1796: null,qpiq.attribute12
1797: )
1798: ),
1799: decode(qpiq.attribute13, null, qphq.attribute13,
1796: null,qpiq.attribute12
1797: )
1798: ),
1799: decode(qpiq.attribute13, null, qphq.attribute13,
1800: decode(qpiq.attribute13,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1801: null,qpiq.attribute13
1802: )
1803: ),
1804: decode(qpiq.attribute14, null, qphq.attribute14,
1801: null,qpiq.attribute13
1802: )
1803: ),
1804: decode(qpiq.attribute14, null, qphq.attribute14,
1805: decode(qpiq.attribute14,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1806: null,qpiq.attribute14
1807: )
1808: ),
1809: decode(qpiq.attribute15, null, qphq.attribute15,
1806: null,qpiq.attribute14
1807: )
1808: ),
1809: decode(qpiq.attribute15, null, qphq.attribute15,
1810: decode(qpiq.attribute15,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1811: null,qpiq.attribute15
1812: )
1813: ),
1814: decode(qpiq.attribute2, null, qphq.attribute2,
1811: null,qpiq.attribute15
1812: )
1813: ),
1814: decode(qpiq.attribute2, null, qphq.attribute2,
1815: decode(qpiq.attribute2,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1816: null,qpiq.attribute2
1817: )
1818: ),
1819: decode(qpiq.attribute3, null, qphq.attribute3,
1816: null,qpiq.attribute2
1817: )
1818: ),
1819: decode(qpiq.attribute3, null, qphq.attribute3,
1820: decode(qpiq.attribute3,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1821: null,qpiq.attribute3
1822: )
1823: ),
1824: decode(qpiq.attribute4, null, qphq.attribute4,
1821: null,qpiq.attribute3
1822: )
1823: ),
1824: decode(qpiq.attribute4, null, qphq.attribute4,
1825: decode(qpiq.attribute4,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1826: null,qpiq.attribute4
1827: )
1828: ),
1829: decode(qpiq.attribute5, null, qphq.attribute5,
1826: null,qpiq.attribute4
1827: )
1828: ),
1829: decode(qpiq.attribute5, null, qphq.attribute5,
1830: decode(qpiq.attribute5,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1831: null,qpiq.attribute5
1832: )
1833: ),
1834: decode(qpiq.attribute6, null, qphq.attribute6,
1831: null,qpiq.attribute5
1832: )
1833: ),
1834: decode(qpiq.attribute6, null, qphq.attribute6,
1835: decode(qpiq.attribute6,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1836: null,qpiq.attribute6
1837: )
1838: ),
1839: decode(qpiq.attribute7, null, qphq.attribute7,
1836: null,qpiq.attribute6
1837: )
1838: ),
1839: decode(qpiq.attribute7, null, qphq.attribute7,
1840: decode(qpiq.attribute7,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1841: null,qpiq.attribute7
1842: )
1843: ),
1844: decode(qpiq.attribute8, null, qphq.attribute8,
1841: null,qpiq.attribute7
1842: )
1843: ),
1844: decode(qpiq.attribute8, null, qphq.attribute8,
1845: decode(qpiq.attribute8,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1846: null,qpiq.attribute8
1847: )
1848: ),
1849: decode(qpiq.attribute9, null, qphq.attribute9,
1846: null,qpiq.attribute8
1847: )
1848: ),
1849: decode(qpiq.attribute9, null, qphq.attribute9,
1850: decode(qpiq.attribute9,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1851: null,qpiq.attribute9
1852: )
1853: ),
1854: decode(qpiq.comparison_operator_code, null, qphq.comparison_operator_code,
1851: null,qpiq.attribute9
1852: )
1853: ),
1854: decode(qpiq.comparison_operator_code, null, qphq.comparison_operator_code,
1855: decode(qpiq.comparison_operator_code,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1856: null,qpiq.comparison_operator_code
1857: )
1858: ),
1859: decode(qpiq.context, null, qphq.context,
1856: null,qpiq.comparison_operator_code
1857: )
1858: ),
1859: decode(qpiq.context, null, qphq.context,
1860: decode(qpiq.context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1861: null,qpiq.context
1862: )
1863: ),
1864: decode(qpiq.created_by, null, qphq.created_by,
1861: null,qpiq.context
1862: )
1863: ),
1864: decode(qpiq.created_by, null, qphq.created_by,
1865: decode(qpiq.created_by,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1866: null,qpiq.created_by
1867: )
1868: ),
1869: --Bug# 5456164 RAVI START
1880: decode(qpiq.created_from_rule,
1881: null,
1882: decode(qpiq.created_from_rule_id, null, qphq.created_from_rule_id,
1883: decode(qpiq.created_from_rule_id,
1884: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1885: null,
1886: qpiq.created_from_rule_id
1887: )
1888: ),
1886: qpiq.created_from_rule_id
1887: )
1888: ),
1889: decode(qpiq.created_from_rule_id, null, null,
1890: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
1891: qpiq.created_from_rule_id
1892: )
1893: ),
1894: --Bug# 5456164 RAVI END
1892: )
1893: ),
1894: --Bug# 5456164 RAVI END
1895: decode(qpiq.creation_date, null, qphq.creation_date,
1896: decode(qpiq.creation_date,QP_BULK_LOADER_PUB.G_NULL_DATE,
1897: null,qpiq.creation_date
1898: )
1899: ),
1900: decode(qpiq.distinct_row_count, null, qphq.distinct_row_count,
1897: null,qpiq.creation_date
1898: )
1899: ),
1900: decode(qpiq.distinct_row_count, null, qphq.distinct_row_count,
1901: decode(qpiq.distinct_row_count,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1902: null,qpiq.distinct_row_count
1903: )
1904: ),
1905: decode(qpiq.end_date_active, null, qphq.end_date_active,
1902: null,qpiq.distinct_row_count
1903: )
1904: ),
1905: decode(qpiq.end_date_active, null, qphq.end_date_active,
1906: decode(qpiq.end_date_active,QP_BULK_LOADER_PUB.G_NULL_DATE,
1907: null,qpiq.end_date_active
1908: )
1909: ),
1910: decode(qpiq.excluder_flag, null, qphq.excluder_flag,
1907: null,qpiq.end_date_active
1908: )
1909: ),
1910: decode(qpiq.excluder_flag, null, qphq.excluder_flag,
1911: decode(qpiq.excluder_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1912: null,qpiq.excluder_flag
1913: )
1914: ),
1915: decode(qpiq.header_quals_exist_flag, null, qphq.header_quals_exist_flag,
1912: null,qpiq.excluder_flag
1913: )
1914: ),
1915: decode(qpiq.header_quals_exist_flag, null, qphq.header_quals_exist_flag,
1916: decode(qpiq.header_quals_exist_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1917: null,qpiq.header_quals_exist_flag
1918: )
1919: ),
1920: decode(qpiq.list_header_id, null, qphq.list_header_id,
1917: null,qpiq.header_quals_exist_flag
1918: )
1919: ),
1920: decode(qpiq.list_header_id, null, qphq.list_header_id,
1921: decode(qpiq.list_header_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1922: null,qpiq.list_header_id
1923: )
1924: ),
1925: decode(qpiq.list_line_id, null, qphq.list_line_id,
1922: null,qpiq.list_header_id
1923: )
1924: ),
1925: decode(qpiq.list_line_id, null, qphq.list_line_id,
1926: decode(qpiq.list_line_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1927: null,qpiq.list_line_id
1928: )
1929: ),
1930: decode(qpiq.list_type_code, null, qphq.list_type_code,
1927: null,qpiq.list_line_id
1928: )
1929: ),
1930: decode(qpiq.list_type_code, null, qphq.list_type_code,
1931: decode(qpiq.list_type_code,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1932: null,qpiq.list_type_code
1933: )
1934: ),
1935: decode(qpiq.orig_sys_header_ref, null, qphq.orig_sys_header_ref,
1932: null,qpiq.list_type_code
1933: )
1934: ),
1935: decode(qpiq.orig_sys_header_ref, null, qphq.orig_sys_header_ref,
1936: decode(qpiq.orig_sys_header_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1937: null,qpiq.orig_sys_header_ref
1938: )
1939: ),
1940: decode(qpiq.orig_sys_line_ref, null, qphq.orig_sys_line_ref,
1937: null,qpiq.orig_sys_header_ref
1938: )
1939: ),
1940: decode(qpiq.orig_sys_line_ref, null, qphq.orig_sys_line_ref,
1941: decode(qpiq.orig_sys_line_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1942: null,qpiq.orig_sys_line_ref
1943: )
1944: ),
1945: decode(qpiq.orig_sys_qualifier_ref, null, qphq.orig_sys_qualifier_ref,
1942: null,qpiq.orig_sys_line_ref
1943: )
1944: ),
1945: decode(qpiq.orig_sys_qualifier_ref, null, qphq.orig_sys_qualifier_ref,
1946: decode(qpiq.orig_sys_qualifier_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
1947: null,qpiq.orig_sys_qualifier_ref
1948: )
1949: ),
1950: decode(qpiq.program_application_id, null, qphq.program_application_id,
1947: null,qpiq.orig_sys_qualifier_ref
1948: )
1949: ),
1950: decode(qpiq.program_application_id, null, qphq.program_application_id,
1951: decode(qpiq.program_application_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1952: null,qpiq.program_application_id
1953: )
1954: ),
1955: decode(qpiq.program_id, null, qphq.program_id,
1952: null,qpiq.program_application_id
1953: )
1954: ),
1955: decode(qpiq.program_id, null, qphq.program_id,
1956: decode(qpiq.program_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1957: null,qpiq.program_id
1958: )
1959: ),
1960: decode(qpiq.program_update_date, null, qphq.program_update_date,
1957: null,qpiq.program_id
1958: )
1959: ),
1960: decode(qpiq.program_update_date, null, qphq.program_update_date,
1961: decode(qpiq.program_update_date,QP_BULK_LOADER_PUB.G_NULL_DATE,
1962: null,qpiq.program_update_date
1963: )
1964: ),
1965: decode(qpiq.qual_attr_value_from_number, null, qphq.qual_attr_value_from_number,
1962: null,qpiq.program_update_date
1963: )
1964: ),
1965: decode(qpiq.qual_attr_value_from_number, null, qphq.qual_attr_value_from_number,
1966: decode(qpiq.qual_attr_value_from_number,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1967: null,qpiq.qual_attr_value_from_number
1968: )
1969: ),
1970: decode(qpiq.qual_attr_value_to_number, null, qphq.qual_attr_value_to_number,
1967: null,qpiq.qual_attr_value_from_number
1968: )
1969: ),
1970: decode(qpiq.qual_attr_value_to_number, null, qphq.qual_attr_value_to_number,
1971: decode(qpiq.qual_attr_value_to_number,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
1972: null,qpiq.qual_attr_value_to_number
1973: )
1974: ),
1975: --Bug# 5456164 RAVI START
1986: decode(qpiq.qualifier_attr_value_code,
1987: null,
1988: decode(qpiq.qualifier_attr_value, null, qphq.qualifier_attr_value,
1989: decode(qpiq.qualifier_attr_value,
1990: QP_BULK_LOADER_PUB.G_NULL_CHAR,
1991: null,
1992: qpiq.qualifier_attr_value
1993: )
1994: ),
1992: qpiq.qualifier_attr_value
1993: )
1994: ),
1995: decode(qpiq.qualifier_attr_value, null, null,
1996: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
1997: qpiq.qualifier_attr_value
1998: )
1999: ),
2000: decode(qpiq.qualifier_attribute_code,
2000: decode(qpiq.qualifier_attribute_code,
2001: null,
2002: decode(qpiq.qualifier_attribute, null, qphq.qualifier_attribute,
2003: decode(qpiq.qualifier_attribute,
2004: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2005: null,
2006: qpiq.qualifier_attribute
2007: )
2008: ),
2006: qpiq.qualifier_attribute
2007: )
2008: ),
2009: decode(qpiq.qualifier_attribute, null, null,
2010: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
2011: qpiq.qualifier_attribute
2012: )
2013: ),
2014: --Bug# 5456164 RAVI END
2012: )
2013: ),
2014: --Bug# 5456164 RAVI END
2015: decode(qpiq.qualifier_context, null, qphq.qualifier_context,
2016: decode(qpiq.qualifier_context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
2017: null,qpiq.qualifier_context
2018: )
2019: ),
2020: decode(qpiq.qualifier_datatype, null, qphq.qualifier_datatype,
2017: null,qpiq.qualifier_context
2018: )
2019: ),
2020: decode(qpiq.qualifier_datatype, null, qphq.qualifier_datatype,
2021: decode(qpiq.qualifier_datatype,QP_BULK_LOADER_PUB.G_NULL_CHAR,
2022: null,qpiq.qualifier_datatype
2023: )
2024: ),
2025: decode(qpiq.qualifier_group_cnt, null, qphq.qualifier_group_cnt,
2022: null,qpiq.qualifier_datatype
2023: )
2024: ),
2025: decode(qpiq.qualifier_group_cnt, null, qphq.qualifier_group_cnt,
2026: decode(qpiq.qualifier_group_cnt,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2027: null,qpiq.qualifier_group_cnt
2028: )
2029: ),
2030: decode(qpiq.qualifier_grouping_no, null, qphq.qualifier_grouping_no,
2027: null,qpiq.qualifier_group_cnt
2028: )
2029: ),
2030: decode(qpiq.qualifier_grouping_no, null, qphq.qualifier_grouping_no,
2031: decode(qpiq.qualifier_grouping_no,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2032: null,qpiq.qualifier_grouping_no
2033: )
2034: ),
2035: decode(qpiq.qualifier_id, null, qphq.qualifier_id,
2032: null,qpiq.qualifier_grouping_no
2033: )
2034: ),
2035: decode(qpiq.qualifier_id, null, qphq.qualifier_id,
2036: decode(qpiq.qualifier_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2037: null,qpiq.qualifier_id
2038: )
2039: ),
2040: decode(qpiq.qualifier_precedence, null, qphq.qualifier_precedence,
2037: null,qpiq.qualifier_id
2038: )
2039: ),
2040: decode(qpiq.qualifier_precedence, null, qphq.qualifier_precedence,
2041: decode(qpiq.qualifier_precedence,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2042: null,qpiq.qualifier_precedence
2043: )
2044: ),
2045: --Bug# 5456164 RAVI START
2056: decode(qpiq.qualifier_rule,
2057: null,
2058: decode(qpiq.qualifier_rule_id, null, qphq.qualifier_rule_id,
2059: decode(qpiq.qualifier_rule_id,
2060: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2061: null,
2062: qpiq.qualifier_rule_id
2063: )
2064: ),
2062: qpiq.qualifier_rule_id
2063: )
2064: ),
2065: decode(qpiq.qualifier_rule_id, null, null,
2066: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
2067: qpiq.qualifier_rule_id
2068: )
2069: ),
2070: --Bug# 5456164 RAVI END
2068: )
2069: ),
2070: --Bug# 5456164 RAVI END
2071: decode(qpiq.qualify_hier_descendents_flag, null, qphq.qualify_hier_descendents_flag,
2072: decode(qpiq.qualify_hier_descendents_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
2073: null,qpiq.qualify_hier_descendents_flag
2074: )
2075: ),
2076: decode(qpiq.search_ind, null, qphq.search_ind,
2073: null,qpiq.qualify_hier_descendents_flag
2074: )
2075: ),
2076: decode(qpiq.search_ind, null, qphq.search_ind,
2077: decode(qpiq.search_ind,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2078: null,qpiq.search_ind
2079: )
2080: ),
2081: decode(qpiq.start_date_active, null, qphq.start_date_active,
2078: null,qpiq.search_ind
2079: )
2080: ),
2081: decode(qpiq.start_date_active, null, qphq.start_date_active,
2082: decode(qpiq.start_date_active,QP_BULK_LOADER_PUB.G_NULL_DATE,
2083: null,qpiq.start_date_active
2084: )
2085: ),
2086: --Bug# 5456164 RAVI
2084: )
2085: ),
2086: --Bug# 5456164 RAVI
2087: decode(qpiq.qualifier_attr_value_code,
2088: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
2089: qpiq.qualifier_attr_value_code
2090: )
2091: from qp_qualifiers qphq,
2092: qp_list_headers_b qplh
2277: substitution_value
2278: ) = ( select
2279: decode(qpil.accrual_conversion_rate, null, qpll.accrual_conversion_rate,
2280: decode(qpil.accrual_conversion_rate,
2281: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2282: null,
2283: qpil.accrual_conversion_rate
2284: )
2285: ),
2284: )
2285: ),
2286: decode(qpil.accrual_flag, null, qpll.accrual_flag,
2287: decode(qpil.accrual_flag,
2288: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2289: null,
2290: qpil.accrual_flag
2291: )
2292: ),
2291: )
2292: ),
2293: decode(qpil.accrual_qty, null, qpll.accrual_qty,
2294: decode(qpil.accrual_qty,
2295: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2296: null,
2297: qpil.accrual_qty
2298: )
2299: ),
2298: )
2299: ),
2300: decode(qpil.accrual_uom_code, null, qpll.accrual_uom_code,
2301: decode(qpil.accrual_uom_code,
2302: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2303: null,
2304: qpil.accrual_uom_code
2305: )
2306: ),
2305: )
2306: ),
2307: decode(qpil.arithmetic_operator, null, qpll.arithmetic_operator,
2308: decode(qpil.arithmetic_operator,
2309: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2310: null,
2311: qpil.arithmetic_operator
2312: )
2313: ),
2312: )
2313: ),
2314: decode(qpil.attribute1, null, qpll.attribute1,
2315: decode(qpil.attribute1,
2316: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2317: null,
2318: qpil.attribute1
2319: )
2320: ),
2319: )
2320: ),
2321: decode(qpil.attribute10, null, qpll.attribute10,
2322: decode(qpil.attribute10,
2323: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2324: null,
2325: qpil.attribute10
2326: )
2327: ),
2326: )
2327: ),
2328: decode(qpil.attribute11, null, qpll.attribute11,
2329: decode(qpil.attribute11,
2330: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2331: null,
2332: qpil.attribute11
2333: )
2334: ),
2333: )
2334: ),
2335: decode(qpil.attribute12, null, qpll.attribute12,
2336: decode(qpil.attribute12,
2337: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2338: null,
2339: qpil.attribute12
2340: )
2341: ),
2340: )
2341: ),
2342: decode(qpil.attribute13, null, qpll.attribute13,
2343: decode(qpil.attribute13,
2344: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2345: null,
2346: qpil.attribute13
2347: )
2348: ),
2347: )
2348: ),
2349: decode(qpil.attribute14, null, qpll.attribute14,
2350: decode(qpil.attribute14,
2351: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2352: null,
2353: qpil.attribute14
2354: )
2355: ),
2354: )
2355: ),
2356: decode(qpil.attribute15, null, qpll.attribute15,
2357: decode(qpil.attribute15,
2358: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2359: null,
2360: qpil.attribute15
2361: )
2362: ),
2361: )
2362: ),
2363: decode(qpil.attribute2, null, qpll.attribute2,
2364: decode(qpil.attribute2,
2365: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2366: null,
2367: qpil.attribute2
2368: )
2369: ),
2368: )
2369: ),
2370: decode(qpil.attribute3, null, qpll.attribute3,
2371: decode(qpil.attribute3,
2372: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2373: null,
2374: qpil.attribute3
2375: )
2376: ),
2375: )
2376: ),
2377: decode(qpil.attribute4, null, qpll.attribute4,
2378: decode(qpil.attribute4,
2379: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2380: null,
2381: qpil.attribute4
2382: )
2383: ),
2382: )
2383: ),
2384: decode(qpil.attribute5, null, qpll.attribute5,
2385: decode(qpil.attribute5,
2386: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2387: null,
2388: qpil.attribute5
2389: )
2390: ),
2389: )
2390: ),
2391: decode(qpil.attribute6, null, qpll.attribute6,
2392: decode(qpil.attribute6,
2393: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2394: null,
2395: qpil.attribute6
2396: )
2397: ),
2396: )
2397: ),
2398: decode(qpil.attribute7, null, qpll.attribute7,
2399: decode(qpil.attribute7,
2400: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2401: null,
2402: qpil.attribute7
2403: )
2404: ),
2403: )
2404: ),
2405: decode(qpil.attribute8, null, qpll.attribute8,
2406: decode(qpil.attribute8,
2407: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2408: null,
2409: qpil.attribute8
2410: )
2411: ),
2410: )
2411: ),
2412: decode(qpil.attribute9, null, qpll.attribute9,
2413: decode(qpil.attribute9,
2414: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2415: null,
2416: qpil.attribute9
2417: )
2418: ),
2417: )
2418: ),
2419: decode(qpil.automatic_flag, null, qpll.automatic_flag,
2420: decode(qpil.automatic_flag,
2421: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2422: null,
2423: qpil.automatic_flag
2424: )
2425: ),
2424: )
2425: ),
2426: decode(qpil.base_qty, null, qpll.base_qty,
2427: decode(qpil.base_qty,
2428: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2429: null,
2430: qpil.base_qty
2431: )
2432: ),
2431: )
2432: ),
2433: decode(qpil.base_uom_code, null, qpll.base_uom_code,
2434: decode(qpil.base_uom_code,
2435: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2436: null,
2437: qpil.base_uom_code
2438: )
2439: ),
2438: )
2439: ),
2440: decode(qpil.benefit_limit, null, qpll.benefit_limit,
2441: decode(qpil.benefit_limit,
2442: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2443: null,
2444: qpil.benefit_limit
2445: )
2446: ),
2445: )
2446: ),
2447: decode(qpil.benefit_price_list_line_id, null, qpll.benefit_price_list_line_id,
2448: decode(qpil.benefit_price_list_line_id,
2449: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2450: null,
2451: qpil.benefit_price_list_line_id
2452: )
2453: ),
2452: )
2453: ),
2454: decode(qpil.benefit_qty, null, qpll.benefit_qty,
2455: decode(qpil.benefit_qty,
2456: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2457: null,
2458: qpil.benefit_qty
2459: )
2460: ),
2459: )
2460: ),
2461: decode(qpil.benefit_uom_code, null, qpll.benefit_uom_code,
2462: decode(qpil.benefit_uom_code,
2463: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2464: null,
2465: qpil.benefit_uom_code
2466: )
2467: ),
2466: )
2467: ),
2468: decode(qpil.charge_subtype_code, null, qpll.charge_subtype_code,
2469: decode(qpil.charge_subtype_code,
2470: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2471: null,
2472: qpil.charge_subtype_code
2473: )
2474: ),
2473: )
2474: ),
2475: decode(qpil.charge_type_code, null, qpll.charge_type_code,
2476: decode(qpil.charge_type_code,
2477: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2478: null,
2479: qpil.charge_type_code
2480: )
2481: ),
2480: )
2481: ),
2482: decode(qpil.comments, null, qpll.comments,
2483: decode(qpil.comments,
2484: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2485: null,
2486: qpil.comments
2487: )
2488: ),
2487: )
2488: ),
2489: decode(qpil.context, null, qpll.context,
2490: decode(qpil.context,
2491: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2492: null,
2493: qpil.context
2494: )
2495: ),
2494: )
2495: ),
2496: decode(qpil.continuous_price_break_flag, null, qpll.continuous_price_break_flag,
2497: decode(qpil.continuous_price_break_flag,
2498: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2499: null,
2500: qpil.continuous_price_break_flag
2501: )
2502: ),
2501: )
2502: ),
2503: decode(qpil.created_by, null, qpll.created_by,
2504: decode(qpil.created_by,
2505: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2506: null,
2507: qpil.created_by
2508: )
2509: ),
2508: )
2509: ),
2510: decode(qpil.creation_date, null, qpll.creation_date,
2511: decode(qpil.creation_date,
2512: QP_BULK_LOADER_PUB.G_NULL_DATE,
2513: null,
2514: qpil.creation_date
2515: )
2516: ),
2515: )
2516: ),
2517: decode(qpil.effective_period_uom, null, qpll.effective_period_uom,
2518: decode(qpil.effective_period_uom,
2519: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2520: null,
2521: qpil.effective_period_uom
2522: )
2523: ),
2522: )
2523: ),
2524: decode(qpil.end_date_active, null, qpll.end_date_active,
2525: decode(qpil.end_date_active,
2526: QP_BULK_LOADER_PUB.G_NULL_DATE,
2527: null,
2528: qpil.end_date_active
2529: )
2530: ),
2529: )
2530: ),
2531: decode(qpil.estim_accrual_rate, null, qpll.estim_accrual_rate,
2532: decode(qpil.estim_accrual_rate,
2533: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2534: null,
2535: qpil.estim_accrual_rate
2536: )
2537: ),
2536: )
2537: ),
2538: decode(qpil.estim_gl_value, null, qpll.estim_gl_value,
2539: decode(qpil.estim_gl_value,
2540: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2541: null,
2542: qpil.estim_gl_value
2543: )
2544: ),
2543: )
2544: ),
2545: decode(qpil.expiration_date, null, qpll.expiration_date,
2546: decode(qpil.expiration_date,
2547: QP_BULK_LOADER_PUB.G_NULL_DATE,
2548: null,
2549: qpil.expiration_date
2550: )
2551: ),
2550: )
2551: ),
2552: decode(qpil.expiration_period_start_date, null, qpll.expiration_period_start_date,
2553: decode(qpil.expiration_period_start_date,
2554: QP_BULK_LOADER_PUB.G_NULL_DATE,
2555: null,
2556: qpil.expiration_period_start_date
2557: )
2558: ),
2557: )
2558: ),
2559: decode(qpil.expiration_period_uom, null, qpll.expiration_period_uom,
2560: decode(qpil.expiration_period_uom,
2561: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2562: null,
2563: qpil.expiration_period_uom
2564: )
2565: ),
2577: decode(qpil.generate_using_formula,
2578: null,
2579: decode(qpil.generate_using_formula_id, null, qpll.generate_using_formula_id,
2580: decode(qpil.generate_using_formula_id,
2581: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2582: null,
2583: qpil.generate_using_formula_id
2584: )
2585: ),
2583: qpil.generate_using_formula_id
2584: )
2585: ),
2586: decode(qpil.generate_using_formula_id, null, null,
2587: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
2588: qpil.generate_using_formula_id
2589: )
2590: ),
2591: --Bug# 5412029 RAVI END
2590: ),
2591: --Bug# 5412029 RAVI END
2592: decode(qpil.include_on_returns_flag, null, qpll.include_on_returns_flag,
2593: decode(qpil.include_on_returns_flag,
2594: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2595: null,
2596: qpil.include_on_returns_flag
2597: )
2598: ),
2597: )
2598: ),
2599: decode(qpil.incompatibility_grp_code, null, qpll.incompatibility_grp_code,
2600: decode(qpil.incompatibility_grp_code,
2601: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2602: null,
2603: qpil.incompatibility_grp_code
2604: )
2605: ),
2604: )
2605: ),
2606: decode(qpil.inventory_item_id, null, qpll.inventory_item_id,
2607: decode(qpil.inventory_item_id,
2608: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2609: null,
2610: qpil.inventory_item_id
2611: )
2612: ),
2611: )
2612: ),
2613: decode(qpil.list_header_id, null, qpll.list_header_id,
2614: decode(qpil.list_header_id,
2615: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2616: null,
2617: qpil.list_header_id
2618: )
2619: ),
2618: )
2619: ),
2620: decode(qpil.list_line_id, null, qpll.list_line_id,
2621: decode(qpil.list_line_id,
2622: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2623: null,
2624: qpil.list_line_id
2625: )
2626: ),
2625: )
2626: ),
2627: decode(qpil.list_line_no, null, qpll.list_line_no,
2628: decode(qpil.list_line_no,
2629: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2630: null,
2631: qpil.list_line_no
2632: )
2633: ),
2632: )
2633: ),
2634: decode(qpil.list_line_type_code, null, qpll.list_line_type_code,
2635: decode(qpil.list_line_type_code,
2636: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2637: null,
2638: qpil.list_line_type_code
2639: )
2640: ),
2639: )
2640: ),
2641: decode(qpil.list_price, null, qpll.list_price,
2642: decode(qpil.list_price,
2643: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2644: null,
2645: qpil.list_price
2646: )
2647: ),
2646: )
2647: ),
2648: decode(qpil.list_price_uom_code, null, qpll.list_price_uom_code,
2649: decode(qpil.list_price_uom_code,
2650: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2651: null,
2652: qpil.list_price_uom_code
2653: )
2654: ),
2653: )
2654: ),
2655: decode(qpil.modifier_level_code, null, qpll.modifier_level_code,
2656: decode(qpil.modifier_level_code,
2657: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2658: null,
2659: qpil.modifier_level_code
2660: )
2661: ),
2660: )
2661: ),
2662: decode(qpil.net_amount_flag, null, qpll.net_amount_flag,
2663: decode(qpil.net_amount_flag,
2664: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2665: null,
2666: qpil.net_amount_flag
2667: )
2668: ),
2667: )
2668: ),
2669: decode(qpil.number_effective_periods, null, qpll.number_effective_periods,
2670: decode(qpil.number_effective_periods,
2671: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2672: null,
2673: qpil.number_effective_periods
2674: )
2675: ),
2674: )
2675: ),
2676: decode(qpil.number_expiration_periods, null, qpll.number_expiration_periods,
2677: decode(qpil.number_expiration_periods,
2678: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2679: null,
2680: qpil.number_expiration_periods
2681: )
2682: ),
2681: )
2682: ),
2683: decode(qpil.operand, null, qpll.operand,
2684: decode(qpil.operand,
2685: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2686: null,
2687: qpil.operand
2688: )
2689: ),
2688: )
2689: ),
2690: decode(qpil.organization_id, null, qpll.organization_id,
2691: decode(qpil.organization_id,
2692: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2693: null,
2694: qpil.organization_id
2695: )
2696: ),
2695: )
2696: ),
2697: decode(qpil.orig_sys_header_ref, null, qpll.orig_sys_header_ref,
2698: decode(qpil.orig_sys_header_ref,
2699: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2700: null,
2701: qpil.orig_sys_header_ref
2702: )
2703: ),
2702: )
2703: ),
2704: decode(qpil.orig_sys_line_ref, null, qpll.orig_sys_line_ref,
2705: decode(qpil.orig_sys_line_ref,
2706: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2707: null,
2708: qpil.orig_sys_line_ref
2709: )
2710: ),
2709: )
2710: ),
2711: decode(qpil.override_flag, null, qpll.override_flag,
2712: decode(qpil.override_flag,
2713: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2714: null,
2715: qpil.override_flag
2716: )
2717: ),
2716: )
2717: ),
2718: decode(qpil.percent_price, null, qpll.percent_price,
2719: decode(qpil.percent_price,
2720: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2721: null,
2722: qpil.percent_price
2723: )
2724: ),
2729: and rm.from_rltd_modifier_id = pll.list_line_id
2730: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
2731: ),
2732: decode(qpil.price_break_header_ref,
2733: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2734: null,
2735: qpil.price_break_header_ref
2736: )
2737: ),
2736: )
2737: ),
2738: decode(qpil.price_break_type_code, null, qpll.price_break_type_code,
2739: decode(qpil.price_break_type_code,
2740: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2741: null,
2742: qpil.price_break_type_code
2743: )
2744: ),
2756: decode(qpil.price_by_formula,
2757: null,
2758: decode(qpil.price_by_formula_id, null, qpll.price_by_formula_id,
2759: decode(qpil.price_by_formula_id,
2760: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2761: null,
2762: qpil.price_by_formula_id
2763: )
2764: ),
2762: qpil.price_by_formula_id
2763: )
2764: ),
2765: decode(qpil.price_by_formula_id, null, null,
2766: QP_BULK_LOADER_PUB.G_NULL_NUMBER,null,
2767: qpil.price_by_formula_id
2768: )
2769: ),
2770: --Bug# 5412029 RAVI END
2769: ),
2770: --Bug# 5412029 RAVI END
2771: decode(qpil.pricing_group_sequence, null, qpll.pricing_group_sequence,
2772: decode(qpil.pricing_group_sequence,
2773: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2774: null,
2775: qpil.pricing_group_sequence
2776: )
2777: ),
2776: )
2777: ),
2778: decode(qpil.pricing_phase_id, null, qpll.pricing_phase_id,
2779: decode(qpil.pricing_phase_id,
2780: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2781: null,
2782: qpil.pricing_phase_id
2783: )
2784: ),
2783: )
2784: ),
2785: decode(qpil.primary_uom_flag, null, qpll.primary_uom_flag,
2786: decode(qpil.primary_uom_flag,
2787: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2788: null,
2789: qpil.primary_uom_flag
2790: )
2791: ),
2790: )
2791: ),
2792: decode(qpil.print_on_invoice_flag, null, qpll.print_on_invoice_flag,
2793: decode(qpil.print_on_invoice_flag,
2794: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2795: null,
2796: qpil.print_on_invoice_flag
2797: )
2798: ),
2797: )
2798: ),
2799: decode(qpil.product_precedence, null, qpll.product_precedence,
2800: decode(qpil.product_precedence,
2801: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2802: null,
2803: qpil.product_precedence
2804: )
2805: ),
2804: )
2805: ),
2806: decode(qpil.program_application_id, null, qpll.program_application_id,
2807: decode(qpil.program_application_id,
2808: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2809: null,
2810: qpil.program_application_id
2811: )
2812: ),
2811: )
2812: ),
2813: decode(qpil.program_id, null, qpll.program_id,
2814: decode(qpil.program_id,
2815: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2816: null,
2817: qpil.program_id
2818: )
2819: ),
2818: )
2819: ),
2820: decode(qpil.program_update_date, null, qpll.program_update_date,
2821: decode(qpil.program_update_date,
2822: QP_BULK_LOADER_PUB.G_NULL_DATE,
2823: null,
2824: qpil.program_update_date
2825: )
2826: ),
2825: )
2826: ),
2827: decode(qpil.proration_type_code, null, qpll.proration_type_code,
2828: decode(qpil.proration_type_code,
2829: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2830: null,
2831: qpil.proration_type_code
2832: )
2833: ),
2832: )
2833: ),
2834: decode(qpil.qualification_ind, null, qpll.qualification_ind,
2835: decode(qpil.qualification_ind,
2836: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2837: null,
2838: qpil.qualification_ind
2839: )
2840: ),
2839: )
2840: ),
2841: decode(qpil.rebate_transaction_type_code, null, qpll.rebate_transaction_type_code,
2842: decode(qpil.rebate_transaction_type_code,
2843: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2844: null,
2845: qpil.rebate_transaction_type_code
2846: )
2847: ),
2846: )
2847: ),
2848: decode(qpil.recurring_flag, null, qpll.recurring_flag,
2849: decode(qpil.recurring_flag,
2850: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2851: null,
2852: qpil.recurring_flag
2853: )
2854: ),
2853: )
2854: ),
2855: decode(qpil.recurring_value, null, qpll.recurring_value,
2856: decode(qpil.recurring_value,
2857: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2858: null,
2859: qpil.recurring_value
2860: )
2861: ),
2860: )
2861: ),
2862: decode(qpil.related_item_id, null, qpll.related_item_id,
2863: decode(qpil.related_item_id,
2864: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2865: null,
2866: qpil.related_item_id
2867: )
2868: ),
2867: )
2868: ),
2869: decode(qpil.relationship_type_id, null, qpll.relationship_type_id,
2870: decode(qpil.relationship_type_id,
2871: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
2872: null,
2873: qpil.relationship_type_id
2874: )
2875: ),
2874: )
2875: ),
2876: decode(qpil.reprice_flag, null, qpll.reprice_flag,
2877: decode(qpil.reprice_flag,
2878: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2879: null,
2880: qpil.reprice_flag
2881: )
2882: ),
2881: )
2882: ),
2883: decode(qpil.revision, null, qpll.revision,
2884: decode(qpil.revision,
2885: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2886: null,
2887: qpil.revision
2888: )
2889: ),
2888: )
2889: ),
2890: decode(qpil.revision_date, null, qpll.revision_date,
2891: decode(qpil.revision_date,
2892: QP_BULK_LOADER_PUB.G_NULL_DATE,
2893: null,
2894: qpil.revision_date
2895: )
2896: ),
2895: )
2896: ),
2897: decode(qpil.revision_reason_code, null, qpll.revision_reason_code,
2898: decode(qpil.revision_reason_code,
2899: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2900: null,
2901: qpil.revision_reason_code
2902: )
2903: ),
2908: and rm.from_rltd_modifier_id = pll.list_line_id
2909: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
2910: ),
2911: decode(qpil.rltd_modifier_grp_type,
2912: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2913: null,
2914: qpil.rltd_modifier_grp_type
2915: )
2916: ),
2915: )
2916: ),
2917: decode(qpil.start_date_active, null, qpll.start_date_active,
2918: decode(qpil.start_date_active,
2919: QP_BULK_LOADER_PUB.G_NULL_DATE,
2920: null,
2921: qpil.start_date_active
2922: )
2923: ),
2922: )
2923: ),
2924: decode(qpil.substitution_attribute, null, qpll.substitution_attribute,
2925: decode(qpil.substitution_attribute,
2926: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2927: null,
2928: qpil.substitution_attribute
2929: )
2930: ),
2929: )
2930: ),
2931: decode(qpil.substitution_context, null, qpll.substitution_context,
2932: decode(qpil.substitution_context,
2933: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2934: null,
2935: qpil.substitution_context
2936: )
2937: ),
2936: )
2937: ),
2938: decode(qpil.substitution_value, null, qpll.substitution_value,
2939: decode(qpil.substitution_value,
2940: QP_BULK_LOADER_PUB.G_NULL_CHAR,
2941: null,
2942: qpil.substitution_value
2943: )
2944: )
3075: pricing_attr_value_to_disp
3076: --Bug#5456164 RAVI START
3077: ) = ( select
3078: decode(qpip.accumulate_flag, null, qppa.accumulate_flag,
3079: decode(qpip.accumulate_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3080: null,qpip.accumulate_flag
3081: )
3082: ),
3083: decode(qpip.attribute_grouping_no, null, qppa.attribute_grouping_no,
3080: null,qpip.accumulate_flag
3081: )
3082: ),
3083: decode(qpip.attribute_grouping_no, null, qppa.attribute_grouping_no,
3084: decode(qpip.attribute_grouping_no,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3085: null,qpip.attribute_grouping_no
3086: )
3087: ),
3088: decode(qpip.attribute1, null, qppa.attribute1,
3085: null,qpip.attribute_grouping_no
3086: )
3087: ),
3088: decode(qpip.attribute1, null, qppa.attribute1,
3089: decode(qpip.attribute1,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3090: null,qpip.attribute1
3091: )
3092: ),
3093: decode(qpip.attribute10, null, qppa.attribute10,
3090: null,qpip.attribute1
3091: )
3092: ),
3093: decode(qpip.attribute10, null, qppa.attribute10,
3094: decode(qpip.attribute10,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3095: null,qpip.attribute10
3096: )
3097: ),
3098: decode(qpip.attribute11, null, qppa.attribute11,
3095: null,qpip.attribute10
3096: )
3097: ),
3098: decode(qpip.attribute11, null, qppa.attribute11,
3099: decode(qpip.attribute11,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3100: null,qpip.attribute11
3101: )
3102: ),
3103: decode(qpip.attribute12, null, qppa.attribute12,
3100: null,qpip.attribute11
3101: )
3102: ),
3103: decode(qpip.attribute12, null, qppa.attribute12,
3104: decode(qpip.attribute12,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3105: null,qpip.attribute12
3106: )
3107: ),
3108: decode(qpip.attribute13, null, qppa.attribute13,
3105: null,qpip.attribute12
3106: )
3107: ),
3108: decode(qpip.attribute13, null, qppa.attribute13,
3109: decode(qpip.attribute13,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3110: null,qpip.attribute13
3111: )
3112: ),
3113: decode(qpip.attribute14, null, qppa.attribute14,
3110: null,qpip.attribute13
3111: )
3112: ),
3113: decode(qpip.attribute14, null, qppa.attribute14,
3114: decode(qpip.attribute14,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3115: null,qpip.attribute14
3116: )
3117: ),
3118: decode(qpip.attribute15, null, qppa.attribute15,
3115: null,qpip.attribute14
3116: )
3117: ),
3118: decode(qpip.attribute15, null, qppa.attribute15,
3119: decode(qpip.attribute15,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3120: null,qpip.attribute15
3121: )
3122: ),
3123: decode(qpip.attribute2, null, qppa.attribute2,
3120: null,qpip.attribute15
3121: )
3122: ),
3123: decode(qpip.attribute2, null, qppa.attribute2,
3124: decode(qpip.attribute2,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3125: null,qpip.attribute2
3126: )
3127: ),
3128: decode(qpip.attribute3, null, qppa.attribute3,
3125: null,qpip.attribute2
3126: )
3127: ),
3128: decode(qpip.attribute3, null, qppa.attribute3,
3129: decode(qpip.attribute3,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3130: null,qpip.attribute3
3131: )
3132: ),
3133: decode(qpip.attribute4, null, qppa.attribute4,
3130: null,qpip.attribute3
3131: )
3132: ),
3133: decode(qpip.attribute4, null, qppa.attribute4,
3134: decode(qpip.attribute4,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3135: null,qpip.attribute4
3136: )
3137: ),
3138: decode(qpip.attribute5, null, qppa.attribute5,
3135: null,qpip.attribute4
3136: )
3137: ),
3138: decode(qpip.attribute5, null, qppa.attribute5,
3139: decode(qpip.attribute5,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3140: null,qpip.attribute5
3141: )
3142: ),
3143: decode(qpip.attribute6, null, qppa.attribute6,
3140: null,qpip.attribute5
3141: )
3142: ),
3143: decode(qpip.attribute6, null, qppa.attribute6,
3144: decode(qpip.attribute6,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3145: null,qpip.attribute6
3146: )
3147: ),
3148: decode(qpip.attribute7, null, qppa.attribute7,
3145: null,qpip.attribute6
3146: )
3147: ),
3148: decode(qpip.attribute7, null, qppa.attribute7,
3149: decode(qpip.attribute7,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3150: null,qpip.attribute7
3151: )
3152: ),
3153: decode(qpip.attribute8, null, qppa.attribute8,
3150: null,qpip.attribute7
3151: )
3152: ),
3153: decode(qpip.attribute8, null, qppa.attribute8,
3154: decode(qpip.attribute8,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3155: null,qpip.attribute8
3156: )
3157: ),
3158: decode(qpip.attribute9, null, qppa.attribute9,
3155: null,qpip.attribute8
3156: )
3157: ),
3158: decode(qpip.attribute9, null, qppa.attribute9,
3159: decode(qpip.attribute9,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3160: null,qpip.attribute9
3161: )
3162: ),
3163: decode(qpip.comparison_operator_code, null, qppa.comparison_operator_code,
3160: null,qpip.attribute9
3161: )
3162: ),
3163: decode(qpip.comparison_operator_code, null, qppa.comparison_operator_code,
3164: decode(qpip.comparison_operator_code,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3165: null,qpip.comparison_operator_code
3166: )
3167: ),
3168: decode(qpip.context, null, qppa.context,
3165: null,qpip.comparison_operator_code
3166: )
3167: ),
3168: decode(qpip.context, null, qppa.context,
3169: decode(qpip.context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3170: null,qpip.context
3171: )
3172: ),
3173: decode(qpip.created_by, null, qppa.created_by,
3170: null,qpip.context
3171: )
3172: ),
3173: decode(qpip.created_by, null, qppa.created_by,
3174: decode(qpip.created_by,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3175: null,qpip.created_by
3176: )
3177: ),
3178: decode(qpip.excluder_flag, null, qppa.excluder_flag,
3175: null,qpip.created_by
3176: )
3177: ),
3178: decode(qpip.excluder_flag, null, qppa.excluder_flag,
3179: decode(qpip.excluder_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3180: null,qpip.excluder_flag
3181: )
3182: ),
3183: decode(qpip.list_header_id, null, qppa.list_header_id,
3180: null,qpip.excluder_flag
3181: )
3182: ),
3183: decode(qpip.list_header_id, null, qppa.list_header_id,
3184: decode(qpip.list_header_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3185: null,qpip.list_header_id
3186: )
3187: ),
3188: decode(qpip.list_line_id, null, qppa.list_line_id,
3185: null,qpip.list_header_id
3186: )
3187: ),
3188: decode(qpip.list_line_id, null, qppa.list_line_id,
3189: decode(qpip.list_line_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3190: null,qpip.list_line_id
3191: )
3192: ),
3193: decode(qpip.orig_sys_header_ref, null, qppa.orig_sys_header_ref,
3190: null,qpip.list_line_id
3191: )
3192: ),
3193: decode(qpip.orig_sys_header_ref, null, qppa.orig_sys_header_ref,
3194: decode(qpip.orig_sys_header_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3195: null,qpip.orig_sys_header_ref
3196: )
3197: ),
3198: decode(qpip.orig_sys_line_ref, null, qppa.orig_sys_line_ref,
3195: null,qpip.orig_sys_header_ref
3196: )
3197: ),
3198: decode(qpip.orig_sys_line_ref, null, qppa.orig_sys_line_ref,
3199: decode(qpip.orig_sys_line_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3200: null,qpip.orig_sys_line_ref
3201: )
3202: ),
3203: decode(qpip.orig_sys_pricing_attr_ref, null, qppa.orig_sys_pricing_attr_ref,
3200: null,qpip.orig_sys_line_ref
3201: )
3202: ),
3203: decode(qpip.orig_sys_pricing_attr_ref, null, qppa.orig_sys_pricing_attr_ref,
3204: decode(qpip.orig_sys_pricing_attr_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3205: null,qpip.orig_sys_pricing_attr_ref
3206: )
3207: ),
3208: --Bug# 5456164 RAVI START
3219: decode(qpip.pricing_attr_value_from_disp,
3220: null,
3221: decode(qpip.pricing_attr_value_from, null, qppa.pricing_attr_value_from,
3222: decode(qpip.pricing_attr_value_from,
3223: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3224: null,
3225: qpip.pricing_attr_value_from
3226: )
3227: ),
3225: qpip.pricing_attr_value_from
3226: )
3227: ),
3228: decode(qpip.pricing_attr_value_from, null, null,
3229: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
3230: qpip.pricing_attr_value_from
3231: )
3232: ),
3233: --Bug# 5456164 RAVI END
3231: )
3232: ),
3233: --Bug# 5456164 RAVI END
3234: decode(qpip.pricing_attr_value_from_number, null, qppa.pricing_attr_value_from_number,
3235: decode(qpip.pricing_attr_value_from_number,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3236: null,qpip.pricing_attr_value_from_number
3237: )
3238: ),
3239: --Bug# 5456164 RAVI START
3250: decode(qpip.pricing_attr_value_to_disp,
3251: null,
3252: decode(qpip.pricing_attr_value_to, null, qppa.pricing_attr_value_to,
3253: decode(qpip.pricing_attr_value_to,
3254: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3255: null,
3256: qpip.pricing_attr_value_to
3257: )
3258: ),
3256: qpip.pricing_attr_value_to
3257: )
3258: ),
3259: decode(qpip.pricing_attr_value_to, null, null,
3260: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
3261: qpip.pricing_attr_value_to
3262: )
3263: ),
3264: --Bug# 5456164 RAVI END
3262: )
3263: ),
3264: --Bug# 5456164 RAVI END
3265: decode(qpip.pricing_attr_value_to_number, null, qppa.pricing_attr_value_to_number,
3266: decode(qpip.pricing_attr_value_to_number,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3267: null,qpip.pricing_attr_value_to_number
3268: )
3269: ),
3270: --Bug# 5456164 RAVI START
3281: decode(qpip.pricing_attr_code,
3282: null,
3283: decode(qpip.pricing_attribute, null, qppa.pricing_attribute,
3284: decode(qpip.pricing_attribute,
3285: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3286: null,
3287: qpip.pricing_attribute
3288: )
3289: ),
3287: qpip.pricing_attribute
3288: )
3289: ),
3290: decode(qpip.pricing_attribute, null, null,
3291: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
3292: qpip.pricing_attribute
3293: )
3294: ),
3295: --Bug# 5456164 RAVI END
3293: )
3294: ),
3295: --Bug# 5456164 RAVI END
3296: decode(qpip.pricing_attribute_context, null, qppa.pricing_attribute_context,
3297: decode(qpip.pricing_attribute_context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3298: null,qpip.pricing_attribute_context
3299: )
3300: ),
3301: decode(qpip.pricing_attribute_datatype, null, qppa.pricing_attribute_datatype,
3298: null,qpip.pricing_attribute_context
3299: )
3300: ),
3301: decode(qpip.pricing_attribute_datatype, null, qppa.pricing_attribute_datatype,
3302: decode(qpip.pricing_attribute_datatype,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3303: null,qpip.pricing_attribute_datatype
3304: )
3305: ),
3306: decode(qpip.pricing_attribute_id, null, qppa.pricing_attribute_id,
3303: null,qpip.pricing_attribute_datatype
3304: )
3305: ),
3306: decode(qpip.pricing_attribute_id, null, qppa.pricing_attribute_id,
3307: decode(qpip.pricing_attribute_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3308: null,qpip.pricing_attribute_id
3309: )
3310: ),
3311: decode(qpip.pricing_phase_id, null, qppa.pricing_phase_id,
3308: null,qpip.pricing_attribute_id
3309: )
3310: ),
3311: decode(qpip.pricing_phase_id, null, qppa.pricing_phase_id,
3312: decode(qpip.pricing_phase_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3313: null,qpip.pricing_phase_id
3314: )
3315: ),
3316: --Bug# 5456164 RAVI START
3327: decode(qpip.product_attr_val_disp,
3328: null,
3329: decode(qpip.product_attr_value, null, qppa.product_attr_value,
3330: decode(qpip.product_attr_value,
3331: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3332: null,
3333: qpip.product_attr_value
3334: )
3335: ),
3333: qpip.product_attr_value
3334: )
3335: ),
3336: decode(qpip.product_attr_value, null, null,
3337: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
3338: qpip.product_attr_value
3339: )
3340: ),
3341: decode(qpip.product_attr_code,
3341: decode(qpip.product_attr_code,
3342: null,
3343: decode(qpip.product_attribute, null, qppa.product_attribute,
3344: decode(qpip.product_attribute,
3345: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3346: null,
3347: qpip.product_attribute
3348: )
3349: ),
3347: qpip.product_attribute
3348: )
3349: ),
3350: decode(qpip.product_attribute, null, null,
3351: QP_BULK_LOADER_PUB.G_NULL_CHAR,null,
3352: qpip.product_attribute
3353: )
3354: ),
3355: --Bug# 5456164 RAVI END
3353: )
3354: ),
3355: --Bug# 5456164 RAVI END
3356: decode(qpip.product_attribute_context, null, qppa.product_attribute_context,
3357: decode(qpip.product_attribute_context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3358: null,qpip.product_attribute_context
3359: )
3360: ),
3361: decode(qpip.product_attribute_datatype, null, qppa.product_attribute_datatype,
3358: null,qpip.product_attribute_context
3359: )
3360: ),
3361: decode(qpip.product_attribute_datatype, null, qppa.product_attribute_datatype,
3362: decode(qpip.product_attribute_datatype,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3363: null,qpip.product_attribute_datatype
3364: )
3365: ),
3366: decode(qpip.product_uom_code, null, qppa.product_uom_code,
3363: null,qpip.product_attribute_datatype
3364: )
3365: ),
3366: decode(qpip.product_uom_code, null, qppa.product_uom_code,
3367: decode(qpip.product_uom_code,QP_BULK_LOADER_PUB.G_NULL_CHAR,
3368: null,qpip.product_uom_code
3369: )
3370: ),
3371: decode(qpip.program_application_id, null, qppa.program_application_id,
3368: null,qpip.product_uom_code
3369: )
3370: ),
3371: decode(qpip.program_application_id, null, qppa.program_application_id,
3372: decode(qpip.program_application_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3373: null,qpip.program_application_id
3374: )
3375: ),
3376: decode(qpip.program_id, null, qppa.program_id,
3373: null,qpip.program_application_id
3374: )
3375: ),
3376: decode(qpip.program_id, null, qppa.program_id,
3377: decode(qpip.program_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3378: null,qpip.program_id
3379: )
3380: ),
3381: decode(qpip.program_update_date, null, qppa.program_update_date,
3378: null,qpip.program_id
3379: )
3380: ),
3381: decode(qpip.program_update_date, null, qppa.program_update_date,
3382: decode(qpip.program_update_date,QP_BULK_LOADER_PUB.G_NULL_DATE,
3383: null,qpip.program_update_date
3384: )
3385: ),
3386: decode(qpip.qualification_ind, null, qppa.qualification_ind,
3383: null,qpip.program_update_date
3384: )
3385: ),
3386: decode(qpip.qualification_ind, null, qppa.qualification_ind,
3387: decode(qpip.qualification_ind,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3388: null,qpip.qualification_ind
3389: )
3390: ),
3391: --Bug# 5456164 RAVI START
3390: ),
3391: --Bug# 5456164 RAVI START
3392: --If ID in ID_to_VAL is G_CHAR then set it null
3393: decode(qpip.product_attr_val_disp,
3394: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3395: qpip.product_attr_val_disp
3396: ),
3397: decode(qpip.pricing_attr_value_from_disp,
3398: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3394: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3395: qpip.product_attr_val_disp
3396: ),
3397: decode(qpip.pricing_attr_value_from_disp,
3398: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3399: qpip.pricing_attr_value_from_disp
3400: ),
3401: decode(qpip.pricing_attr_value_to_disp,
3402: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3398: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3399: qpip.pricing_attr_value_from_disp
3400: ),
3401: decode(qpip.pricing_attr_value_to_disp,
3402: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3403: qpip.pricing_attr_value_to_disp
3404: )
3405: --Bug# 5456164 RAVI END
3406: from qp_pricing_attributes qppa,
3696: substitution_value
3697: ) = ( select
3698: decode(qpil.accrual_conversion_rate, null, qpll.accrual_conversion_rate,
3699: decode(qpil.accrual_conversion_rate,
3700: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3701: null,
3702: qpil.accrual_conversion_rate
3703: )
3704: ),
3703: )
3704: ),
3705: decode(qpil.accrual_flag, null, qpll.accrual_flag,
3706: decode(qpil.accrual_flag,
3707: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3708: null,
3709: qpil.accrual_flag
3710: )
3711: ),
3710: )
3711: ),
3712: decode(qpil.accrual_qty, null, qpll.accrual_qty,
3713: decode(qpil.accrual_qty,
3714: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3715: null,
3716: qpil.accrual_qty
3717: )
3718: ),
3717: )
3718: ),
3719: decode(qpil.accrual_uom_code, null, qpll.accrual_uom_code,
3720: decode(qpil.accrual_uom_code,
3721: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3722: null,
3723: qpil.accrual_uom_code
3724: )
3725: ),
3724: )
3725: ),
3726: decode(qpil.arithmetic_operator, null, qpll.arithmetic_operator,
3727: decode(qpil.arithmetic_operator,
3728: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3729: null,
3730: qpil.arithmetic_operator
3731: )
3732: ),
3731: )
3732: ),
3733: decode(qpil.attribute1, null, qpll.attribute1,
3734: decode(qpil.attribute1,
3735: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3736: null,
3737: qpil.attribute1
3738: )
3739: ),
3738: )
3739: ),
3740: decode(qpil.attribute10, null, qpll.attribute10,
3741: decode(qpil.attribute10,
3742: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3743: null,
3744: qpil.attribute10
3745: )
3746: ),
3745: )
3746: ),
3747: decode(qpil.attribute11, null, qpll.attribute11,
3748: decode(qpil.attribute11,
3749: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3750: null,
3751: qpil.attribute11
3752: )
3753: ),
3752: )
3753: ),
3754: decode(qpil.attribute12, null, qpll.attribute12,
3755: decode(qpil.attribute12,
3756: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3757: null,
3758: qpil.attribute12
3759: )
3760: ),
3759: )
3760: ),
3761: decode(qpil.attribute13, null, qpll.attribute13,
3762: decode(qpil.attribute13,
3763: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3764: null,
3765: qpil.attribute13
3766: )
3767: ),
3766: )
3767: ),
3768: decode(qpil.attribute14, null, qpll.attribute14,
3769: decode(qpil.attribute14,
3770: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3771: null,
3772: qpil.attribute14
3773: )
3774: ),
3773: )
3774: ),
3775: decode(qpil.attribute15, null, qpll.attribute15,
3776: decode(qpil.attribute15,
3777: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3778: null,
3779: qpil.attribute15
3780: )
3781: ),
3780: )
3781: ),
3782: decode(qpil.attribute2, null, qpll.attribute2,
3783: decode(qpil.attribute2,
3784: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3785: null,
3786: qpil.attribute2
3787: )
3788: ),
3787: )
3788: ),
3789: decode(qpil.attribute3, null, qpll.attribute3,
3790: decode(qpil.attribute3,
3791: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3792: null,
3793: qpil.attribute3
3794: )
3795: ),
3794: )
3795: ),
3796: decode(qpil.attribute4, null, qpll.attribute4,
3797: decode(qpil.attribute4,
3798: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3799: null,
3800: qpil.attribute4
3801: )
3802: ),
3801: )
3802: ),
3803: decode(qpil.attribute5, null, qpll.attribute5,
3804: decode(qpil.attribute5,
3805: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3806: null,
3807: qpil.attribute5
3808: )
3809: ),
3808: )
3809: ),
3810: decode(qpil.attribute6, null, qpll.attribute6,
3811: decode(qpil.attribute6,
3812: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3813: null,
3814: qpil.attribute6
3815: )
3816: ),
3815: )
3816: ),
3817: decode(qpil.attribute7, null, qpll.attribute7,
3818: decode(qpil.attribute7,
3819: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3820: null,
3821: qpil.attribute7
3822: )
3823: ),
3822: )
3823: ),
3824: decode(qpil.attribute8, null, qpll.attribute8,
3825: decode(qpil.attribute8,
3826: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3827: null,
3828: qpil.attribute8
3829: )
3830: ),
3829: )
3830: ),
3831: decode(qpil.attribute9, null, qpll.attribute9,
3832: decode(qpil.attribute9,
3833: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3834: null,
3835: qpil.attribute9
3836: )
3837: ),
3836: )
3837: ),
3838: decode(qpil.automatic_flag, null, qpll.automatic_flag,
3839: decode(qpil.automatic_flag,
3840: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3841: null,
3842: qpil.automatic_flag
3843: )
3844: ),
3843: )
3844: ),
3845: decode(qpil.base_qty, null, qpll.base_qty,
3846: decode(qpil.base_qty,
3847: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3848: null,
3849: qpil.base_qty
3850: )
3851: ),
3850: )
3851: ),
3852: decode(qpil.base_uom_code, null, qpll.base_uom_code,
3853: decode(qpil.base_uom_code,
3854: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3855: null,
3856: qpil.base_uom_code
3857: )
3858: ),
3857: )
3858: ),
3859: decode(qpil.benefit_limit, null, qpll.benefit_limit,
3860: decode(qpil.benefit_limit,
3861: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3862: null,
3863: qpil.benefit_limit
3864: )
3865: ),
3864: )
3865: ),
3866: decode(qpil.benefit_price_list_line_id, null, qpll.benefit_price_list_line_id,
3867: decode(qpil.benefit_price_list_line_id,
3868: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3869: null,
3870: qpil.benefit_price_list_line_id
3871: )
3872: ),
3871: )
3872: ),
3873: decode(qpil.benefit_qty, null, qpll.benefit_qty,
3874: decode(qpil.benefit_qty,
3875: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3876: null,
3877: qpil.benefit_qty
3878: )
3879: ),
3878: )
3879: ),
3880: decode(qpil.benefit_uom_code, null, qpll.benefit_uom_code,
3881: decode(qpil.benefit_uom_code,
3882: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3883: null,
3884: qpil.benefit_uom_code
3885: )
3886: ),
3885: )
3886: ),
3887: decode(qpil.charge_subtype_code, null, qpll.charge_subtype_code,
3888: decode(qpil.charge_subtype_code,
3889: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3890: null,
3891: qpil.charge_subtype_code
3892: )
3893: ),
3892: )
3893: ),
3894: decode(qpil.charge_type_code, null, qpll.charge_type_code,
3895: decode(qpil.charge_type_code,
3896: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3897: null,
3898: qpil.charge_type_code
3899: )
3900: ),
3899: )
3900: ),
3901: decode(qpil.comments, null, qpll.comments,
3902: decode(qpil.comments,
3903: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3904: null,
3905: qpil.comments
3906: )
3907: ),
3906: )
3907: ),
3908: decode(qpil.context, null, qpll.context,
3909: decode(qpil.context,
3910: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3911: null,
3912: qpil.context
3913: )
3914: ),
3913: )
3914: ),
3915: decode(qpil.continuous_price_break_flag, null, qpll.continuous_price_break_flag,
3916: decode(qpil.continuous_price_break_flag,
3917: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3918: null,
3919: qpil.continuous_price_break_flag
3920: )
3921: ),
3920: )
3921: ),
3922: decode(qpil.created_by, null, qpll.created_by,
3923: decode(qpil.created_by,
3924: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3925: null,
3926: qpil.created_by
3927: )
3928: ),
3927: )
3928: ),
3929: decode(qpil.creation_date, null, qpll.creation_date,
3930: decode(qpil.creation_date,
3931: QP_BULK_LOADER_PUB.G_NULL_DATE,
3932: null,
3933: qpil.creation_date
3934: )
3935: ),
3934: )
3935: ),
3936: decode(qpil.effective_period_uom, null, qpll.effective_period_uom,
3937: decode(qpil.effective_period_uom,
3938: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3939: null,
3940: qpil.effective_period_uom
3941: )
3942: ),
3941: )
3942: ),
3943: decode(qpil.end_date_active, null, qpll.end_date_active,
3944: decode(qpil.end_date_active,
3945: QP_BULK_LOADER_PUB.G_NULL_DATE,
3946: null,
3947: qpil.end_date_active
3948: )
3949: ),
3948: )
3949: ),
3950: decode(qpil.estim_accrual_rate, null, qpll.estim_accrual_rate,
3951: decode(qpil.estim_accrual_rate,
3952: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3953: null,
3954: qpil.estim_accrual_rate
3955: )
3956: ),
3955: )
3956: ),
3957: decode(qpil.estim_gl_value, null, qpll.estim_gl_value,
3958: decode(qpil.estim_gl_value,
3959: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3960: null,
3961: qpil.estim_gl_value
3962: )
3963: ),
3962: )
3963: ),
3964: decode(qpil.expiration_date, null, qpll.expiration_date,
3965: decode(qpil.expiration_date,
3966: QP_BULK_LOADER_PUB.G_NULL_DATE,
3967: null,
3968: qpil.expiration_date
3969: )
3970: ),
3969: )
3970: ),
3971: decode(qpil.expiration_period_start_date, null, qpll.expiration_period_start_date,
3972: decode(qpil.expiration_period_start_date,
3973: QP_BULK_LOADER_PUB.G_NULL_DATE,
3974: null,
3975: qpil.expiration_period_start_date
3976: )
3977: ),
3976: )
3977: ),
3978: decode(qpil.expiration_period_uom, null, qpll.expiration_period_uom,
3979: decode(qpil.expiration_period_uom,
3980: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3981: null,
3982: qpil.expiration_period_uom
3983: )
3984: ),
3983: )
3984: ),
3985: decode(qpil.generate_using_formula_id, null, qpll.generate_using_formula_id,
3986: decode(qpil.generate_using_formula_id,
3987: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
3988: null,
3989: qpil.generate_using_formula_id
3990: )
3991: ),
3990: )
3991: ),
3992: decode(qpil.include_on_returns_flag, null, qpll.include_on_returns_flag,
3993: decode(qpil.include_on_returns_flag,
3994: QP_BULK_LOADER_PUB.G_NULL_CHAR,
3995: null,
3996: qpil.include_on_returns_flag
3997: )
3998: ),
3997: )
3998: ),
3999: decode(qpil.incompatibility_grp_code, null, qpll.incompatibility_grp_code,
4000: decode(qpil.incompatibility_grp_code,
4001: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4002: null,
4003: qpil.incompatibility_grp_code
4004: )
4005: ),
4004: )
4005: ),
4006: decode(qpil.inventory_item_id, null, qpll.inventory_item_id,
4007: decode(qpil.inventory_item_id,
4008: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4009: null,
4010: qpil.inventory_item_id
4011: )
4012: ),
4011: )
4012: ),
4013: decode(qpil.list_header_id, null, qpll.list_header_id,
4014: decode(qpil.list_header_id,
4015: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4016: null,
4017: qpil.list_header_id
4018: )
4019: ),
4018: )
4019: ),
4020: decode(qpil.list_line_id, null, qpll.list_line_id,
4021: decode(qpil.list_line_id,
4022: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4023: null,
4024: qpil.list_line_id
4025: )
4026: ),
4025: )
4026: ),
4027: decode(qpil.list_line_no, null, qpll.list_line_no,
4028: decode(qpil.list_line_no,
4029: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4030: null,
4031: qpil.list_line_no
4032: )
4033: ),
4032: )
4033: ),
4034: decode(qpil.list_line_type_code, null, qpll.list_line_type_code,
4035: decode(qpil.list_line_type_code,
4036: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4037: null,
4038: qpil.list_line_type_code
4039: )
4040: ),
4039: )
4040: ),
4041: decode(qpil.list_price, null, qpll.list_price,
4042: decode(qpil.list_price,
4043: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4044: null,
4045: qpil.list_price
4046: )
4047: ),
4046: )
4047: ),
4048: decode(qpil.list_price_uom_code, null, qpll.list_price_uom_code,
4049: decode(qpil.list_price_uom_code,
4050: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4051: null,
4052: qpil.list_price_uom_code
4053: )
4054: ),
4053: )
4054: ),
4055: decode(qpil.modifier_level_code, null, qpll.modifier_level_code,
4056: decode(qpil.modifier_level_code,
4057: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4058: null,
4059: qpil.modifier_level_code
4060: )
4061: ),
4060: )
4061: ),
4062: decode(qpil.net_amount_flag, null, qpll.net_amount_flag,
4063: decode(qpil.net_amount_flag,
4064: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4065: null,
4066: qpil.net_amount_flag
4067: )
4068: ),
4067: )
4068: ),
4069: decode(qpil.number_effective_periods, null, qpll.number_effective_periods,
4070: decode(qpil.number_effective_periods,
4071: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4072: null,
4073: qpil.number_effective_periods
4074: )
4075: ),
4074: )
4075: ),
4076: decode(qpil.number_expiration_periods, null, qpll.number_expiration_periods,
4077: decode(qpil.number_expiration_periods,
4078: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4079: null,
4080: qpil.number_expiration_periods
4081: )
4082: ),
4081: )
4082: ),
4083: decode(qpil.operand, null, qpll.operand,
4084: decode(qpil.operand,
4085: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4086: null,
4087: qpil.operand
4088: )
4089: ),
4088: )
4089: ),
4090: decode(qpil.organization_id, null, qpll.organization_id,
4091: decode(qpil.organization_id,
4092: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4093: null,
4094: qpil.organization_id
4095: )
4096: ),
4095: )
4096: ),
4097: decode(qpil.orig_sys_header_ref, null, qpll.orig_sys_header_ref,
4098: decode(qpil.orig_sys_header_ref,
4099: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4100: null,
4101: qpil.orig_sys_header_ref
4102: )
4103: ),
4102: )
4103: ),
4104: decode(qpil.orig_sys_line_ref, null, qpll.orig_sys_line_ref,
4105: decode(qpil.orig_sys_line_ref,
4106: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4107: null,
4108: qpil.orig_sys_line_ref
4109: )
4110: ),
4109: )
4110: ),
4111: decode(qpil.override_flag, null, qpll.override_flag,
4112: decode(qpil.override_flag,
4113: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4114: null,
4115: qpil.override_flag
4116: )
4117: ),
4116: )
4117: ),
4118: decode(qpil.percent_price, null, qpll.percent_price,
4119: decode(qpil.percent_price,
4120: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4121: null,
4122: qpil.percent_price
4123: )
4124: ),
4129: and rm.from_rltd_modifier_id = pll.list_line_id
4130: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
4131: ),
4132: decode(qpil.price_break_header_ref,
4133: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4134: null,
4135: qpil.price_break_header_ref
4136: )
4137: ),
4136: )
4137: ),
4138: decode(qpil.price_break_type_code, null, qpll.price_break_type_code,
4139: decode(qpil.price_break_type_code,
4140: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4141: null,
4142: qpil.price_break_type_code
4143: )
4144: ),
4143: )
4144: ),
4145: decode(qpil.price_by_formula_id, null, qpll.price_by_formula_id,
4146: decode(qpil.price_by_formula_id,
4147: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4148: null,
4149: qpil.price_by_formula_id
4150: )
4151: ),
4150: )
4151: ),
4152: decode(qpil.pricing_group_sequence, null, qpll.pricing_group_sequence,
4153: decode(qpil.pricing_group_sequence,
4154: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4155: null,
4156: qpil.pricing_group_sequence
4157: )
4158: ),
4157: )
4158: ),
4159: decode(qpil.pricing_phase_id, null, qpll.pricing_phase_id,
4160: decode(qpil.pricing_phase_id,
4161: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4162: null,
4163: qpil.pricing_phase_id
4164: )
4165: ),
4164: )
4165: ),
4166: decode(qpil.primary_uom_flag, null, qpll.primary_uom_flag,
4167: decode(qpil.primary_uom_flag,
4168: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4169: null,
4170: qpil.primary_uom_flag
4171: )
4172: ),
4171: )
4172: ),
4173: decode(qpil.print_on_invoice_flag, null, qpll.print_on_invoice_flag,
4174: decode(qpil.print_on_invoice_flag,
4175: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4176: null,
4177: qpil.print_on_invoice_flag
4178: )
4179: ),
4178: )
4179: ),
4180: decode(qpil.product_precedence, null, qpll.product_precedence,
4181: decode(qpil.product_precedence,
4182: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4183: null,
4184: qpil.product_precedence
4185: )
4186: ),
4185: )
4186: ),
4187: decode(qpil.program_application_id, null, qpll.program_application_id,
4188: decode(qpil.program_application_id,
4189: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4190: null,
4191: qpil.program_application_id
4192: )
4193: ),
4192: )
4193: ),
4194: decode(qpil.program_id, null, qpll.program_id,
4195: decode(qpil.program_id,
4196: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4197: null,
4198: qpil.program_id
4199: )
4200: ),
4199: )
4200: ),
4201: decode(qpil.program_update_date, null, qpll.program_update_date,
4202: decode(qpil.program_update_date,
4203: QP_BULK_LOADER_PUB.G_NULL_DATE,
4204: null,
4205: qpil.program_update_date
4206: )
4207: ),
4206: )
4207: ),
4208: decode(qpil.proration_type_code, null, qpll.proration_type_code,
4209: decode(qpil.proration_type_code,
4210: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4211: null,
4212: qpil.proration_type_code
4213: )
4214: ),
4213: )
4214: ),
4215: decode(qpil.qualification_ind, null, qpll.qualification_ind,
4216: decode(qpil.qualification_ind,
4217: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4218: null,
4219: qpil.qualification_ind
4220: )
4221: ),
4220: )
4221: ),
4222: decode(qpil.rebate_transaction_type_code, null, qpll.rebate_transaction_type_code,
4223: decode(qpil.rebate_transaction_type_code,
4224: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4225: null,
4226: qpil.rebate_transaction_type_code
4227: )
4228: ),
4227: )
4228: ),
4229: decode(qpil.recurring_flag, null, qpll.recurring_flag,
4230: decode(qpil.recurring_flag,
4231: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4232: null,
4233: qpil.recurring_flag
4234: )
4235: ),
4234: )
4235: ),
4236: decode(qpil.recurring_value, null, qpll.recurring_value,
4237: decode(qpil.recurring_value,
4238: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4239: null,
4240: qpil.recurring_value
4241: )
4242: ),
4241: )
4242: ),
4243: decode(qpil.related_item_id, null, qpll.related_item_id,
4244: decode(qpil.related_item_id,
4245: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4246: null,
4247: qpil.related_item_id
4248: )
4249: ),
4248: )
4249: ),
4250: decode(qpil.relationship_type_id, null, qpll.relationship_type_id,
4251: decode(qpil.relationship_type_id,
4252: QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4253: null,
4254: qpil.relationship_type_id
4255: )
4256: ),
4255: )
4256: ),
4257: decode(qpil.reprice_flag, null, qpll.reprice_flag,
4258: decode(qpil.reprice_flag,
4259: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4260: null,
4261: qpil.reprice_flag
4262: )
4263: ),
4262: )
4263: ),
4264: decode(qpil.revision, null, qpll.revision,
4265: decode(qpil.revision,
4266: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4267: null,
4268: qpil.revision
4269: )
4270: ),
4269: )
4270: ),
4271: decode(qpil.revision_date, null, qpll.revision_date,
4272: decode(qpil.revision_date,
4273: QP_BULK_LOADER_PUB.G_NULL_DATE,
4274: null,
4275: qpil.revision_date
4276: )
4277: ),
4276: )
4277: ),
4278: decode(qpil.revision_reason_code, null, qpll.revision_reason_code,
4279: decode(qpil.revision_reason_code,
4280: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4281: null,
4282: qpil.revision_reason_code
4283: )
4284: ),
4289: and rm.from_rltd_modifier_id = pll.list_line_id
4290: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
4291: ),
4292: decode(qpil.rltd_modifier_grp_type,
4293: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4294: null,
4295: qpil.rltd_modifier_grp_type
4296: )
4297: ),
4296: )
4297: ),
4298: decode(qpil.start_date_active, null, qpll.start_date_active,
4299: decode(qpil.start_date_active,
4300: QP_BULK_LOADER_PUB.G_NULL_DATE,
4301: null,
4302: qpil.start_date_active
4303: )
4304: ),
4303: )
4304: ),
4305: decode(qpil.substitution_attribute, null, qpll.substitution_attribute,
4306: decode(qpil.substitution_attribute,
4307: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4308: null,
4309: qpil.substitution_attribute
4310: )
4311: ),
4310: )
4311: ),
4312: decode(qpil.substitution_context, null, qpll.substitution_context,
4313: decode(qpil.substitution_context,
4314: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4315: null,
4316: qpil.substitution_context
4317: )
4318: ),
4317: )
4318: ),
4319: decode(qpil.substitution_value, null, qpll.substitution_value,
4320: decode(qpil.substitution_value,
4321: QP_BULK_LOADER_PUB.G_NULL_CHAR,
4322: null,
4323: qpil.substitution_value
4324: )
4325: )
4431: program_update_date,
4432: qualification_ind
4433: ) = ( select
4434: decode(qpip.accumulate_flag, null, qppa.accumulate_flag,
4435: decode(qpip.accumulate_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4436: null,qpip.accumulate_flag
4437: )
4438: ),
4439: decode(qpip.attribute_grouping_no, null, qppa.attribute_grouping_no,
4436: null,qpip.accumulate_flag
4437: )
4438: ),
4439: decode(qpip.attribute_grouping_no, null, qppa.attribute_grouping_no,
4440: decode(qpip.attribute_grouping_no,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4441: null,qpip.attribute_grouping_no
4442: )
4443: ),
4444: decode(qpip.attribute1, null, qppa.attribute1,
4441: null,qpip.attribute_grouping_no
4442: )
4443: ),
4444: decode(qpip.attribute1, null, qppa.attribute1,
4445: decode(qpip.attribute1,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4446: null,qpip.attribute1
4447: )
4448: ),
4449: decode(qpip.attribute10, null, qppa.attribute10,
4446: null,qpip.attribute1
4447: )
4448: ),
4449: decode(qpip.attribute10, null, qppa.attribute10,
4450: decode(qpip.attribute10,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4451: null,qpip.attribute10
4452: )
4453: ),
4454: decode(qpip.attribute11, null, qppa.attribute11,
4451: null,qpip.attribute10
4452: )
4453: ),
4454: decode(qpip.attribute11, null, qppa.attribute11,
4455: decode(qpip.attribute11,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4456: null,qpip.attribute11
4457: )
4458: ),
4459: decode(qpip.attribute12, null, qppa.attribute12,
4456: null,qpip.attribute11
4457: )
4458: ),
4459: decode(qpip.attribute12, null, qppa.attribute12,
4460: decode(qpip.attribute12,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4461: null,qpip.attribute12
4462: )
4463: ),
4464: decode(qpip.attribute13, null, qppa.attribute13,
4461: null,qpip.attribute12
4462: )
4463: ),
4464: decode(qpip.attribute13, null, qppa.attribute13,
4465: decode(qpip.attribute13,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4466: null,qpip.attribute13
4467: )
4468: ),
4469: decode(qpip.attribute14, null, qppa.attribute14,
4466: null,qpip.attribute13
4467: )
4468: ),
4469: decode(qpip.attribute14, null, qppa.attribute14,
4470: decode(qpip.attribute14,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4471: null,qpip.attribute14
4472: )
4473: ),
4474: decode(qpip.attribute15, null, qppa.attribute15,
4471: null,qpip.attribute14
4472: )
4473: ),
4474: decode(qpip.attribute15, null, qppa.attribute15,
4475: decode(qpip.attribute15,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4476: null,qpip.attribute15
4477: )
4478: ),
4479: decode(qpip.attribute2, null, qppa.attribute2,
4476: null,qpip.attribute15
4477: )
4478: ),
4479: decode(qpip.attribute2, null, qppa.attribute2,
4480: decode(qpip.attribute2,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4481: null,qpip.attribute2
4482: )
4483: ),
4484: decode(qpip.attribute3, null, qppa.attribute3,
4481: null,qpip.attribute2
4482: )
4483: ),
4484: decode(qpip.attribute3, null, qppa.attribute3,
4485: decode(qpip.attribute3,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4486: null,qpip.attribute3
4487: )
4488: ),
4489: decode(qpip.attribute4, null, qppa.attribute4,
4486: null,qpip.attribute3
4487: )
4488: ),
4489: decode(qpip.attribute4, null, qppa.attribute4,
4490: decode(qpip.attribute4,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4491: null,qpip.attribute4
4492: )
4493: ),
4494: decode(qpip.attribute5, null, qppa.attribute5,
4491: null,qpip.attribute4
4492: )
4493: ),
4494: decode(qpip.attribute5, null, qppa.attribute5,
4495: decode(qpip.attribute5,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4496: null,qpip.attribute5
4497: )
4498: ),
4499: decode(qpip.attribute6, null, qppa.attribute6,
4496: null,qpip.attribute5
4497: )
4498: ),
4499: decode(qpip.attribute6, null, qppa.attribute6,
4500: decode(qpip.attribute6,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4501: null,qpip.attribute6
4502: )
4503: ),
4504: decode(qpip.attribute7, null, qppa.attribute7,
4501: null,qpip.attribute6
4502: )
4503: ),
4504: decode(qpip.attribute7, null, qppa.attribute7,
4505: decode(qpip.attribute7,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4506: null,qpip.attribute7
4507: )
4508: ),
4509: decode(qpip.attribute8, null, qppa.attribute8,
4506: null,qpip.attribute7
4507: )
4508: ),
4509: decode(qpip.attribute8, null, qppa.attribute8,
4510: decode(qpip.attribute8,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4511: null,qpip.attribute8
4512: )
4513: ),
4514: decode(qpip.attribute9, null, qppa.attribute9,
4511: null,qpip.attribute8
4512: )
4513: ),
4514: decode(qpip.attribute9, null, qppa.attribute9,
4515: decode(qpip.attribute9,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4516: null,qpip.attribute9
4517: )
4518: ),
4519: decode(qpip.comparison_operator_code, null, qppa.comparison_operator_code,
4516: null,qpip.attribute9
4517: )
4518: ),
4519: decode(qpip.comparison_operator_code, null, qppa.comparison_operator_code,
4520: decode(qpip.comparison_operator_code,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4521: null,qpip.comparison_operator_code
4522: )
4523: ),
4524: decode(qpip.context, null, qppa.context,
4521: null,qpip.comparison_operator_code
4522: )
4523: ),
4524: decode(qpip.context, null, qppa.context,
4525: decode(qpip.context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4526: null,qpip.context
4527: )
4528: ),
4529: decode(qpip.created_by, null, qppa.created_by,
4526: null,qpip.context
4527: )
4528: ),
4529: decode(qpip.created_by, null, qppa.created_by,
4530: decode(qpip.created_by,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4531: null,qpip.created_by
4532: )
4533: ),
4534: decode(qpip.excluder_flag, null, qppa.excluder_flag,
4531: null,qpip.created_by
4532: )
4533: ),
4534: decode(qpip.excluder_flag, null, qppa.excluder_flag,
4535: decode(qpip.excluder_flag,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4536: null,qpip.excluder_flag
4537: )
4538: ),
4539: decode(qpip.list_header_id, null, qppa.list_header_id,
4536: null,qpip.excluder_flag
4537: )
4538: ),
4539: decode(qpip.list_header_id, null, qppa.list_header_id,
4540: decode(qpip.list_header_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4541: null,qpip.list_header_id
4542: )
4543: ),
4544: decode(qpip.list_line_id, null, qppa.list_line_id,
4541: null,qpip.list_header_id
4542: )
4543: ),
4544: decode(qpip.list_line_id, null, qppa.list_line_id,
4545: decode(qpip.list_line_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4546: null,qpip.list_line_id
4547: )
4548: ),
4549: decode(qpip.orig_sys_header_ref, null, qppa.orig_sys_header_ref,
4546: null,qpip.list_line_id
4547: )
4548: ),
4549: decode(qpip.orig_sys_header_ref, null, qppa.orig_sys_header_ref,
4550: decode(qpip.orig_sys_header_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4551: null,qpip.orig_sys_header_ref
4552: )
4553: ),
4554: decode(qpip.orig_sys_line_ref, null, qppa.orig_sys_line_ref,
4551: null,qpip.orig_sys_header_ref
4552: )
4553: ),
4554: decode(qpip.orig_sys_line_ref, null, qppa.orig_sys_line_ref,
4555: decode(qpip.orig_sys_line_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4556: null,qpip.orig_sys_line_ref
4557: )
4558: ),
4559: decode(qpip.orig_sys_pricing_attr_ref, null, qppa.orig_sys_pricing_attr_ref,
4556: null,qpip.orig_sys_line_ref
4557: )
4558: ),
4559: decode(qpip.orig_sys_pricing_attr_ref, null, qppa.orig_sys_pricing_attr_ref,
4560: decode(qpip.orig_sys_pricing_attr_ref,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4561: null,qpip.orig_sys_pricing_attr_ref
4562: )
4563: ),
4564: decode(qpip.pricing_attr_value_from, null, qppa.pricing_attr_value_from,
4561: null,qpip.orig_sys_pricing_attr_ref
4562: )
4563: ),
4564: decode(qpip.pricing_attr_value_from, null, qppa.pricing_attr_value_from,
4565: decode(qpip.pricing_attr_value_from,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4566: null,qpip.pricing_attr_value_from
4567: )
4568: ),
4569: decode(qpip.pricing_attr_value_from_number, null, qppa.pricing_attr_value_from_number,
4566: null,qpip.pricing_attr_value_from
4567: )
4568: ),
4569: decode(qpip.pricing_attr_value_from_number, null, qppa.pricing_attr_value_from_number,
4570: decode(qpip.pricing_attr_value_from_number,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4571: null,qpip.pricing_attr_value_from_number
4572: )
4573: ),
4574: decode(qpip.pricing_attr_value_to, null, qppa.pricing_attr_value_to,
4571: null,qpip.pricing_attr_value_from_number
4572: )
4573: ),
4574: decode(qpip.pricing_attr_value_to, null, qppa.pricing_attr_value_to,
4575: decode(qpip.pricing_attr_value_to,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4576: null,qpip.pricing_attr_value_to
4577: )
4578: ),
4579: decode(qpip.pricing_attr_value_to_number, null, qppa.pricing_attr_value_to_number,
4576: null,qpip.pricing_attr_value_to
4577: )
4578: ),
4579: decode(qpip.pricing_attr_value_to_number, null, qppa.pricing_attr_value_to_number,
4580: decode(qpip.pricing_attr_value_to_number,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4581: null,qpip.pricing_attr_value_to_number
4582: )
4583: ),
4584: decode(qpip.pricing_attribute, null, qppa.pricing_attribute,
4581: null,qpip.pricing_attr_value_to_number
4582: )
4583: ),
4584: decode(qpip.pricing_attribute, null, qppa.pricing_attribute,
4585: decode(qpip.pricing_attribute,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4586: null,qpip.pricing_attribute
4587: )
4588: ),
4589: decode(qpip.pricing_attribute_context, null, qppa.pricing_attribute_context,
4586: null,qpip.pricing_attribute
4587: )
4588: ),
4589: decode(qpip.pricing_attribute_context, null, qppa.pricing_attribute_context,
4590: decode(qpip.pricing_attribute_context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4591: null,qpip.pricing_attribute_context
4592: )
4593: ),
4594: decode(qpip.pricing_attribute_datatype, null, qppa.pricing_attribute_datatype,
4591: null,qpip.pricing_attribute_context
4592: )
4593: ),
4594: decode(qpip.pricing_attribute_datatype, null, qppa.pricing_attribute_datatype,
4595: decode(qpip.pricing_attribute_datatype,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4596: null,qpip.pricing_attribute_datatype
4597: )
4598: ),
4599: decode(qpip.pricing_attribute_id, null, qppa.pricing_attribute_id,
4596: null,qpip.pricing_attribute_datatype
4597: )
4598: ),
4599: decode(qpip.pricing_attribute_id, null, qppa.pricing_attribute_id,
4600: decode(qpip.pricing_attribute_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4601: null,qpip.pricing_attribute_id
4602: )
4603: ),
4604: decode(qpip.pricing_phase_id, null, qppa.pricing_phase_id,
4601: null,qpip.pricing_attribute_id
4602: )
4603: ),
4604: decode(qpip.pricing_phase_id, null, qppa.pricing_phase_id,
4605: decode(qpip.pricing_phase_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4606: null,qpip.pricing_phase_id
4607: )
4608: ),
4609: decode(qpip.product_attr_value, null, qppa.product_attr_value,
4606: null,qpip.pricing_phase_id
4607: )
4608: ),
4609: decode(qpip.product_attr_value, null, qppa.product_attr_value,
4610: decode(qpip.product_attr_value,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4611: null,qpip.product_attr_value
4612: )
4613: ),
4614: decode(qpip.product_attribute, null, qppa.product_attribute,
4611: null,qpip.product_attr_value
4612: )
4613: ),
4614: decode(qpip.product_attribute, null, qppa.product_attribute,
4615: decode(qpip.product_attribute,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4616: null,qpip.product_attribute
4617: )
4618: ),
4619: decode(qpip.product_attribute_context, null, qppa.product_attribute_context,
4616: null,qpip.product_attribute
4617: )
4618: ),
4619: decode(qpip.product_attribute_context, null, qppa.product_attribute_context,
4620: decode(qpip.product_attribute_context,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4621: null,qpip.product_attribute_context
4622: )
4623: ),
4624: decode(qpip.product_attribute_datatype, null, qppa.product_attribute_datatype,
4621: null,qpip.product_attribute_context
4622: )
4623: ),
4624: decode(qpip.product_attribute_datatype, null, qppa.product_attribute_datatype,
4625: decode(qpip.product_attribute_datatype,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4626: null,qpip.product_attribute_datatype
4627: )
4628: ),
4629: decode(qpip.product_uom_code, null, qppa.product_uom_code,
4626: null,qpip.product_attribute_datatype
4627: )
4628: ),
4629: decode(qpip.product_uom_code, null, qppa.product_uom_code,
4630: decode(qpip.product_uom_code,QP_BULK_LOADER_PUB.G_NULL_CHAR,
4631: null,qpip.product_uom_code
4632: )
4633: ),
4634: decode(qpip.program_application_id, null, qppa.program_application_id,
4631: null,qpip.product_uom_code
4632: )
4633: ),
4634: decode(qpip.program_application_id, null, qppa.program_application_id,
4635: decode(qpip.program_application_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4636: null,qpip.program_application_id
4637: )
4638: ),
4639: decode(qpip.program_id, null, qppa.program_id,
4636: null,qpip.program_application_id
4637: )
4638: ),
4639: decode(qpip.program_id, null, qppa.program_id,
4640: decode(qpip.program_id,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4641: null,qpip.program_id
4642: )
4643: ),
4644: decode(qpip.program_update_date, null, qppa.program_update_date,
4641: null,qpip.program_id
4642: )
4643: ),
4644: decode(qpip.program_update_date, null, qppa.program_update_date,
4645: decode(qpip.program_update_date,QP_BULK_LOADER_PUB.G_NULL_DATE,
4646: null,qpip.program_update_date
4647: )
4648: ),
4649: decode(qpip.qualification_ind, null, qppa.qualification_ind,
4646: null,qpip.program_update_date
4647: )
4648: ),
4649: decode(qpip.qualification_ind, null, qppa.qualification_ind,
4650: decode(qpip.qualification_ind,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4651: null,qpip.qualification_ind
4652: )
4653: )
4654: from qp_pricing_attributes qppa,
6931: from qp_list_lines pl, qp_rltd_modifiers rltd
6932: where rltd.from_rltd_modifier_id = l.list_line_id
6933: and pl.list_line_id = rltd.to_rltd_modifier_id);
6934:
6935: l_list_line_id_tbl QP_BULK_LOADER_PUB.num_type;
6936: l_orig_sys_line_ref_tbl QP_BULK_LOADER_PUB.char50_type;
6937: l_orig_sys_header_ref_tbl QP_BULK_LOADER_PUB.char50_type;
6938: l_msg_txt VARCHAR2(2000);
6939:
6932: where rltd.from_rltd_modifier_id = l.list_line_id
6933: and pl.list_line_id = rltd.to_rltd_modifier_id);
6934:
6935: l_list_line_id_tbl QP_BULK_LOADER_PUB.num_type;
6936: l_orig_sys_line_ref_tbl QP_BULK_LOADER_PUB.char50_type;
6937: l_orig_sys_header_ref_tbl QP_BULK_LOADER_PUB.char50_type;
6938: l_msg_txt VARCHAR2(2000);
6939:
6940: BEGIN
6933: and pl.list_line_id = rltd.to_rltd_modifier_id);
6934:
6935: l_list_line_id_tbl QP_BULK_LOADER_PUB.num_type;
6936: l_orig_sys_line_ref_tbl QP_BULK_LOADER_PUB.char50_type;
6937: l_orig_sys_header_ref_tbl QP_BULK_LOADER_PUB.char50_type;
6938: l_msg_txt VARCHAR2(2000);
6939:
6940: BEGIN
6941:
7326: FND_FILE.PUT_LINE(FND_FILE.LOG, log_text);
7327: END IF;
7328: END;
7329:
7330: END QP_BULK_LOADER_PUB;