APPS.AMV_MATCH_PVT dependencies on JTF_AMV_ITEMS_B

Line 526: From jtf_amv_items_b

522: content_type_id,
523: application_id,
524: status_code status,
525: expiration_date
526: From jtf_amv_items_b
527: Where item_id = p_item_id;
528: --
529: CURSOR Check_empty_author_csr IS
530: Select 1

Line 999: 'From jtf_amv_items_b item, amv_c_channels_b chan ';

995: --
996: l_sql_statement :=
997: 'Select ' ||
998: 'item.item_id ' ||
999: 'From jtf_amv_items_b item, amv_c_channels_b chan ';
1000: l_where_clause := 'Where chan.channel_id = :channel_id ' ||
1001: 'And item.application_id = ' || l_application_id || ' ' ||
1002: 'And item.status_code = ''ACTIVE'' ' ||
1003: 'And item.item_type != ''MESSAGE_ITEM'' ' ||

Line 1281: From jtf_amv_items_b

1277: CURSOR Get_ItemAndContentTypes_csr IS
1278: Select
1279: content_type_id,
1280: item_type
1281: From jtf_amv_items_b
1282: where item_id = p_item_id;
1283: --
1284: CURSOR Check_ContentType_Match_csr(p_content_type_id IN NUMBER) IS
1285: Select object_version_number

Line 1530: 'From jtf_amv_items_b item, amv_c_channels_b chan ';

1526: END IF;
1527: END IF;
1528: --
1529: l_sql_statement := 'Select 1 ' ||
1530: 'From jtf_amv_items_b item, amv_c_channels_b chan ';
1531: l_where_clause := 'Where item.item_id = :item_id ' ||
1532: 'And chan.channel_id = :channel_id ';
1533: IF (p_match_on_author_flag = FND_API.G_TRUE) THEN
1534: l_where_clause := l_where_clause ||

Line 1690: from jtf_amv_items_b

1686: from dual;
1687: --
1688: CURSOR Get_Resourceid_csr IS
1689: select owner_id
1690: from jtf_amv_items_b
1691: where item_id = p_item_id;
1692: --
1693: BEGIN
1694: SAVEPOINT Do_ItemChannelMatch_Pvt;