eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XNP_SV_ORDERS$SOA_SV dependencies on XNP_SV_SOA_VL

Line 74: CURR_VAL XNP_SV_SOA_VL%ROWTYPE;

70: LOV_FRAME constant varchar2(20) := null;
71: TF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
72: DEF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
73:
74: CURR_VAL XNP_SV_SOA_VL%ROWTYPE;
75:
76: TYPE FORM_REC IS RECORD
77: (PORTING_ID VARCHAR2(80)
78: ,SUBSCRIPTION_TYPE VARCHAR2(30)

Line 625: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SOA_VL.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);

621: InitialiseDomain('SUBSCRIPTION_TYPE');
622:
623: -- Build up the Where clause
624:
625: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SOA_VL.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);

Line 626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);

622:
623: -- Build up the Where clause
624:
625: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SOA_VL.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);

Line 627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);

623: -- Build up the Where clause
624:
625: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SOA_VL.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

Line 628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);

624:
625: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SOA_VL.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

Line 629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);

625: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SOA_VL.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

Line 630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);

626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
634:

Line 631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
634:
635: ZONE_SQL := 'SELECT XNP_SV_SOA_VL.PORTING_ID,

Line 632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
634:
635: ZONE_SQL := 'SELECT XNP_SV_SOA_VL.PORTING_ID,
636: XNP_SV_SOA_VL.SUBSCRIPTION_TN,

Line 633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
634:
635: ZONE_SQL := 'SELECT XNP_SV_SOA_VL.PORTING_ID,
636: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
637: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,

Line 635: ZONE_SQL := 'SELECT XNP_SV_SOA_VL.PORTING_ID,

631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
634:
635: ZONE_SQL := 'SELECT XNP_SV_SOA_VL.PORTING_ID,
636: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
637: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,
638: XNP_SV_SOA_VL.SV_SOA_ID
639: FROM XNP_SV_SOA_VL XNP_SV_SOA_VL';

Line 636: XNP_SV_SOA_VL.SUBSCRIPTION_TN,

632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
634:
635: ZONE_SQL := 'SELECT XNP_SV_SOA_VL.PORTING_ID,
636: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
637: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,
638: XNP_SV_SOA_VL.SV_SOA_ID
639: FROM XNP_SV_SOA_VL XNP_SV_SOA_VL';
640:

Line 637: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,

633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
634:
635: ZONE_SQL := 'SELECT XNP_SV_SOA_VL.PORTING_ID,
636: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
637: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,
638: XNP_SV_SOA_VL.SV_SOA_ID
639: FROM XNP_SV_SOA_VL XNP_SV_SOA_VL';
640:
641: ZONE_SQL := ZONE_SQL || I_WHERE;

Line 638: XNP_SV_SOA_VL.SV_SOA_ID

634:
635: ZONE_SQL := 'SELECT XNP_SV_SOA_VL.PORTING_ID,
636: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
637: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,
638: XNP_SV_SOA_VL.SV_SOA_ID
639: FROM XNP_SV_SOA_VL XNP_SV_SOA_VL';
640:
641: ZONE_SQL := ZONE_SQL || I_WHERE;
642: ZONE_SQL := ZONE_SQL || ' ORDER BY 1';

Line 639: FROM XNP_SV_SOA_VL XNP_SV_SOA_VL';

635: ZONE_SQL := 'SELECT XNP_SV_SOA_VL.PORTING_ID,
636: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
637: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,
638: XNP_SV_SOA_VL.SV_SOA_ID
639: FROM XNP_SV_SOA_VL XNP_SV_SOA_VL';
640:
641: ZONE_SQL := ZONE_SQL || I_WHERE;
642: ZONE_SQL := ZONE_SQL || ' ORDER BY 1';
643:

Line 1138: SELECT XNP_SV_SOA_VL.PORTING_ID,

1134: null;
1135:
1136: else
1137:
1138: SELECT XNP_SV_SOA_VL.PORTING_ID,
1139: XNP_SV_SOA_VL.SUBSCRIPTION_TYPE,
1140: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
1141: XNP_SV_SOA_VL.PRE_SPLIT_SUBSCRIPTION_TN,
1142: XNP_SV_SOA_VL.ROUTING_NUMBER,

Line 1139: XNP_SV_SOA_VL.SUBSCRIPTION_TYPE,

1135:
1136: else
1137:
1138: SELECT XNP_SV_SOA_VL.PORTING_ID,
1139: XNP_SV_SOA_VL.SUBSCRIPTION_TYPE,
1140: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
1141: XNP_SV_SOA_VL.PRE_SPLIT_SUBSCRIPTION_TN,
1142: XNP_SV_SOA_VL.ROUTING_NUMBER,
1143: XNP_SV_SOA_VL.STATUS_PHASE,

Line 1140: XNP_SV_SOA_VL.SUBSCRIPTION_TN,

1136: else
1137:
1138: SELECT XNP_SV_SOA_VL.PORTING_ID,
1139: XNP_SV_SOA_VL.SUBSCRIPTION_TYPE,
1140: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
1141: XNP_SV_SOA_VL.PRE_SPLIT_SUBSCRIPTION_TN,
1142: XNP_SV_SOA_VL.ROUTING_NUMBER,
1143: XNP_SV_SOA_VL.STATUS_PHASE,
1144: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,

Line 1141: XNP_SV_SOA_VL.PRE_SPLIT_SUBSCRIPTION_TN,

1137:
1138: SELECT XNP_SV_SOA_VL.PORTING_ID,
1139: XNP_SV_SOA_VL.SUBSCRIPTION_TYPE,
1140: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
1141: XNP_SV_SOA_VL.PRE_SPLIT_SUBSCRIPTION_TN,
1142: XNP_SV_SOA_VL.ROUTING_NUMBER,
1143: XNP_SV_SOA_VL.STATUS_PHASE,
1144: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,
1145: XNP_SV_SOA_VL.STATUS_CHANGE_DATE,

