DBA Data[Home] [Help]

APPS.WSH_DOCUMENT_PVT dependencies on WSH_DOC_SEQUENCE_CATEGORIES

Line 380: wsh_doc_sequence_categories wsh

376: SELECT
377: wsh.category_code,
378: fnd.method_code
379: FROM
380: wsh_doc_sequence_categories wsh
381: , fnd_doc_sequence_assignments fnd
382: WHERE wsh.document_type = p_document_type
383: AND wsh.enabled_flag = 'Y'
384: AND ( (wsh.location_id = p_location_id AND

Line 1000: wsh_doc_sequence_categories.doc_sequence_category_id%type;

996: l_delivery_id_tab delivery_id_tabtype := delivery_id_tabtype();
997: l_table_count NUMBER;
998: l_doc_sequence_id fnd_document_sequences.doc_sequence_id%type;
999: l_doc_sequence_category_id
1000: wsh_doc_sequence_categories.doc_sequence_category_id%type;
1001: l_document_number VARCHAR2(255);
1002: l_seq_return NUMBER;
1003: l_seq_type VARCHAR2(255);
1004: l_entity_name wsh_document_instances.entity_name%type;

Line 1046: wsh_doc_sequence_categories

1042: , prefix
1043: , suffix
1044: , delimiter
1045: FROM
1046: wsh_doc_sequence_categories
1047: WHERE document_type = p_document_type
1048: AND enabled_flag = 'Y'
1049: AND ((location_id = p_location_id AND document_code = p_document_sub_type)
1050: OR