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.CN_TRANSACTION_LOAD_PUB dependencies on CN_ACC_PERIOD_STATUSES_V

Line 1080: TYPE l_period_id_tbl_type IS TABLE OF cn_acc_period_statuses_v.period_id%TYPE;

1076: l_api_version CONSTANT NUMBER := 1.0;
1077:
1078: TYPE l_emp_no_tbl_type IS TABLE OF cn_comm_lines_api.employee_number%TYPE;
1079: TYPE l_srp_id_tbl_type IS TABLE OF cn_comm_lines_api.salesrep_id%TYPE;
1080: TYPE l_period_id_tbl_type IS TABLE OF cn_acc_period_statuses_v.period_id%TYPE;
1081: TYPE l_start_date_tbl_type IS TABLE OF cn_acc_period_statuses_v.start_date%TYPE;
1082: TYPE l_end_date_tbl_type IS TABLE OF cn_acc_period_statuses_v.end_date%TYPE;
1083: TYPE l_count_tbl_type IS TABLE OF NUMBER;
1084:

Line 1081: TYPE l_start_date_tbl_type IS TABLE OF cn_acc_period_statuses_v.start_date%TYPE;

1077:
1078: TYPE l_emp_no_tbl_type IS TABLE OF cn_comm_lines_api.employee_number%TYPE;
1079: TYPE l_srp_id_tbl_type IS TABLE OF cn_comm_lines_api.salesrep_id%TYPE;
1080: TYPE l_period_id_tbl_type IS TABLE OF cn_acc_period_statuses_v.period_id%TYPE;
1081: TYPE l_start_date_tbl_type IS TABLE OF cn_acc_period_statuses_v.start_date%TYPE;
1082: TYPE l_end_date_tbl_type IS TABLE OF cn_acc_period_statuses_v.end_date%TYPE;
1083: TYPE l_count_tbl_type IS TABLE OF NUMBER;
1084:
1085: l_emp_no_tbl l_emp_no_tbl_type;

Line 1082: TYPE l_end_date_tbl_type IS TABLE OF cn_acc_period_statuses_v.end_date%TYPE;

1078: TYPE l_emp_no_tbl_type IS TABLE OF cn_comm_lines_api.employee_number%TYPE;
1079: TYPE l_srp_id_tbl_type IS TABLE OF cn_comm_lines_api.salesrep_id%TYPE;
1080: TYPE l_period_id_tbl_type IS TABLE OF cn_acc_period_statuses_v.period_id%TYPE;
1081: TYPE l_start_date_tbl_type IS TABLE OF cn_acc_period_statuses_v.start_date%TYPE;
1082: TYPE l_end_date_tbl_type IS TABLE OF cn_acc_period_statuses_v.end_date%TYPE;
1083: TYPE l_count_tbl_type IS TABLE OF NUMBER;
1084:
1085: l_emp_no_tbl l_emp_no_tbl_type;
1086: l_srp_id_tbl l_srp_id_tbl_type;

Line 1143: cn_acc_period_statuses_v acc

1139: acc.end_date end_date,
1140: count(*) trx_count
1141: FROM
1142: cn_comm_lines_api_all api,
1143: cn_acc_period_statuses_v acc
1144: WHERE
1145: api.load_status = 'UNLOADED' AND
1146: api.trx_type <> 'FORECAST' AND
1147: (api.adjust_status <> 'SCA_PENDING' ) AND -- OR api.adjust_status IS NULL) AND

Line 1175: cn_acc_period_statuses_v acc

1171: acc.end_date end_date,
1172: count(*) trx_count
1173: FROM
1174: cn_comm_lines_api_all api,
1175: cn_acc_period_statuses_v acc
1176: WHERE
1177: api.load_status = 'UNLOADED' AND
1178: api.trx_type <> 'FORECAST' AND
1179: (adjust_status <> 'SCA_PENDING' ) AND -- OR adjust_status IS NULL) AND