DBA Data[Home] [Help]

APPS.JTF_FM_OCM_REND_REQ dependencies on IBC_CITEM_VERSIONS_B

Line 327: FROM ibc_citem_versions_b

323: CURSOR get_file_query2_c is
324: SELECT attachment_file_id
325: FROM ibc_citem_versions_vl a,
326: (SELECT MAX(version_number) version_number
327: FROM ibc_citem_versions_b
328: WHERE content_item_id=p_citem_id) b
329: WHERE
330: a.content_item_id = p_citem_id AND
331: a.version_number = b.version_number;

Line 382: -- FROM ibc_citem_versions_b

378:
379: -- SELECT attachment_file_id INTO file_id
380: -- FROM ibc_citem_versions_vl a,
381: -- (SELECT MAX(version_number) version_number
382: -- FROM ibc_citem_versions_b
383: -- WHERE content_item_id=p_citem_id) b
384: -- WHERE
385: -- a.content_item_id = p_citem_id AND
386: -- a.version_number = b.version_number;