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_EDA_DATATEMPLATE_PKG dependencies on PO_HEADERS_MERGE_V

Line 983: FROM po_headers_merge_v poh, po_lines_merge_v pol , po_line_locations_merge_v ploc

979: SELECT CASE WHEN poh.start_date IS NULL AND poh.end_date IS NULL AND Min(CLM_PERIOD_PERF_START_DATE) IS NULL AND
980: Max(CLM_PERIOD_PERF_END_DATE) IS NULL THEN 'Delivery Requested By' ELSE NULL END DeliveryDescription,
981: to_char(CASE WHEN poh.start_date IS NULL AND poh.end_date IS NULL AND Min(CLM_PERIOD_PERF_START_DATE) IS NULL AND
982: Max(CLM_PERIOD_PERF_END_DATE) IS NULL THEN ploc.NEED_BY_DATE ELSE NULL END,'CCYY-MM-DD') DateElement
983: FROM po_headers_merge_v poh, po_lines_merge_v pol , po_line_locations_merge_v ploc
984: WHERE
985: ( ( (isMod = 'N') AND (poh.po_header_id = DOCUMENTID AND poh.draft_id = -1 AND poh.change_status is NULL)) OR
986: ( (isMod = 'Y') AND (poh.draft_id = DRAFTID AND poh.change_status IS NOT NULL)) )
987: AND

Line 1000: FROM po_headers_merge_v poh

996:
997:
998: CURSOR c_getpaymentdisc(isMod varchar2) IS
999: WITH q_termid AS(SELECT poh.terms_id v_term
1000: FROM po_headers_merge_v poh
1001: WHERE
1002: ( ( (isMod = 'N') AND (poh.po_header_id = DOCUMENTID AND poh.draft_id = -1 AND poh.change_status is NULL)) OR
1003: ( (isMod = 'Y') AND (poh.draft_id = DRAFTID AND poh.change_status IS NOT NULL)) )
1004: ),

Line 1015: FROM po_headers_merge_v poh, ap_terms_lines t

1011: (SELECT Percent,DaysDue FROM q_discount3)
1012: ) SELECT Percent,DaysDue,NetDays FROM q_discount,q_netdays;
1013:
1014: /*SELECT t.DUE_PERCENT Percent, t.DUE_DAYS DaysDue, (SYSDATE - t.DUE_DAYS) NetDays
1015: FROM po_headers_merge_v poh, ap_terms_lines t
1016: WHERE poh.terms_id = t.term_id
1017: and ( ( (isMod = 'N') AND (poh.po_header_id = DOCUMENTID AND poh.draft_id = -1 AND poh.change_status is NULL)) OR
1018: ( (isMod = 'Y') AND (poh.draft_id = DRAFTID AND poh.change_status IS NOT NULL)) );*/
1019:

Line 2327: FROM po_lines_merge_v pline, po_headers_merge_v phdr

2323: p_attr_grp_int_name =>
2324: 'AMT_'||Decode(pline.contract_type,'AWARD_FEE','AF','COST_PLUS_AWARD_FEE','CPAF')||'_'
2325: ||Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
2326: p_attr_int_name => 'AWARD_FEE'))
2327: FROM po_lines_merge_v pline, po_headers_merge_v phdr
2328: WHERE
2329: ( ( (isMod = 'N') AND (phdr.po_header_id = DOCUMENTID AND phdr.draft_id = -1 AND phdr.change_status is NULL)) OR
2330: ( (isMod = 'Y') AND (phdr.draft_id = DRAFTID AND phdr.change_status is not null) ) )
2331: and

Line 2343: FROM po_lines_merge_v pline, po_headers_merge_v phdr

2339: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,
2340: p_attr_grp_int_name =>
2341: 'AMT_CPAF_'||Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
2342: p_attr_int_name => 'BASE_FEE'))
2343: FROM po_lines_merge_v pline, po_headers_merge_v phdr
2344: WHERE
2345: ( ( (isMod = 'N') AND (phdr.po_header_id = DOCUMENTID AND phdr.draft_id = -1 AND phdr.change_status is NULL)) OR
2346: ( (isMod = 'Y') AND (phdr.draft_id = DRAFTID AND phdr.change_status is not null) ) )
2347: and

Line 2360: FROM po_lines_merge_v pline, po_headers_merge_v phdr

2356: pk2_value => -1,p_attr_grp_int_name => 'AMT_'||
2357: Decode(pline.contract_type,'FP_INCENTIVE_SUCCESSIVE_TARGET','FIST','FP_INCENTIVE_FIRM_TARGET','FIFT')
2358: ||'_'||Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
2359: p_attr_int_name => 'CEILING_PRICE'))
2360: FROM po_lines_merge_v pline, po_headers_merge_v phdr
2361: WHERE
2362: ( ( (isMod = 'N') AND (phdr.po_header_id = DOCUMENTID AND phdr.draft_id = -1 AND phdr.change_status is NULL)) OR
2363: ( (isMod = 'Y') AND (phdr.draft_id = DRAFTID AND phdr.change_status is not null) ) )
2364: and

