APPS.PO_DRAFT_MERGE_PKG dependencies on FND_DOCUMENT_CATEGORIES_VL

Line 1481: FROM fnd_document_categories_vl

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
1480: AND fad.category_id NOT IN (SELECT category_id
1481: FROM fnd_document_categories_vl
1482: WHERE application_id = 201 AND name = 'CUSTOM5340'
1483: );
1484:
1485: --Fetch all new attachments other than mod specific attachments as merge

Line 1495: FROM fnd_document_categories_vl

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
1494: AND fad.category_id NOT IN (SELECT category_id
1495: FROM fnd_document_categories_vl
1496: WHERE application_id = 201 AND name = 'CUSTOM5340'
1497: );
1498:
1499: d_api_name CONSTANT VARCHAR2(30) := 'merge_header_attachments';

Line 1595: FROM fnd_document_categories_vl

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
1593: AND fd.document_id = fad.document_id
1594: AND fad.category_id NOT IN (SELECT category_id
1595: FROM fnd_document_categories_vl
1596: WHERE application_id = 201 AND name = 'CUSTOM5340'
1597: );
1598:
1599: --Fetch all new attachments other than mod specific attachments as merge

Line 1610: FROM fnd_document_categories_vl

1606: and fad.pk1_value = to_char(pld.po_line_id) || '-' || to_char(p_draft_id)
1607: AND ORIG_ATTACH_DOC_ID IS NULL
1608: AND fd.document_id = fad.document_id
1609: AND fad.category_id NOT IN (SELECT category_id
1610: FROM fnd_document_categories_vl
1611: WHERE application_id = 201 AND name = 'CUSTOM5340'
1612: );
1613:
1614: d_api_name CONSTANT VARCHAR2(30) := 'MERGE_LINES_ATTACHMENT';

Line 1710: FROM fnd_document_categories_vl

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
1708: AND fd.document_id = fad.document_id
1709: AND fad.category_id NOT IN (SELECT category_id
1710: FROM fnd_document_categories_vl
1711: WHERE application_id = 201 AND name = 'CUSTOM5340'
1712: );
1713:
1714: --Fetch all new attachments other than mod specific attachments as merge

Line 1725: FROM fnd_document_categories_vl

1721: and fad.pk1_value = to_char(plld.line_location_id) || '-' || to_char(p_draft_id)
1722: AND ORIG_ATTACH_DOC_ID IS NULL
1723: AND fd.document_id = fad.document_id
1724: AND fad.category_id NOT IN (SELECT category_id
1725: FROM fnd_document_categories_vl
1726: WHERE application_id = 201 AND name = 'CUSTOM5340'
1727: );
1728:
1729: d_api_name CONSTANT VARCHAR2(30) := 'MERGE_LINE_LOCATION_ATTACHMENT';