Line 1142: XNP_SV_SOA_VL.ROUTING_NUMBER,

1138: SELECT XNP_SV_SOA_VL.PORTING_ID,
1139: XNP_SV_SOA_VL.SUBSCRIPTION_TYPE,
1140: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
1141: XNP_SV_SOA_VL.PRE_SPLIT_SUBSCRIPTION_TN,
1142: XNP_SV_SOA_VL.ROUTING_NUMBER,
1143: XNP_SV_SOA_VL.STATUS_PHASE,
1144: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,
1145: XNP_SV_SOA_VL.STATUS_CHANGE_DATE,
1146: XNP_SV_SOA_VL.STATUS_CHANGE_CAUSE_CODE,

Line 1143: XNP_SV_SOA_VL.STATUS_PHASE,

1139: XNP_SV_SOA_VL.SUBSCRIPTION_TYPE,
1140: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
1141: XNP_SV_SOA_VL.PRE_SPLIT_SUBSCRIPTION_TN,
1142: XNP_SV_SOA_VL.ROUTING_NUMBER,
1143: XNP_SV_SOA_VL.STATUS_PHASE,
1144: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,
1145: XNP_SV_SOA_VL.STATUS_CHANGE_DATE,
1146: XNP_SV_SOA_VL.STATUS_CHANGE_CAUSE_CODE,
1147: XNP_SV_SOA_VL.CUSTOMER_ID,

Line 1144: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,

1140: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
1141: XNP_SV_SOA_VL.PRE_SPLIT_SUBSCRIPTION_TN,
1142: XNP_SV_SOA_VL.ROUTING_NUMBER,
1143: XNP_SV_SOA_VL.STATUS_PHASE,
1144: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,
1145: XNP_SV_SOA_VL.STATUS_CHANGE_DATE,
1146: XNP_SV_SOA_VL.STATUS_CHANGE_CAUSE_CODE,
1147: XNP_SV_SOA_VL.CUSTOMER_ID,
1148: XNP_SV_SOA_VL.CUSTOMER_NAME,

Line 1145: XNP_SV_SOA_VL.STATUS_CHANGE_DATE,

1141: XNP_SV_SOA_VL.PRE_SPLIT_SUBSCRIPTION_TN,
1142: XNP_SV_SOA_VL.ROUTING_NUMBER,
1143: XNP_SV_SOA_VL.STATUS_PHASE,
1144: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,
1145: XNP_SV_SOA_VL.STATUS_CHANGE_DATE,
1146: XNP_SV_SOA_VL.STATUS_CHANGE_CAUSE_CODE,
1147: XNP_SV_SOA_VL.CUSTOMER_ID,
1148: XNP_SV_SOA_VL.CUSTOMER_NAME,
1149: XNP_SV_SOA_VL.CONTACT_NAME,

Line 1146: XNP_SV_SOA_VL.STATUS_CHANGE_CAUSE_CODE,

1142: XNP_SV_SOA_VL.ROUTING_NUMBER,
1143: XNP_SV_SOA_VL.STATUS_PHASE,
1144: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,
1145: XNP_SV_SOA_VL.STATUS_CHANGE_DATE,
1146: XNP_SV_SOA_VL.STATUS_CHANGE_CAUSE_CODE,
1147: XNP_SV_SOA_VL.CUSTOMER_ID,
1148: XNP_SV_SOA_VL.CUSTOMER_NAME,
1149: XNP_SV_SOA_VL.CONTACT_NAME,
1150: XNP_SV_SOA_VL.PHONE,

Line 1147: XNP_SV_SOA_VL.CUSTOMER_ID,

1143: XNP_SV_SOA_VL.STATUS_PHASE,
1144: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,
1145: XNP_SV_SOA_VL.STATUS_CHANGE_DATE,
1146: XNP_SV_SOA_VL.STATUS_CHANGE_CAUSE_CODE,
1147: XNP_SV_SOA_VL.CUSTOMER_ID,
1148: XNP_SV_SOA_VL.CUSTOMER_NAME,
1149: XNP_SV_SOA_VL.CONTACT_NAME,
1150: XNP_SV_SOA_VL.PHONE,
1151: XNP_SV_SOA_VL.EMAIL,

Line 1148: XNP_SV_SOA_VL.CUSTOMER_NAME,

1144: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,
1145: XNP_SV_SOA_VL.STATUS_CHANGE_DATE,
1146: XNP_SV_SOA_VL.STATUS_CHANGE_CAUSE_CODE,
1147: XNP_SV_SOA_VL.CUSTOMER_ID,
1148: XNP_SV_SOA_VL.CUSTOMER_NAME,
1149: XNP_SV_SOA_VL.CONTACT_NAME,
1150: XNP_SV_SOA_VL.PHONE,
1151: XNP_SV_SOA_VL.EMAIL,
1152: XNP_SV_SOA_VL.ACTIVATION_DUE_DATE,

Line 1149: XNP_SV_SOA_VL.CONTACT_NAME,

1145: XNP_SV_SOA_VL.STATUS_CHANGE_DATE,
1146: XNP_SV_SOA_VL.STATUS_CHANGE_CAUSE_CODE,
1147: XNP_SV_SOA_VL.CUSTOMER_ID,
1148: XNP_SV_SOA_VL.CUSTOMER_NAME,
1149: XNP_SV_SOA_VL.CONTACT_NAME,
1150: XNP_SV_SOA_VL.PHONE,
1151: XNP_SV_SOA_VL.EMAIL,
1152: XNP_SV_SOA_VL.ACTIVATION_DUE_DATE,
1153: XNP_SV_SOA_VL.ORDER_PRIORITY,