Line 2376: FROM po_lines_merge_v pline, po_headers_merge_v phdr

2372: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,
2373: p_attr_grp_int_name => 'AMT_'|| Decode(pline.contract_type,'COST_PLUS_FIXED_FEE','CPFF','COST_PLUS_AWARD_FEE','CPAF')||'_'||
2374: Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
2375: p_attr_int_name => 'ESTIMATED_COST'))
2376: FROM po_lines_merge_v pline, po_headers_merge_v phdr
2377: WHERE
2378: ( ( (isMod = 'N') AND (phdr.po_header_id = DOCUMENTID AND phdr.draft_id = -1 AND phdr.change_status is NULL)) OR
2379: ( (isMod = 'Y') AND (phdr.draft_id = DRAFTID AND phdr.change_status is not null) ))
2380: and

Line 2392: FROM po_lines_merge_v pline, po_headers_merge_v phdr

2388: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,
2389: p_attr_grp_int_name => 'AMT_CPFF_'||
2390: Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
2391: p_attr_int_name => 'FIXED_FEE'))
2392: FROM po_lines_merge_v pline, po_headers_merge_v phdr
2393: WHERE
2394: ( ( (isMod = 'N') AND (phdr.po_header_id = DOCUMENTID AND phdr.draft_id = -1 AND phdr.change_status is NULL)) OR
2395: ( (isMod = 'Y') AND (phdr.draft_id = DRAFTID AND phdr.change_status is not null) ) )
2396: and

Line 2409: FROM po_lines_merge_v pline, po_headers_merge_v phdr

2405: p_attr_grp_int_name => 'AMT_'||Decode(pline.contract_type,'COST_PLUS_INCENTIVE_FEE','CPIF',
2406: 'FP_INCENTIVE_FIRM_TARGET','FIFT','FP_INCENTIVE_SUCCESSIVE_TARGET','FIST')
2407: ||'_'||Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
2408: p_attr_int_name => 'TARGET_COST'))
2409: FROM po_lines_merge_v pline, po_headers_merge_v phdr
2410: WHERE
2411: ( ( (isMod = 'N') AND (phdr.po_header_id = DOCUMENTID AND phdr.draft_id = -1 AND phdr.change_status is NULL)) OR
2412: ( (isMod = 'Y') AND (phdr.draft_id = DRAFTID AND phdr.change_status is not null) ) )
2413: and

Line 2597: FROM po_headers_merge_v where po_header_id = DOCUMENTID AND CURRENCY_CODE IS NOT NULL;

2593: l_return CLOB;
2594: BEGIN
2595: select CURRENCY_CODE,RATE
2596: INTO l_currency , l_exchange
2597: FROM po_headers_merge_v where po_header_id = DOCUMENTID AND CURRENCY_CODE IS NOT NULL;
2598:
2599: if l_exchange is not null then
2600: l_return := to_clob(''||l_currency||
2601: ''||l_currency||'');

Line 2756: FROM po_headers_merge_v WHERE

2752: BEGIN
2753:
2754: SELECT CLM_CLOSEOUT_STATUS
2755: INTO v_closeout_indicator
2756: FROM po_headers_merge_v WHERE
2757: PO_HEADER_ID = DOCUMENTID AND
2758: DRAFT_ID = DRAFTID;
2759:
2760: SELECT A.ATTRVAL

Line 2778: FROM po_headers_merge_v WHERE

2774: ELSIF v_mod_authority = 'SUPPLEMENTAL_AGREE_PURSUANT' THEN
2775:
2776: SELECT USER_DOCUMENT_STATUS
2777: INTO v_cancel_indicator
2778: FROM po_headers_merge_v WHERE
2779: po_header_id = DOCUMENTID AND draft_id = DRAFTID;
2780:
2781: IF v_cancel_indicator IS NULL THEN
2782:

Line 2870: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

2866: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2867: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2868: ' '),
2869: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2870: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2871: WHERE
2872: poh.draft_id = p_draftid AND poh.change_status IS NOT NULL
2873: AND kartb.sav_sae_id = art.article_id
2874: AND kartb.article_version_id = ver.article_version_id

Line 2887: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

2883: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2884: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2885: ' '),
2886: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2887: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2888: WHERE
2889: poh.po_header_id = p_docid AND poh.draft_id = -1 AND poh.change_status is NULL
2890: AND kartb.sav_sae_id = art.article_id
2891: AND kartb.article_version_id = ver.article_version_id

Line 2905: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

2901: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2902: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2903: ' '),
2904: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2905: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2906: WHERE
2907: poh.po_header_id = p_docid AND poh.draft_id = -1 AND poh.change_status is NULL
2908: AND kartb.sav_sae_id = art.article_id
2909: AND kartb.article_version_id = ver.article_version_id

Line 2922: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

2918: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2919: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2920: ' '),
2921: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2922: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2923: WHERE
2924: poh.draft_id = p_draftid AND poh.change_status IS NOT NULL
2925: AND kartb.sav_sae_id = art.article_id
2926: AND kartb.article_version_id = ver.article_version_id