eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on PO_HEADERS_ALL

Line 1193: FROM po_headers_all

1189: FOR i IN 1..p_multi_mod_doc_id_tbl.COUNT LOOP
1190: d_position := 70;
1191: SELECT vendor_contact_id
1192: INTO l_vendor_contact_id
1193: FROM po_headers_all
1194: WHERE po_header_id = p_document_id_tbl(i);
1195:
1196: IF d_stmt THEN
1197: PO_LOG.stmt(d_mod,d_position,'p_document_id_tbl(i)',p_document_id_tbl(i));

Line 2575: FROM po_headers_all_ext_b ext,

2571: NVL(n_ext_attr13,0) + NVL(n_ext_attr14,0) + NVL(n_ext_attr15,0) +
2572: NVL(n_ext_attr16,0) + NVL(n_ext_attr17,0) + NVL(n_ext_attr18,0) +
2573: NVL(n_ext_attr19,0) + NVL(n_ext_attr20,0)),0) attr_sum
2574: INTO l_sum_check
2575: FROM po_headers_all_ext_b ext,
2576: po_multi_mod_requests multimod
2577: WHERE ext.po_header_id = multimod.uda_key_po_header_id
2578: AND ext.draft_id = multimod.uda_key_draft_id
2579: AND multimod.multi_mod_request_id = p_request_id

Line 2777: po_headers_all pha,

2773: SELECT pmmd.document_id, pha.clm_document_number, pd.modification_number
2774: BULK COLLECT INTO l_document_id_tbl, l_document_num_tbl, l_modification_num_tbl
2775: FROM po_entity_locks pel,
2776: po_multi_mod_docs pmmd,
2777: po_headers_all pha,
2778: po_doc_style_headers pdsh,
2779: po_drafts pd
2780: WHERE pmmd.multi_mod_request_id = p_request_id
2781: AND pha.po_header_id = pmmd.document_id

Line 2893: FROM po_headers_all_ext_b ext,

2889: NVL(n_ext_attr19,0) + NVL(n_ext_attr20,0)),0) attr_sum
2890: BULK COLLECT INTO l_document_number_tbl,
2891: l_address_code_tbl, l_modification_number_tbl,
2892: l_sum_check_tbl
2893: FROM po_headers_all_ext_b ext,
2894: po_multi_mod_requests multimod,
2895: po_entity_locks pel,
2896: po_multi_mod_docs pmmd,
2897: po_headers_all pha,

Line 2897: po_headers_all pha,

2893: FROM po_headers_all_ext_b ext,
2894: po_multi_mod_requests multimod,
2895: po_entity_locks pel,
2896: po_multi_mod_docs pmmd,
2897: po_headers_all pha,
2898: po_doc_style_headers pdsh,
2899: po_drafts pd
2900: WHERE ext.po_header_id = multimod.uda_key_po_header_id
2901: AND ext.draft_id = multimod.uda_key_draft_id

Line 2996: po_headers_all pha,

2992: --collect all document_ids which are being updated
2993: SELECT pha.clm_document_number
2994: BULK COLLECT INTO l_document_num_tbl
2995: FROM po_multi_mod_docs pmmd,
2996: po_headers_all pha,
2997: po_doc_style_headers pdsh
2998: WHERE pmmd.multi_mod_request_id = p_request_id
2999: AND pmmd.document_id = pha.po_header_id
3000: AND pha.style_id = pdsh.style_id

Line 3114: po_headers_all ph_a, /current document joined to headers, filtered by BLANKET/CONTRACT/

3110: ,l_document_number_tbl
3111: ,l_related_document_id_tbl
3112: ,l_related_doc_number_tbl
3113: FROM po_multi_mod_docs pmmd_a,/*current set of documents being validated*/
3114: po_headers_all ph_a, /*current document joined to headers, filtered by BLANKET/CONTRACT*/
3115: po_headers_all ph_e /*list of execution documents tied to the agreement*/
3116: WHERE pmmd_a.document_id = ph_a.po_header_id
3117: AND pmmd_a.multi_mod_request_id = p_request_id
3118: AND ph_a.type_lookup_code IN ('BLANKET', 'CONTRACT')