Line 1150: XNP_SV_SOA_VL.PHONE,

1146: XNP_SV_SOA_VL.STATUS_CHANGE_CAUSE_CODE,
1147: XNP_SV_SOA_VL.CUSTOMER_ID,
1148: XNP_SV_SOA_VL.CUSTOMER_NAME,
1149: XNP_SV_SOA_VL.CONTACT_NAME,
1150: XNP_SV_SOA_VL.PHONE,
1151: XNP_SV_SOA_VL.EMAIL,
1152: XNP_SV_SOA_VL.ACTIVATION_DUE_DATE,
1153: XNP_SV_SOA_VL.ORDER_PRIORITY,
1154: XNP_SV_SOA_VL.PREORDER_AUTHORIZATION_CODE,

Line 1151: XNP_SV_SOA_VL.EMAIL,

1147: XNP_SV_SOA_VL.CUSTOMER_ID,
1148: XNP_SV_SOA_VL.CUSTOMER_NAME,
1149: XNP_SV_SOA_VL.CONTACT_NAME,
1150: XNP_SV_SOA_VL.PHONE,
1151: XNP_SV_SOA_VL.EMAIL,
1152: XNP_SV_SOA_VL.ACTIVATION_DUE_DATE,
1153: XNP_SV_SOA_VL.ORDER_PRIORITY,
1154: XNP_SV_SOA_VL.PREORDER_AUTHORIZATION_CODE,
1155: XNP_SV_SOA_VL.REC_CODE,

Line 1152: XNP_SV_SOA_VL.ACTIVATION_DUE_DATE,

1148: XNP_SV_SOA_VL.CUSTOMER_NAME,
1149: XNP_SV_SOA_VL.CONTACT_NAME,
1150: XNP_SV_SOA_VL.PHONE,
1151: XNP_SV_SOA_VL.EMAIL,
1152: XNP_SV_SOA_VL.ACTIVATION_DUE_DATE,
1153: XNP_SV_SOA_VL.ORDER_PRIORITY,
1154: XNP_SV_SOA_VL.PREORDER_AUTHORIZATION_CODE,
1155: XNP_SV_SOA_VL.REC_CODE,
1156: XNP_SV_SOA_VL.REC_NAME,

Line 1153: XNP_SV_SOA_VL.ORDER_PRIORITY,

1149: XNP_SV_SOA_VL.CONTACT_NAME,
1150: XNP_SV_SOA_VL.PHONE,
1151: XNP_SV_SOA_VL.EMAIL,
1152: XNP_SV_SOA_VL.ACTIVATION_DUE_DATE,
1153: XNP_SV_SOA_VL.ORDER_PRIORITY,
1154: XNP_SV_SOA_VL.PREORDER_AUTHORIZATION_CODE,
1155: XNP_SV_SOA_VL.REC_CODE,
1156: XNP_SV_SOA_VL.REC_NAME,
1157: XNP_SV_SOA_VL.REC_EMAIL,

Line 1154: XNP_SV_SOA_VL.PREORDER_AUTHORIZATION_CODE,

1150: XNP_SV_SOA_VL.PHONE,
1151: XNP_SV_SOA_VL.EMAIL,
1152: XNP_SV_SOA_VL.ACTIVATION_DUE_DATE,
1153: XNP_SV_SOA_VL.ORDER_PRIORITY,
1154: XNP_SV_SOA_VL.PREORDER_AUTHORIZATION_CODE,
1155: XNP_SV_SOA_VL.REC_CODE,
1156: XNP_SV_SOA_VL.REC_NAME,
1157: XNP_SV_SOA_VL.REC_EMAIL,
1158: XNP_SV_SOA_VL.DON_CODE,

Line 1155: XNP_SV_SOA_VL.REC_CODE,

1151: XNP_SV_SOA_VL.EMAIL,
1152: XNP_SV_SOA_VL.ACTIVATION_DUE_DATE,
1153: XNP_SV_SOA_VL.ORDER_PRIORITY,
1154: XNP_SV_SOA_VL.PREORDER_AUTHORIZATION_CODE,
1155: XNP_SV_SOA_VL.REC_CODE,
1156: XNP_SV_SOA_VL.REC_NAME,
1157: XNP_SV_SOA_VL.REC_EMAIL,
1158: XNP_SV_SOA_VL.DON_CODE,
1159: XNP_SV_SOA_VL.DON_NAME,

Line 1156: XNP_SV_SOA_VL.REC_NAME,

1152: XNP_SV_SOA_VL.ACTIVATION_DUE_DATE,
1153: XNP_SV_SOA_VL.ORDER_PRIORITY,
1154: XNP_SV_SOA_VL.PREORDER_AUTHORIZATION_CODE,
1155: XNP_SV_SOA_VL.REC_CODE,
1156: XNP_SV_SOA_VL.REC_NAME,
1157: XNP_SV_SOA_VL.REC_EMAIL,
1158: XNP_SV_SOA_VL.DON_CODE,
1159: XNP_SV_SOA_VL.DON_NAME,
1160: XNP_SV_SOA_VL.DON_EMAIL,

Line 1157: XNP_SV_SOA_VL.REC_EMAIL,

1153: XNP_SV_SOA_VL.ORDER_PRIORITY,
1154: XNP_SV_SOA_VL.PREORDER_AUTHORIZATION_CODE,
1155: XNP_SV_SOA_VL.REC_CODE,
1156: XNP_SV_SOA_VL.REC_NAME,
1157: XNP_SV_SOA_VL.REC_EMAIL,
1158: XNP_SV_SOA_VL.DON_CODE,
1159: XNP_SV_SOA_VL.DON_NAME,
1160: XNP_SV_SOA_VL.DON_EMAIL,
1161: XNP_SV_SOA_VL.NRC_CODE,

