DBA Data[Home] [Help]

APPS.POR_ITEM_ATTRIBUTES_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 143: FROM fnd_attached_documents

139: l_seq_num := 0;
140:
141: SELECT NVL(MAX(seq_num), 0)
142: INTO l_seq_num
143: FROM fnd_attached_documents
144: WHERE pk1_value = to_char(l_requisition_line_id)
145: AND entity_name = 'REQ_LINES';
146:
147: l_seq_num := l_seq_num + 10;

Line 180: from fnd_attached_documents

176: begin
177:
178: select attached_document_id
179: into l_attachment_id
180: from fnd_attached_documents
181: where pk1_value=to_char(l_requisition_line_id)
182: and pk2_value='ONE_TIME_LOCATION';
183:
184: -- prefix document_description with POR: for autocreate to identifer