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.PN_SOI_VOL_IMPORT dependencies on FND_DATE

Line 1174: AND ((fnd_DATE.canonical_to_DATE(p_start_DATE) IS NOT NULL

1170: batch_name,
1171: status
1172: FROM pn_vol_hist_batch_itf
1173: WHERE ((p_batch_id IS NOT NULL AND batch_id = p_batch_id) OR (p_batch_id IS NULL))
1174: AND ((fnd_DATE.canonical_to_DATE(p_start_DATE) IS NOT NULL
1175: AND min_rep_DATE >= fnd_DATE.canonical_to_DATE(p_start_DATE))
1176: OR (p_start_DATE IS NULL))
1177: AND ((fnd_DATE.canonical_to_DATE(p_end_DATE) IS NOT NULL
1178: AND max_rep_DATE <= fnd_DATE.canonical_to_DATE(p_end_DATE))

Line 1175: AND min_rep_DATE >= fnd_DATE.canonical_to_DATE(p_start_DATE))

1171: status
1172: FROM pn_vol_hist_batch_itf
1173: WHERE ((p_batch_id IS NOT NULL AND batch_id = p_batch_id) OR (p_batch_id IS NULL))
1174: AND ((fnd_DATE.canonical_to_DATE(p_start_DATE) IS NOT NULL
1175: AND min_rep_DATE >= fnd_DATE.canonical_to_DATE(p_start_DATE))
1176: OR (p_start_DATE IS NULL))
1177: AND ((fnd_DATE.canonical_to_DATE(p_end_DATE) IS NOT NULL
1178: AND max_rep_DATE <= fnd_DATE.canonical_to_DATE(p_end_DATE))
1179: OR (p_end_DATE IS NULL))

Line 1177: AND ((fnd_DATE.canonical_to_DATE(p_end_DATE) IS NOT NULL

1173: WHERE ((p_batch_id IS NOT NULL AND batch_id = p_batch_id) OR (p_batch_id IS NULL))
1174: AND ((fnd_DATE.canonical_to_DATE(p_start_DATE) IS NOT NULL
1175: AND min_rep_DATE >= fnd_DATE.canonical_to_DATE(p_start_DATE))
1176: OR (p_start_DATE IS NULL))
1177: AND ((fnd_DATE.canonical_to_DATE(p_end_DATE) IS NOT NULL
1178: AND max_rep_DATE <= fnd_DATE.canonical_to_DATE(p_end_DATE))
1179: OR (p_end_DATE IS NULL))
1180: AND status IN ('I','E');
1181:

Line 1178: AND max_rep_DATE <= fnd_DATE.canonical_to_DATE(p_end_DATE))

1174: AND ((fnd_DATE.canonical_to_DATE(p_start_DATE) IS NOT NULL
1175: AND min_rep_DATE >= fnd_DATE.canonical_to_DATE(p_start_DATE))
1176: OR (p_start_DATE IS NULL))
1177: AND ((fnd_DATE.canonical_to_DATE(p_end_DATE) IS NOT NULL
1178: AND max_rep_DATE <= fnd_DATE.canonical_to_DATE(p_end_DATE))
1179: OR (p_end_DATE IS NULL))
1180: AND status IN ('I','E');
1181:
1182: l_total NUMBER := 0 ;