Line 1158: XNP_SV_SOA_VL.DON_CODE,

1154: XNP_SV_SOA_VL.PREORDER_AUTHORIZATION_CODE,
1155: XNP_SV_SOA_VL.REC_CODE,
1156: XNP_SV_SOA_VL.REC_NAME,
1157: XNP_SV_SOA_VL.REC_EMAIL,
1158: XNP_SV_SOA_VL.DON_CODE,
1159: XNP_SV_SOA_VL.DON_NAME,
1160: XNP_SV_SOA_VL.DON_EMAIL,
1161: XNP_SV_SOA_VL.NRC_CODE,
1162: XNP_SV_SOA_VL.NRC_NAME,

Line 1159: XNP_SV_SOA_VL.DON_NAME,

1155: XNP_SV_SOA_VL.REC_CODE,
1156: XNP_SV_SOA_VL.REC_NAME,
1157: XNP_SV_SOA_VL.REC_EMAIL,
1158: XNP_SV_SOA_VL.DON_CODE,
1159: XNP_SV_SOA_VL.DON_NAME,
1160: XNP_SV_SOA_VL.DON_EMAIL,
1161: XNP_SV_SOA_VL.NRC_CODE,
1162: XNP_SV_SOA_VL.NRC_NAME,
1163: XNP_SV_SOA_VL.NRC_EMAIL,

Line 1160: XNP_SV_SOA_VL.DON_EMAIL,

1156: XNP_SV_SOA_VL.REC_NAME,
1157: XNP_SV_SOA_VL.REC_EMAIL,
1158: XNP_SV_SOA_VL.DON_CODE,
1159: XNP_SV_SOA_VL.DON_NAME,
1160: XNP_SV_SOA_VL.DON_EMAIL,
1161: XNP_SV_SOA_VL.NRC_CODE,
1162: XNP_SV_SOA_VL.NRC_NAME,
1163: XNP_SV_SOA_VL.NRC_EMAIL,
1164: XNP_SV_SOA_VL.NEW_SP_AUTHORIZATION_FLAG,

Line 1161: XNP_SV_SOA_VL.NRC_CODE,

1157: XNP_SV_SOA_VL.REC_EMAIL,
1158: XNP_SV_SOA_VL.DON_CODE,
1159: XNP_SV_SOA_VL.DON_NAME,
1160: XNP_SV_SOA_VL.DON_EMAIL,
1161: XNP_SV_SOA_VL.NRC_CODE,
1162: XNP_SV_SOA_VL.NRC_NAME,
1163: XNP_SV_SOA_VL.NRC_EMAIL,
1164: XNP_SV_SOA_VL.NEW_SP_AUTHORIZATION_FLAG,
1165: XNP_SV_SOA_VL.NEW_SP_DUE_DATE,

Line 1162: XNP_SV_SOA_VL.NRC_NAME,

1158: XNP_SV_SOA_VL.DON_CODE,
1159: XNP_SV_SOA_VL.DON_NAME,
1160: XNP_SV_SOA_VL.DON_EMAIL,
1161: XNP_SV_SOA_VL.NRC_CODE,
1162: XNP_SV_SOA_VL.NRC_NAME,
1163: XNP_SV_SOA_VL.NRC_EMAIL,
1164: XNP_SV_SOA_VL.NEW_SP_AUTHORIZATION_FLAG,
1165: XNP_SV_SOA_VL.NEW_SP_DUE_DATE,
1166: XNP_SV_SOA_VL.OLD_SP_AUTHORIZATION_FLAG,

Line 1163: XNP_SV_SOA_VL.NRC_EMAIL,

1159: XNP_SV_SOA_VL.DON_NAME,
1160: XNP_SV_SOA_VL.DON_EMAIL,
1161: XNP_SV_SOA_VL.NRC_CODE,
1162: XNP_SV_SOA_VL.NRC_NAME,
1163: XNP_SV_SOA_VL.NRC_EMAIL,
1164: XNP_SV_SOA_VL.NEW_SP_AUTHORIZATION_FLAG,
1165: XNP_SV_SOA_VL.NEW_SP_DUE_DATE,
1166: XNP_SV_SOA_VL.OLD_SP_AUTHORIZATION_FLAG,
1167: XNP_SV_SOA_VL.OLD_SP_DUE_DATE,

Line 1164: XNP_SV_SOA_VL.NEW_SP_AUTHORIZATION_FLAG,

1160: XNP_SV_SOA_VL.DON_EMAIL,
1161: XNP_SV_SOA_VL.NRC_CODE,
1162: XNP_SV_SOA_VL.NRC_NAME,
1163: XNP_SV_SOA_VL.NRC_EMAIL,
1164: XNP_SV_SOA_VL.NEW_SP_AUTHORIZATION_FLAG,
1165: XNP_SV_SOA_VL.NEW_SP_DUE_DATE,
1166: XNP_SV_SOA_VL.OLD_SP_AUTHORIZATION_FLAG,
1167: XNP_SV_SOA_VL.OLD_SP_DUE_DATE,
1168: XNP_SV_SOA_VL.OLD_SP_CUTOFF_DUE_DATE,

Line 1165: XNP_SV_SOA_VL.NEW_SP_DUE_DATE,

