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_LINES_MERGE_V

Line 177: FROM po_lines_merge_v pol

173:
174: function get_AwardFee(ismod varchar2) return VARCHAR2 IS
175: CURSOR c IS
176: SELECT 'true'
177: FROM po_lines_merge_v pol
178: WHERE
179: ( ( (isMod = 'N') AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1 AND pol.change_status is NULL)) OR
180: ( (isMod = 'Y') AND (pol.draft_id = DRAFTID AND pol.change_status IS NOT NULL)) )
181: AND CONTRACT_TYPE IN ('COST_PLUS_AWARD_FEE','FP_AWARD_FEE') ;

Line 195: FROM po_lines_merge_v pol

191:
192: function get_PerformanceIncentive(ismod varchar2) return VARCHAR2 IS
193: CURSOR c IS
194: SELECT 'true'
195: FROM po_lines_merge_v pol
196: WHERE
197: ( ( (isMod = 'N') AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1 AND pol.change_status is NULL)) OR
198: ( (isMod = 'Y') AND (pol.draft_id = DOCUMENTID AND pol.change_status IS NOT NULL)) )
199: AND CONTRACT_TYPE IN ('COST_PLUS_INCENTIVE_FEE','FP_INCENTIVE_SUCCESSIVE_TARGET','FP_INCENTIVE_FIRM_TARGET') ;

Line 458: WHERE POTU.TEMPLATE_ID IN (SELECT DISTINCT UDA_TEMPLATE_ID FROM PO_LINES_MERGE_V WHERE PO_HEADER_ID = DOCUMENTID AND

454: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
455: AG.MULTI_ROW MULTI_ROW
456: FROM EGO_FND_DSC_FLX_CTX_EXT AG,
457: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
458: WHERE POTU.TEMPLATE_ID IN (SELECT DISTINCT UDA_TEMPLATE_ID FROM PO_LINES_MERGE_V WHERE PO_HEADER_ID = DOCUMENTID AND
459: DRAFT_ID=DRAFTID)
460: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
461: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
462: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID

Line 489: FROM po_lines_merge_v

485:
486:
487: CURSOR c_line IS
488: SELECT po_line_id
489: FROM po_lines_merge_v
490: WHERE draft_id = DRAFTID
491: and po_header_id = DOCUMENTID;
492:
493: p_draft_id NUMBER := DRAFTID;

Line 562: FROM po_lines_merge_v pol , po_line_locations_merge_v poll

558:
559:
560: CURSOR C_LINE_LOC IS
561: SELECT poll.LINE_LOCATION_ID
562: FROM po_lines_merge_v pol , po_line_locations_merge_v poll
563: WHERE pol.po_header_id = DOCUMENTID
564: AND poll.po_header_id = DOCUMENTID
565: AND pol.DRAFT_ID = DRAFTID
566: AND poll.DRAFT_ID = pol.DRAFT_ID

Line 787: FROM po_lines_merge_v pol

783: CURSOR c IS
784:
785: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => po_line_id, pk2_value => DRAFTID,
786: p_attr_grp_int_name => 'AMT_CS_IIQ', p_attr_int_name => 'GOVT_SHARE_PER'))
787: FROM po_lines_merge_v pol
788: WHERE
789: ( ( (isMod = 'N') AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1 AND pol.change_status is NULL)) OR
790: ( (isMod = 'Y') AND (pol.draft_id = DRAFTID AND pol.change_status IS NOT NULL)) );
791:

Line 810: FROM po_lines_merge_v pol

806: CURSOR c IS
807:
808: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => po_line_id, pk2_value => DRAFTID,
809: p_attr_grp_int_name => 'AMT_CS_IIQ', p_attr_int_name => 'GOVT_SH_AMOUNT'))
810: FROM po_lines_merge_v pol
811: WHERE
812: ( ( (isMod = 'N') AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1 AND pol.change_status is NULL)) OR
813: ( (isMod = 'Y') AND (pol.draft_id = DRAFTID AND pol.change_status IS NOT NULL)) );
814:

Line 835: FROM po_lines_merge_v pol

831: CURSOR c IS
832:
833: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => po_line_id, pk2_value => DRAFTID,
834: p_attr_grp_int_name => 'AMT_CS_IIQ', p_attr_int_name => 'CONT_SH_AMOUNT'))
835: FROM po_lines_merge_v pol
836: WHERE
837: ( ( (isMod = 'N') AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1 AND pol.change_status is NULL)) OR
838: ( (isMod = 'Y') AND (pol.draft_id = DRAFTID AND pol.change_status IS NOT NULL)) );
839:

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 1244: SELECT distinct contract_type FROM po_lines_merge_v

1240: from (
1241: SELECT CASE
1242: WHEN cnt = 1 THEN
1243: (
1244: SELECT distinct contract_type FROM po_lines_merge_v
1245: WHERE po_header_id = DOCUMENTID AND draft_id = -1 AND change_status is NULL and contract_type is not null
1246: )
1247: ELSE 'FFP'
1248: END AS contract_type FROM (

Line 1249: SELECT Count(distinct contract_type) AS cnt FROM po_lines_merge_v

1245: WHERE po_header_id = DOCUMENTID AND draft_id = -1 AND change_status is NULL and contract_type is not null
1246: )
1247: ELSE 'FFP'
1248: END AS contract_type FROM (
1249: SELECT Count(distinct contract_type) AS cnt FROM po_lines_merge_v
1250: WHERE po_header_id = DOCUMENTID AND draft_id = -1 AND change_status is NULL AND contract_type is not null )
1251: );
1252:
1253: l_mod1 := po_eda_datatemplate_pkg.get_AwardFee('Y');

