APPS.AMS_DELIVERABLE_PVT dependencies on JTF_AMV_ATTACHMENTS_V

Line 1322: FROM jtf_amv_attachments_v

1318: WHERE deliverable_id = p_deliv_id;
1319:
1320: CURSOR c_jtf_att_count (p_deliv_id IN NUMBER) IS
1321: SELECT count(1)
1322: FROM jtf_amv_attachments_v
1323: WHERE attachment_used_by_id = p_deliv_id
1324: AND attachment_used_by = 'AMS_DELV';
1325:
1326: CURSOR c_jtf_file_rec (p_deliv_id IN NUMBER) IS

Line 1328: FROM jtf_amv_attachments_v

1324: AND attachment_used_by = 'AMS_DELV';
1325:
1326: CURSOR c_jtf_file_rec (p_deliv_id IN NUMBER) IS
1327: SELECT file_id, file_name, attachment_type, version
1328: FROM jtf_amv_attachments_v
1329: WHERE attachment_used_by_id = p_deliv_id
1330: AND attachment_used_by = 'AMS_DELV'
1331: AND creation_date = (
1332: SELECT max(creation_date) FROM jtf_amv_attachments_v

Line 1332: SELECT max(creation_date) FROM jtf_amv_attachments_v

1328: FROM jtf_amv_attachments_v
1329: WHERE attachment_used_by_id = p_deliv_id
1330: AND attachment_used_by = 'AMS_DELV'
1331: AND creation_date = (
1332: SELECT max(creation_date) FROM jtf_amv_attachments_v
1333: WHERE attachment_used_by_id = p_deliv_id
1334: AND attachment_used_by = 'AMS_DELV');
1335:
1336: l_jtf_file_rec c_jtf_file_rec%ROWTYPE;

Line 1341: FROM jtf_amv_attachments_v

1337:
1338:
1339: CURSOR get_attachments_rec (p_deliv_id IN NUMBER, p_itm_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 file_id NOT IN
1345: ( select file_id

Line 1346: from jtf_amv_attachments_v

1342: WHERE attachment_used_by_id = p_deliv_id
1343: AND attachment_used_by = 'AMS_DELV'
1344: AND file_id NOT IN
1345: ( select file_id
1346: from jtf_amv_attachments_v
1347: where attachment_used_by_id = p_itm_id
1348: and attachment_used_by = 'ITEM' );
1349:
1350: l_attachments_rec get_attachments_rec%ROWTYPE;