1161: XNP_SV_SOA_VL.NRC_CODE,
1162: XNP_SV_SOA_VL.NRC_NAME,
1163: XNP_SV_SOA_VL.NRC_EMAIL,
1164: XNP_SV_SOA_VL.NEW_SP_AUTHORIZATION_FLAG,
1165: XNP_SV_SOA_VL.NEW_SP_DUE_DATE,
1166: XNP_SV_SOA_VL.OLD_SP_AUTHORIZATION_FLAG,
1167: XNP_SV_SOA_VL.OLD_SP_DUE_DATE,
1168: XNP_SV_SOA_VL.OLD_SP_CUTOFF_DUE_DATE,
1169: XNP_SV_SOA_VL.INVOICE_DUE_DATE,

Line 1166: XNP_SV_SOA_VL.OLD_SP_AUTHORIZATION_FLAG,

1162: XNP_SV_SOA_VL.NRC_NAME,
1163: XNP_SV_SOA_VL.NRC_EMAIL,
1164: XNP_SV_SOA_VL.NEW_SP_AUTHORIZATION_FLAG,
1165: XNP_SV_SOA_VL.NEW_SP_DUE_DATE,
1166: XNP_SV_SOA_VL.OLD_SP_AUTHORIZATION_FLAG,
1167: XNP_SV_SOA_VL.OLD_SP_DUE_DATE,
1168: XNP_SV_SOA_VL.OLD_SP_CUTOFF_DUE_DATE,
1169: XNP_SV_SOA_VL.INVOICE_DUE_DATE,
1170: XNP_SV_SOA_VL.RETAIN_DIR_INFO_FLAG,

Line 1167: XNP_SV_SOA_VL.OLD_SP_DUE_DATE,

1163: XNP_SV_SOA_VL.NRC_EMAIL,
1164: XNP_SV_SOA_VL.NEW_SP_AUTHORIZATION_FLAG,
1165: XNP_SV_SOA_VL.NEW_SP_DUE_DATE,
1166: XNP_SV_SOA_VL.OLD_SP_AUTHORIZATION_FLAG,
1167: XNP_SV_SOA_VL.OLD_SP_DUE_DATE,
1168: XNP_SV_SOA_VL.OLD_SP_CUTOFF_DUE_DATE,
1169: XNP_SV_SOA_VL.INVOICE_DUE_DATE,
1170: XNP_SV_SOA_VL.RETAIN_DIR_INFO_FLAG,
1171: XNP_SV_SOA_VL.LOCKED_FLAG,

Line 1168: XNP_SV_SOA_VL.OLD_SP_CUTOFF_DUE_DATE,

1164: XNP_SV_SOA_VL.NEW_SP_AUTHORIZATION_FLAG,
1165: XNP_SV_SOA_VL.NEW_SP_DUE_DATE,
1166: XNP_SV_SOA_VL.OLD_SP_AUTHORIZATION_FLAG,
1167: XNP_SV_SOA_VL.OLD_SP_DUE_DATE,
1168: XNP_SV_SOA_VL.OLD_SP_CUTOFF_DUE_DATE,
1169: XNP_SV_SOA_VL.INVOICE_DUE_DATE,
1170: XNP_SV_SOA_VL.RETAIN_DIR_INFO_FLAG,
1171: XNP_SV_SOA_VL.LOCKED_FLAG,
1172: XNP_SV_SOA_VL.CONCURRENCE_FLAG,

Line 1169: XNP_SV_SOA_VL.INVOICE_DUE_DATE,

1165: XNP_SV_SOA_VL.NEW_SP_DUE_DATE,
1166: XNP_SV_SOA_VL.OLD_SP_AUTHORIZATION_FLAG,
1167: XNP_SV_SOA_VL.OLD_SP_DUE_DATE,
1168: XNP_SV_SOA_VL.OLD_SP_CUTOFF_DUE_DATE,
1169: XNP_SV_SOA_VL.INVOICE_DUE_DATE,
1170: XNP_SV_SOA_VL.RETAIN_DIR_INFO_FLAG,
1171: XNP_SV_SOA_VL.LOCKED_FLAG,
1172: XNP_SV_SOA_VL.CONCURRENCE_FLAG,
1173: XNP_SV_SOA_VL.PTO_FLAG,

Line 1170: XNP_SV_SOA_VL.RETAIN_DIR_INFO_FLAG,

1166: XNP_SV_SOA_VL.OLD_SP_AUTHORIZATION_FLAG,
1167: XNP_SV_SOA_VL.OLD_SP_DUE_DATE,
1168: XNP_SV_SOA_VL.OLD_SP_CUTOFF_DUE_DATE,
1169: XNP_SV_SOA_VL.INVOICE_DUE_DATE,
1170: XNP_SV_SOA_VL.RETAIN_DIR_INFO_FLAG,
1171: XNP_SV_SOA_VL.LOCKED_FLAG,
1172: XNP_SV_SOA_VL.CONCURRENCE_FLAG,
1173: XNP_SV_SOA_VL.PTO_FLAG,
1174: XNP_SV_SOA_VL.DISCONNECT_DUE_DATE,

Line 1171: XNP_SV_SOA_VL.LOCKED_FLAG,

1167: XNP_SV_SOA_VL.OLD_SP_DUE_DATE,
1168: XNP_SV_SOA_VL.OLD_SP_CUTOFF_DUE_DATE,
1169: XNP_SV_SOA_VL.INVOICE_DUE_DATE,
1170: XNP_SV_SOA_VL.RETAIN_DIR_INFO_FLAG,
1171: XNP_SV_SOA_VL.LOCKED_FLAG,
1172: XNP_SV_SOA_VL.CONCURRENCE_FLAG,
1173: XNP_SV_SOA_VL.PTO_FLAG,
1174: XNP_SV_SOA_VL.DISCONNECT_DUE_DATE,
1175: XNP_SV_SOA_VL.EFFECTIVE_RELEASE_DUE_DATE,

Line 1172: XNP_SV_SOA_VL.CONCURRENCE_FLAG,