Line 3115: po_headers_all ph_e /list of execution documents tied to the agreement/

3111: ,l_related_document_id_tbl
3112: ,l_related_doc_number_tbl
3113: FROM po_multi_mod_docs pmmd_a,/*current set of documents being validated*/
3114: po_headers_all ph_a, /*current document joined to headers, filtered by BLANKET/CONTRACT*/
3115: po_headers_all ph_e /*list of execution documents tied to the agreement*/
3116: WHERE pmmd_a.document_id = ph_a.po_header_id
3117: AND pmmd_a.multi_mod_request_id = p_request_id
3118: AND ph_a.type_lookup_code IN ('BLANKET', 'CONTRACT')
3119: AND ph_e.clm_source_document_id = ph_a.po_header_id

Line 3199: /*l_clm_document_number PO_HEADERS_ALL.clm_document_number%TYPE;

3195: l_results_count NUMBER;
3196: d_mod CONSTANT VARCHAR2(100) := D_generate_award_exceptions;
3197: d_position NUMBER := 0;
3198: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
3199: /*l_clm_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
3200: l_clm_source_document_id PO_HEADERS_ALL.clm_source_document_id%TYPE;
3201: l_idv_exists VARCHAR2(1) := 'N';
3202: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3203: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;*/

Line 3200: l_clm_source_document_id PO_HEADERS_ALL.clm_source_document_id%TYPE;

3196: d_mod CONSTANT VARCHAR2(100) := D_generate_award_exceptions;
3197: d_position NUMBER := 0;
3198: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
3199: /*l_clm_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
3200: l_clm_source_document_id PO_HEADERS_ALL.clm_source_document_id%TYPE;
3201: l_idv_exists VARCHAR2(1) := 'N';
3202: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3203: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;*/
3204: l_document_id_tbl PO_TBL_NUMBER;

Line 3202: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

3198: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
3199: /*l_clm_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
3200: l_clm_source_document_id PO_HEADERS_ALL.clm_source_document_id%TYPE;
3201: l_idv_exists VARCHAR2(1) := 'N';
3202: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3203: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;*/
3204: l_document_id_tbl PO_TBL_NUMBER;
3205: l_document_number_tbl PO_TBL_VARCHAR50;
3206: l_related_document_id_tbl PO_TBL_NUMBER;

Line 3203: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;*/

3199: /*l_clm_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
3200: l_clm_source_document_id PO_HEADERS_ALL.clm_source_document_id%TYPE;
3201: l_idv_exists VARCHAR2(1) := 'N';
3202: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3203: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;*/
3204: l_document_id_tbl PO_TBL_NUMBER;
3205: l_document_number_tbl PO_TBL_VARCHAR50;
3206: l_related_document_id_tbl PO_TBL_NUMBER;
3207: l_related_doc_number_tbl PO_TBL_VARCHAR50;

Line 3240: po_headers_all ph_e,

3236: ,l_document_number_tbl
3237: ,l_related_document_id_tbl
3238: ,l_related_doc_number_tbl
3239: FROM po_multi_mod_docs pmmd_e,
3240: po_headers_all ph_e,
3241: po_headers_all ph_a
3242: WHERE pmmd_e.multi_mod_request_id = p_request_id
3243: AND ph_e.po_header_id = pmmd_e.document_id
3244: AND ph_e.type_lookup_code = 'STANDARD'

Line 3241: po_headers_all ph_a

3237: ,l_related_document_id_tbl
3238: ,l_related_doc_number_tbl
3239: FROM po_multi_mod_docs pmmd_e,
3240: po_headers_all ph_e,
3241: po_headers_all ph_a
3242: WHERE pmmd_e.multi_mod_request_id = p_request_id
3243: AND ph_e.po_header_id = pmmd_e.document_id
3244: AND ph_e.type_lookup_code = 'STANDARD'
3245: AND ph_e.clm_source_document_id = ph_a.po_header_id