DBA Data[Home] [Help]

APPS.PO_DRAFTS_PVT dependencies on FND_DOCUMENT_CATEGORIES

Line 8216: FROM fnd_document_categories

8212: where fad.entity_name = p_entity_name
8213: and fad.pk1_value = to_char(p_header_id) || '-' || to_char(p_draft_id)
8214: AND fd.document_id = fad.document_id
8215: AND fad.category_id <> (SELECT category_id
8216: FROM fnd_document_categories
8217: WHERE application_id = 201 AND name = 'CUSTOM5340'
8218: );
8219: BEGIN
8220: IF (PO_LOG.d_proc) THEN

Line 8399: FROM fnd_document_categories

8395: where fad.entity_name = p_entity_name
8396: and fad.pk1_value = to_char(p_line_location_id) || '-' || to_char(p_draft_id)
8397: AND fd.document_id = fad.document_id
8398: AND fad.category_id <> (SELECT category_id
8399: FROM fnd_document_categories
8400: WHERE application_id = 201 AND name = 'CUSTOM5340'
8401: );
8402: BEGIN
8403:

Line 8501: FROM fnd_document_categories

8497: where fad.entity_name = p_entity_name
8498: and fad.pk1_value = to_char(p_line_id) || '-' || to_char(p_draft_id)
8499: AND fd.document_id = fad.document_id
8500: AND fad.category_id <> (SELECT category_id
8501: FROM fnd_document_categories
8502: WHERE application_id = 201 AND name = 'CUSTOM5340'
8503: );
8504:
8505: BEGIN

Line 9028: FROM fnd_document_categories_vl

9024: FROM FND_ATTACHED_DOCUMENTS
9025: WHERE entity_name = p_entity_name
9026: AND pk1_value = p_po_header_id||'-'|| p_po_draft_id
9027: AND category_id <> (SELECT category_id
9028: FROM fnd_document_categories_vl
9029: WHERE application_id = 201 AND name = 'CUSTOM5340'
9030: );
9031:
9032: RETURN l_count;