1168: XNP_SV_SOA_VL.OLD_SP_CUTOFF_DUE_DATE,
1169: XNP_SV_SOA_VL.INVOICE_DUE_DATE,
1170: XNP_SV_SOA_VL.RETAIN_DIR_INFO_FLAG,
1171: XNP_SV_SOA_VL.LOCKED_FLAG,
1172: XNP_SV_SOA_VL.CONCURRENCE_FLAG,
1173: XNP_SV_SOA_VL.PTO_FLAG,
1174: XNP_SV_SOA_VL.DISCONNECT_DUE_DATE,
1175: XNP_SV_SOA_VL.EFFECTIVE_RELEASE_DUE_DATE,
1176: XNP_SV_SOA_VL.RETAIN_TN_FLAG,

Line 1173: XNP_SV_SOA_VL.PTO_FLAG,

1169: XNP_SV_SOA_VL.INVOICE_DUE_DATE,
1170: XNP_SV_SOA_VL.RETAIN_DIR_INFO_FLAG,
1171: XNP_SV_SOA_VL.LOCKED_FLAG,
1172: XNP_SV_SOA_VL.CONCURRENCE_FLAG,
1173: XNP_SV_SOA_VL.PTO_FLAG,
1174: XNP_SV_SOA_VL.DISCONNECT_DUE_DATE,
1175: XNP_SV_SOA_VL.EFFECTIVE_RELEASE_DUE_DATE,
1176: XNP_SV_SOA_VL.RETAIN_TN_FLAG,
1177: XNP_SV_SOA_VL.BLOCKED_FLAG,

Line 1174: XNP_SV_SOA_VL.DISCONNECT_DUE_DATE,

1170: XNP_SV_SOA_VL.RETAIN_DIR_INFO_FLAG,
1171: XNP_SV_SOA_VL.LOCKED_FLAG,
1172: XNP_SV_SOA_VL.CONCURRENCE_FLAG,
1173: XNP_SV_SOA_VL.PTO_FLAG,
1174: XNP_SV_SOA_VL.DISCONNECT_DUE_DATE,
1175: XNP_SV_SOA_VL.EFFECTIVE_RELEASE_DUE_DATE,
1176: XNP_SV_SOA_VL.RETAIN_TN_FLAG,
1177: XNP_SV_SOA_VL.BLOCKED_FLAG,
1178: XNP_SV_SOA_VL.NUMBER_RETURNED_DUE_DATE,

Line 1175: XNP_SV_SOA_VL.EFFECTIVE_RELEASE_DUE_DATE,

1171: XNP_SV_SOA_VL.LOCKED_FLAG,
1172: XNP_SV_SOA_VL.CONCURRENCE_FLAG,
1173: XNP_SV_SOA_VL.PTO_FLAG,
1174: XNP_SV_SOA_VL.DISCONNECT_DUE_DATE,
1175: XNP_SV_SOA_VL.EFFECTIVE_RELEASE_DUE_DATE,
1176: XNP_SV_SOA_VL.RETAIN_TN_FLAG,
1177: XNP_SV_SOA_VL.BLOCKED_FLAG,
1178: XNP_SV_SOA_VL.NUMBER_RETURNED_DUE_DATE,
1179: XNP_SV_SOA_VL.CLASS_ADDRESS,

Line 1176: XNP_SV_SOA_VL.RETAIN_TN_FLAG,

1172: XNP_SV_SOA_VL.CONCURRENCE_FLAG,
1173: XNP_SV_SOA_VL.PTO_FLAG,
1174: XNP_SV_SOA_VL.DISCONNECT_DUE_DATE,
1175: XNP_SV_SOA_VL.EFFECTIVE_RELEASE_DUE_DATE,
1176: XNP_SV_SOA_VL.RETAIN_TN_FLAG,
1177: XNP_SV_SOA_VL.BLOCKED_FLAG,
1178: XNP_SV_SOA_VL.NUMBER_RETURNED_DUE_DATE,
1179: XNP_SV_SOA_VL.CLASS_ADDRESS,
1180: XNP_SV_SOA_VL.CLASS_SUBSYSTEM,

Line 1177: XNP_SV_SOA_VL.BLOCKED_FLAG,

1173: XNP_SV_SOA_VL.PTO_FLAG,
1174: XNP_SV_SOA_VL.DISCONNECT_DUE_DATE,
1175: XNP_SV_SOA_VL.EFFECTIVE_RELEASE_DUE_DATE,
1176: XNP_SV_SOA_VL.RETAIN_TN_FLAG,
1177: XNP_SV_SOA_VL.BLOCKED_FLAG,
1178: XNP_SV_SOA_VL.NUMBER_RETURNED_DUE_DATE,
1179: XNP_SV_SOA_VL.CLASS_ADDRESS,
1180: XNP_SV_SOA_VL.CLASS_SUBSYSTEM,
1181: XNP_SV_SOA_VL.CNAM_ADDRESS,

Line 1178: XNP_SV_SOA_VL.NUMBER_RETURNED_DUE_DATE,

1174: XNP_SV_SOA_VL.DISCONNECT_DUE_DATE,
1175: XNP_SV_SOA_VL.EFFECTIVE_RELEASE_DUE_DATE,
1176: XNP_SV_SOA_VL.RETAIN_TN_FLAG,
1177: XNP_SV_SOA_VL.BLOCKED_FLAG,
1178: XNP_SV_SOA_VL.NUMBER_RETURNED_DUE_DATE,
1179: XNP_SV_SOA_VL.CLASS_ADDRESS,
1180: XNP_SV_SOA_VL.CLASS_SUBSYSTEM,
1181: XNP_SV_SOA_VL.CNAM_ADDRESS,
1182: XNP_SV_SOA_VL.CNAM_SUBSYSTEM,