Line 1261: SELECT distinct contract_type FROM po_lines_merge_v

1257: from (
1258: SELECT CASE
1259: WHEN cnt = 1 THEN
1260: (
1261: SELECT distinct contract_type FROM po_lines_merge_v
1262: WHERE po_header_id = DOCUMENTID AND draft_id = DRAFTID AND change_status is NOT NULL and contract_type is not null
1263: )
1264: ELSE 'FFP'
1265: END AS contract_type FROM (

Line 1266: SELECT Count(distinct contract_type) AS cnt FROM po_lines_merge_v

1262: WHERE po_header_id = DOCUMENTID AND draft_id = DRAFTID AND change_status is NOT NULL and contract_type is not null
1263: )
1264: ELSE 'FFP'
1265: END AS contract_type FROM (
1266: SELECT Count(distinct contract_type) AS cnt FROM po_lines_merge_v
1267: WHERE po_header_id = DOCUMENTID AND draft_id = DRAFTID AND change_status is NOT NULL AND contract_type is not null )
1268: );
1269:
1270: IF l_prev1 IS NULL AND l_mod1 IS NOT NULL THEN l_chg1:= 'Added'; l_chgtxt1:= 'Award Fee Value '||l_mod1||' added';

Line 2300: po_lines_merge_v pol

2296: FUNCTION getOtherAmounts(isMod varchar2, p_amt_type varchar2) RETURN number is
2297: cursor c_amount is
2298: select sum(LIST_PRICE_PER_UNIT * QUANTITY )
2299: FROM
2300: po_lines_merge_v pol
2301: WHERE ( ( (isMod = 'N') AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1 AND pol.change_status is NULL)) OR
2302: ( (isMod = 'Y') AND (pol.draft_id = DRAFTID AND pol.change_status IS NOT NULL)) )
2303: and nvl(CLM_EXERCISED_FLAG,'N') = 'N'
2304: and CONTRACT_TYPE = 'FFP';

Line 2309: po_lines_merge_v pol

2305:
2306: cursor c_amount2 is
2307: select sum(LIST_PRICE_PER_UNIT)
2308: FROM
2309: po_lines_merge_v pol
2310: WHERE ( ( (isMod = 'N') AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1 AND pol.change_status is NULL)) OR
2311: ( (isMod = 'Y') AND (pol.draft_id = DRAFTID AND pol.change_status IS NOT NULL)) )
2312: and nvl(CLM_EXERCISED_FLAG,'N') = 'N';
2313:

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 2630: ' FROM pon_form_field_values WHERE OWNING_ENTITY_CODE = ''PON_AUCTION_HEADERS_ALL'' AND ENTITY_PK1 IN (SELECT DISTINCT AUCTION_HEADER_ID FROM po_lines_merge_v WHERE po_header_id = '

2626: (SELECT FORM_ID FROM PON_FORMS_SECTIONS WHERE FORM_CODE = 'FED_PRESOL' AND STATUS = 'ACTIVE')
2627: AND field_code = 'FED_DESC';
2628:
2629: l_sql_query :='SELECT '|| l_col_name ||
2630: ' FROM pon_form_field_values WHERE OWNING_ENTITY_CODE = ''PON_AUCTION_HEADERS_ALL'' AND ENTITY_PK1 IN (SELECT DISTINCT AUCTION_HEADER_ID FROM po_lines_merge_v WHERE po_header_id = '
2631: || DOCUMENTID ||'AND draft_id = '||
2632: DRAFTID ||') AND FORM_ID = (SELECT FORM_ID FROM PON_FORMS_SECTIONS WHERE FORM_CODE = ''FED_PRESOL'' AND STATUS = ''ACTIVE'') ';
2633:
2634: open c_addr for l_sql_query;

Line 2787: FROM po_lines_merge_v

2783: SELECT USER_DOCUMENT_STATUS
2784: INTO v_cancel_indicator
2785: FROM (
2786: SELECT USER_DOCUMENT_STATUS, Count(USER_DOCUMENT_STATUS)
2787: FROM po_lines_merge_v
2788: WHERE po_header_id = DOCUMENTID AND draft_id = DRAFTID
2789: AND USER_DOCUMENT_STATUS IS NOT NULL
2790: GROUP BY USER_DOCUMENT_STATUS
2791: ORDER BY 2) WHERE ROWNUM = 1;

Line 2798: FROM po_lines_merge_v polMod

2794:
2795: BEGIN
2796: SELECT DISTINCT CLM_EXERCISED_FLAG
2797: INTO v_excersiced_flag
2798: FROM po_lines_merge_v polMod
2799: WHERE po_header_id = DOCUMENTID AND draft_id = DRAFTID
2800: AND CLM_EXERCISED_FLAG = 'Y'
2801: AND CLM_EXERCISED_FLAG <> (SELECT CLM_EXERCISED_FLAG
2802: FROM po_lines_merge_v polMod

Line 2802: FROM po_lines_merge_v polMod

2798: FROM po_lines_merge_v polMod
2799: WHERE po_header_id = DOCUMENTID AND draft_id = DRAFTID
2800: AND CLM_EXERCISED_FLAG = 'Y'
2801: AND CLM_EXERCISED_FLAG <> (SELECT CLM_EXERCISED_FLAG
2802: FROM po_lines_merge_v polMod
2803: WHERE po_header_id = polMod.po_header_id
2804: AND draft_id = -1 AND po_line_id = polMod.po_line_id);
2805: EXCEPTION
2806: WHEN OTHERS THEN