DBA Data[Home] [Help]

APPS.MSC_SDA_UTILS dependencies on MSC_USER_NOTES

Line 1194: from msc_user_notes mun,

1190: select distinct mun.note_id,
1191: nvl(mun.last_update_date, mun.creation_date) comment_date,
1192: msc_get_name.item_name(mun.inventory_item_id, null, null, null) item_name,
1193: substr(mun.note_text1,1,80) comment_text
1194: from msc_user_notes mun,
1195: msc_form_query mfq
1196: where
1197: mun.entity_type = c_comment_entity_type
1198: and mun.inventory_item_id in (mfq.number1, number2)

Line 2034: l_entity_name varchar2(40) := 'MSC_USER_NOTES';

2030: p_pk_value2 number default null,
2031: p_pk_value3 number default null,
2032: p_pk_value4 number default null,
2033: p_pk_value5 number default null) is
2034: l_entity_name varchar2(40) := 'MSC_USER_NOTES';
2035:
2036: cursor c_note_flag is
2037: select count(*)
2038: from msc_doc_attachments