DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_POSTPROC_PVT dependencies on FND_DOCUMENTS_TL

Line 1582: FROM fnd_attached_documents fad, fnd_documents_tl fdt

1578: -- the PO_LINES entity by it's unique iP identifier prefix
1579: --SQL Why: Need the attached_document_id to move the attachment
1580: SELECT fad.attached_document_id
1581: INTO l_one_time_att_doc_id
1582: FROM fnd_attached_documents fad, fnd_documents_tl fdt
1583: WHERE fad.entity_name = 'PO_LINES'
1584: AND fad.pk1_value = TO_CHAR (line_rec.po_line_id)
1585: AND fad.document_id = fdt.document_id
1586: AND fdt.LANGUAGE = USERENV ('LANG')