DBA Data[Home] [Help]

APPS.AMV_ITEM_PUB dependencies on JTF_AMV_ATTACHMENTS_V

Line 2749: FROM jtf_amv_attachments_v

2745: ;
2746: CURSOR Check_Itemfile_csr (p_file_id IN VARCHAR2) IS
2747: SELECT
2748: file_id
2749: FROM jtf_amv_attachments_v
2750: WHERE file_id = p_file_id
2751: AND attachment_used_by_id = p_item_id
2752: AND attachment_used_by = G_USED_BY_ITEM;
2753: --

Line 3028: FROM jtf_amv_attachments_v

3024: --
3025: CURSOR Check_Itemfile_csr (p_file_id IN VARCHAR2) IS
3026: SELECT
3027: attachment_id, object_version_number
3028: FROM jtf_amv_attachments_v
3029: WHERE file_id = p_file_id
3030: AND attachment_used_by_id = p_item_id
3031: AND attachment_used_by = G_USED_BY_ITEM;
3032: --

Line 3384: FROM jtf_amv_attachments_v

3380: l_fetch_count NUMBER := 0;
3381: CURSOR Get_File_id_csr IS
3382: SELECT
3383: File_id
3384: FROM jtf_amv_attachments_v
3385: WHERE attachment_used_by_id = p_item_id
3386: AND attachment_used_by = G_USED_BY_ITEM;
3387: --
3388: BEGIN