Line 1179: XNP_SV_SOA_VL.CLASS_ADDRESS,

1175: XNP_SV_SOA_VL.EFFECTIVE_RELEASE_DUE_DATE,
1176: XNP_SV_SOA_VL.RETAIN_TN_FLAG,
1177: XNP_SV_SOA_VL.BLOCKED_FLAG,
1178: XNP_SV_SOA_VL.NUMBER_RETURNED_DUE_DATE,
1179: XNP_SV_SOA_VL.CLASS_ADDRESS,
1180: XNP_SV_SOA_VL.CLASS_SUBSYSTEM,
1181: XNP_SV_SOA_VL.CNAM_ADDRESS,
1182: XNP_SV_SOA_VL.CNAM_SUBSYSTEM,
1183: XNP_SV_SOA_VL.ISVM_ADDRESS,

Line 1180: XNP_SV_SOA_VL.CLASS_SUBSYSTEM,

1176: XNP_SV_SOA_VL.RETAIN_TN_FLAG,
1177: XNP_SV_SOA_VL.BLOCKED_FLAG,
1178: XNP_SV_SOA_VL.NUMBER_RETURNED_DUE_DATE,
1179: XNP_SV_SOA_VL.CLASS_ADDRESS,
1180: XNP_SV_SOA_VL.CLASS_SUBSYSTEM,
1181: XNP_SV_SOA_VL.CNAM_ADDRESS,
1182: XNP_SV_SOA_VL.CNAM_SUBSYSTEM,
1183: XNP_SV_SOA_VL.ISVM_ADDRESS,
1184: XNP_SV_SOA_VL.ISVM_SUBSYSTEM,

Line 1181: XNP_SV_SOA_VL.CNAM_ADDRESS,

1177: XNP_SV_SOA_VL.BLOCKED_FLAG,
1178: XNP_SV_SOA_VL.NUMBER_RETURNED_DUE_DATE,
1179: XNP_SV_SOA_VL.CLASS_ADDRESS,
1180: XNP_SV_SOA_VL.CLASS_SUBSYSTEM,
1181: XNP_SV_SOA_VL.CNAM_ADDRESS,
1182: XNP_SV_SOA_VL.CNAM_SUBSYSTEM,
1183: XNP_SV_SOA_VL.ISVM_ADDRESS,
1184: XNP_SV_SOA_VL.ISVM_SUBSYSTEM,
1185: XNP_SV_SOA_VL.LIDB_ADDRESS,

Line 1182: XNP_SV_SOA_VL.CNAM_SUBSYSTEM,

1178: XNP_SV_SOA_VL.NUMBER_RETURNED_DUE_DATE,
1179: XNP_SV_SOA_VL.CLASS_ADDRESS,
1180: XNP_SV_SOA_VL.CLASS_SUBSYSTEM,
1181: XNP_SV_SOA_VL.CNAM_ADDRESS,
1182: XNP_SV_SOA_VL.CNAM_SUBSYSTEM,
1183: XNP_SV_SOA_VL.ISVM_ADDRESS,
1184: XNP_SV_SOA_VL.ISVM_SUBSYSTEM,
1185: XNP_SV_SOA_VL.LIDB_ADDRESS,
1186: XNP_SV_SOA_VL.LIDB_SUBSYSTEM,

Line 1183: XNP_SV_SOA_VL.ISVM_ADDRESS,

1179: XNP_SV_SOA_VL.CLASS_ADDRESS,
1180: XNP_SV_SOA_VL.CLASS_SUBSYSTEM,
1181: XNP_SV_SOA_VL.CNAM_ADDRESS,
1182: XNP_SV_SOA_VL.CNAM_SUBSYSTEM,
1183: XNP_SV_SOA_VL.ISVM_ADDRESS,
1184: XNP_SV_SOA_VL.ISVM_SUBSYSTEM,
1185: XNP_SV_SOA_VL.LIDB_ADDRESS,
1186: XNP_SV_SOA_VL.LIDB_SUBSYSTEM,
1187: XNP_SV_SOA_VL.WSMSC_ADDRESS,

Line 1184: XNP_SV_SOA_VL.ISVM_SUBSYSTEM,

1180: XNP_SV_SOA_VL.CLASS_SUBSYSTEM,
1181: XNP_SV_SOA_VL.CNAM_ADDRESS,
1182: XNP_SV_SOA_VL.CNAM_SUBSYSTEM,
1183: XNP_SV_SOA_VL.ISVM_ADDRESS,
1184: XNP_SV_SOA_VL.ISVM_SUBSYSTEM,
1185: XNP_SV_SOA_VL.LIDB_ADDRESS,
1186: XNP_SV_SOA_VL.LIDB_SUBSYSTEM,
1187: XNP_SV_SOA_VL.WSMSC_ADDRESS,
1188: XNP_SV_SOA_VL.WSMSC_SUBSYSTEM,

Line 1185: XNP_SV_SOA_VL.LIDB_ADDRESS,

1181: XNP_SV_SOA_VL.CNAM_ADDRESS,
1182: XNP_SV_SOA_VL.CNAM_SUBSYSTEM,
1183: XNP_SV_SOA_VL.ISVM_ADDRESS,
1184: XNP_SV_SOA_VL.ISVM_SUBSYSTEM,
1185: XNP_SV_SOA_VL.LIDB_ADDRESS,
1186: XNP_SV_SOA_VL.LIDB_SUBSYSTEM,
1187: XNP_SV_SOA_VL.WSMSC_ADDRESS,
1188: XNP_SV_SOA_VL.WSMSC_SUBSYSTEM,
1189: XNP_SV_SOA_VL.RN_ADDRESS,

