APPS.AMS_DELIVERABLE_PVT dependencies on JTF_AMV_ATTACHMENTS_V

Line 1335: FROM jtf_amv_attachments_v

1331: WHERE deliverable_id = p_deliv_id;
1332:
1333: CURSOR c_jtf_att_count (p_deliv_id IN NUMBER) IS
1334: SELECT count(1)
1335: FROM jtf_amv_attachments_v
1336: WHERE attachment_used_by_id = p_deliv_id
1337: AND attachment_used_by = 'AMS_DELV';
1338:
1339: CURSOR c_jtf_file_rec (p_deliv_id IN NUMBER) IS

Line 1341: FROM jtf_amv_attachments_v

1337: AND attachment_used_by = 'AMS_DELV';
1338:
1339: CURSOR c_jtf_file_rec (p_deliv_id IN NUMBER) IS
1340: SELECT file_id, file_name, attachment_type, version
1341: FROM jtf_amv_attachments_v
1342: WHERE attachment_used_by_id = p_deliv_id
1343: AND attachment_used_by = 'AMS_DELV'
1344: AND creation_date = (
1345: SELECT max(creation_date) FROM jtf_amv_attachments_v

Line 1345: SELECT max(creation_date) FROM jtf_amv_attachments_v

1341: FROM jtf_amv_attachments_v
1342: WHERE attachment_used_by_id = p_deliv_id
1343: AND attachment_used_by = 'AMS_DELV'
1344: AND creation_date = (
1345: SELECT max(creation_date) FROM jtf_amv_attachments_v
1346: WHERE attachment_used_by_id = p_deliv_id
1347: AND attachment_used_by = 'AMS_DELV');
1348:
1349: l_jtf_file_rec c_jtf_file_rec%ROWTYPE;

Line 1354: FROM jtf_amv_attachments_v

1350:
1351:
1352: CURSOR get_attachments_rec (p_deliv_id IN NUMBER, p_itm_id IN NUMBER) IS
1353: SELECT file_id, file_name, attachment_type, version
1354: FROM jtf_amv_attachments_v
1355: WHERE attachment_used_by_id = p_deliv_id
1356: AND attachment_used_by = 'AMS_DELV'
1357: AND file_id NOT IN
1358: ( select file_id

Line 1359: from jtf_amv_attachments_v

1355: WHERE attachment_used_by_id = p_deliv_id
1356: AND attachment_used_by = 'AMS_DELV'
1357: AND file_id NOT IN
1358: ( select file_id
1359: from jtf_amv_attachments_v
1360: where attachment_used_by_id = p_itm_id
1361: and attachment_used_by = 'ITEM' );
1362:
1363: l_attachments_rec get_attachments_rec%ROWTYPE;