APPS.PO_DRAFT_MERGE_PKG dependencies on FND_DOCUMENTS

Line 1475: from fnd_attached_documents fad , fnd_documents fd

1471: p_draft_id NUMBER) AS
1472:
1473: cursor modified_header_attachments_c(p_header_id NUMBER,p_draft_id NUMBER,p_entity_name VARCHAR2) is
1474: select fad.ORIG_ATTACH_DOC_ID , fd.datatype_id ,fad.attached_document_id
1475: from fnd_attached_documents fad , fnd_documents fd
1476: where fad.entity_name = p_entity_name
1477: and fad.pk1_value = to_char(p_header_id) || '-' || to_char(p_draft_id)
1478: AND fad.ORIG_ATTACH_DOC_ID IS NOT NULL
1479: AND fd.document_id = fad.document_id

Line 1489: from fnd_attached_documents fad , fnd_documents fd

1485: --Fetch all new attachments other than mod specific attachments as merge
1486: -- is not needed for these attachmnets
1487: cursor headers_with_new_attachments_c(p_header_id NUMBER,p_draft_id NUMBER) is
1488: select fad.attached_document_id, fd.datatype_id , fad.ORIG_ATTACH_DOC_ID
1489: from fnd_attached_documents fad , fnd_documents fd
1490: where fad.entity_name = 'PO_HEADERS'
1491: and fad.pk1_value = to_char(p_header_id) || '-' || to_char(p_draft_id)
1492: AND fad.ORIG_ATTACH_DOC_ID IS NULL
1493: AND fd.document_id = fad.document_id

Line 1588: from fnd_attached_documents fad, po_lines_draft_all pld , fnd_documents fd

1584: procedure MERGE_LINE_ATTACHMENTS(p_draft_id NUMBER) AS
1585:
1586: cursor modified_line_attachments_c(p_draft_id NUMBER,p_entity_name VARCHAR2) is
1587: select pld.po_line_id as po_line_id, fad.attached_document_id , fad.ORIG_ATTACH_DOC_ID ,fd.datatype_id
1588: from fnd_attached_documents fad, po_lines_draft_all pld , fnd_documents fd
1589: where pld.draft_id = p_draft_id
1590: and fad.entity_name = p_entity_name
1591: and fad.pk1_value = to_char(pld.po_line_id) || '-' || to_char(p_draft_id)
1592: AND ORIG_ATTACH_DOC_ID IS NOT NULL

Line 1603: from fnd_attached_documents fad, po_lines_draft_all pld , fnd_documents fd

1599: --Fetch all new attachments other than mod specific attachments as merge
1600: -- is not needed for these attachmnets
1601: cursor new_line_attachments_c(p_draft_id NUMBER) is
1602: select pld.po_line_id as po_line_id, fad.attached_document_id , fad.ORIG_ATTACH_DOC_ID ,fd.datatype_id
1603: from fnd_attached_documents fad, po_lines_draft_all pld , fnd_documents fd
1604: where pld.draft_id = p_draft_id
1605: and fad.entity_name = 'PO_LINES'
1606: and fad.pk1_value = to_char(pld.po_line_id) || '-' || to_char(p_draft_id)
1607: AND ORIG_ATTACH_DOC_ID IS NULL

Line 1703: from fnd_attached_documents fad, po_line_locations_draft_all plld , fnd_documents fd

1699: procedure MERGE_LINE_LOCATION_ATTACHMENT(p_draft_id NUMBER) AS
1700:
1701: cursor modified_line_loc_attachment_c(p_draft_id NUMBER,p_entity_name VARCHAR2) is
1702: select plld.line_location_id as line_location_id, fad.attached_document_id , fad.ORIG_ATTACH_DOC_ID ,fd.datatype_id
1703: from fnd_attached_documents fad, po_line_locations_draft_all plld , fnd_documents fd
1704: where plld.draft_id = p_draft_id
1705: and fad.entity_name = p_entity_name
1706: and fad.pk1_value = to_char(plld.line_location_id) || '-' || to_char(p_draft_id)
1707: AND ORIG_ATTACH_DOC_ID IS NOT NULL

Line 1718: from fnd_attached_documents fad, po_line_locations_draft_all plld , fnd_documents fd

1714: --Fetch all new attachments other than mod specific attachments as merge
1715: -- is not needed for these attachmnets
1716: cursor new_line_loc_attachment_c(p_draft_id NUMBER) is
1717: select plld.line_location_id as line_location_id, fad.attached_document_id , fad.ORIG_ATTACH_DOC_ID ,fd.datatype_id
1718: from fnd_attached_documents fad, po_line_locations_draft_all plld , fnd_documents fd
1719: where plld.draft_id = p_draft_id
1720: and fad.entity_name = 'PO_SHIPMENTS'
1721: and fad.pk1_value = to_char(plld.line_location_id) || '-' || to_char(p_draft_id)
1722: AND ORIG_ATTACH_DOC_ID IS NULL