Line 1186: XNP_SV_SOA_VL.LIDB_SUBSYSTEM,

1182: XNP_SV_SOA_VL.CNAM_SUBSYSTEM,
1183: XNP_SV_SOA_VL.ISVM_ADDRESS,
1184: XNP_SV_SOA_VL.ISVM_SUBSYSTEM,
1185: XNP_SV_SOA_VL.LIDB_ADDRESS,
1186: XNP_SV_SOA_VL.LIDB_SUBSYSTEM,
1187: XNP_SV_SOA_VL.WSMSC_ADDRESS,
1188: XNP_SV_SOA_VL.WSMSC_SUBSYSTEM,
1189: XNP_SV_SOA_VL.RN_ADDRESS,
1190: XNP_SV_SOA_VL.RN_SUBSYSTEM,

Line 1187: XNP_SV_SOA_VL.WSMSC_ADDRESS,

1183: XNP_SV_SOA_VL.ISVM_ADDRESS,
1184: XNP_SV_SOA_VL.ISVM_SUBSYSTEM,
1185: XNP_SV_SOA_VL.LIDB_ADDRESS,
1186: XNP_SV_SOA_VL.LIDB_SUBSYSTEM,
1187: XNP_SV_SOA_VL.WSMSC_ADDRESS,
1188: XNP_SV_SOA_VL.WSMSC_SUBSYSTEM,
1189: XNP_SV_SOA_VL.RN_ADDRESS,
1190: XNP_SV_SOA_VL.RN_SUBSYSTEM,
1191: XNP_SV_SOA_VL.SV_SOA_ID

Line 1188: XNP_SV_SOA_VL.WSMSC_SUBSYSTEM,

1184: XNP_SV_SOA_VL.ISVM_SUBSYSTEM,
1185: XNP_SV_SOA_VL.LIDB_ADDRESS,
1186: XNP_SV_SOA_VL.LIDB_SUBSYSTEM,
1187: XNP_SV_SOA_VL.WSMSC_ADDRESS,
1188: XNP_SV_SOA_VL.WSMSC_SUBSYSTEM,
1189: XNP_SV_SOA_VL.RN_ADDRESS,
1190: XNP_SV_SOA_VL.RN_SUBSYSTEM,
1191: XNP_SV_SOA_VL.SV_SOA_ID
1192: INTO CURR_VAL.PORTING_ID,

Line 1189: XNP_SV_SOA_VL.RN_ADDRESS,

1185: XNP_SV_SOA_VL.LIDB_ADDRESS,
1186: XNP_SV_SOA_VL.LIDB_SUBSYSTEM,
1187: XNP_SV_SOA_VL.WSMSC_ADDRESS,
1188: XNP_SV_SOA_VL.WSMSC_SUBSYSTEM,
1189: XNP_SV_SOA_VL.RN_ADDRESS,
1190: XNP_SV_SOA_VL.RN_SUBSYSTEM,
1191: XNP_SV_SOA_VL.SV_SOA_ID
1192: INTO CURR_VAL.PORTING_ID,
1193: CURR_VAL.SUBSCRIPTION_TYPE,

Line 1190: XNP_SV_SOA_VL.RN_SUBSYSTEM,

1186: XNP_SV_SOA_VL.LIDB_SUBSYSTEM,
1187: XNP_SV_SOA_VL.WSMSC_ADDRESS,
1188: XNP_SV_SOA_VL.WSMSC_SUBSYSTEM,
1189: XNP_SV_SOA_VL.RN_ADDRESS,
1190: XNP_SV_SOA_VL.RN_SUBSYSTEM,
1191: XNP_SV_SOA_VL.SV_SOA_ID
1192: INTO CURR_VAL.PORTING_ID,
1193: CURR_VAL.SUBSCRIPTION_TYPE,
1194: CURR_VAL.SUBSCRIPTION_TN,

Line 1191: XNP_SV_SOA_VL.SV_SOA_ID

1187: XNP_SV_SOA_VL.WSMSC_ADDRESS,
1188: XNP_SV_SOA_VL.WSMSC_SUBSYSTEM,
1189: XNP_SV_SOA_VL.RN_ADDRESS,
1190: XNP_SV_SOA_VL.RN_SUBSYSTEM,
1191: XNP_SV_SOA_VL.SV_SOA_ID
1192: INTO CURR_VAL.PORTING_ID,
1193: CURR_VAL.SUBSCRIPTION_TYPE,
1194: CURR_VAL.SUBSCRIPTION_TN,
1195: CURR_VAL.PRE_SPLIT_SUBSCRIPTION_TN,

Line 1246: FROM XNP_SV_SOA_VL XNP_SV_SOA_VL

1242: CURR_VAL.WSMSC_SUBSYSTEM,
1243: CURR_VAL.RN_ADDRESS,
1244: CURR_VAL.RN_SUBSYSTEM,
1245: CURR_VAL.SV_SOA_ID
1246: FROM XNP_SV_SOA_VL XNP_SV_SOA_VL
1247: WHERE XNP_SV_SOA_VL.SV_SOA_ID = CURR_VAL.SV_SOA_ID
1248: ;
1249:
1250: end if;

Line 1247: WHERE XNP_SV_SOA_VL.SV_SOA_ID = CURR_VAL.SV_SOA_ID

1243: CURR_VAL.RN_ADDRESS,
1244: CURR_VAL.RN_SUBSYSTEM,
1245: CURR_VAL.SV_SOA_ID
1246: FROM XNP_SV_SOA_VL XNP_SV_SOA_VL
1247: WHERE XNP_SV_SOA_VL.SV_SOA_ID = CURR_VAL.SV_SOA_ID
1248: ;
1249:
1250: end if;
1251: