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 AP_TERMS_LINES

Line 1005: q_netdays AS (SELECT Sum(DUE_DAYS) NetDays FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),

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: ),
1005: q_netdays AS (SELECT Sum(DUE_DAYS) NetDays FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1006: q_discount1 AS (SELECT DISCOUNT_PERCENT Percent,DISCOUNT_DAYS DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1007: q_discount2 AS (SELECT DISCOUNT_PERCENT_2 Percent,DISCOUNT_DAYS_2 DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1008: q_discount3 AS (SELECT DISCOUNT_PERCENT_3 Percent,DISCOUNT_DAYS_3 DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1009: q_discount AS (

Line 1006: q_discount1 AS (SELECT DISCOUNT_PERCENT Percent,DISCOUNT_DAYS DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),

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: ),
1005: q_netdays AS (SELECT Sum(DUE_DAYS) NetDays FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1006: q_discount1 AS (SELECT DISCOUNT_PERCENT Percent,DISCOUNT_DAYS DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1007: q_discount2 AS (SELECT DISCOUNT_PERCENT_2 Percent,DISCOUNT_DAYS_2 DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1008: q_discount3 AS (SELECT DISCOUNT_PERCENT_3 Percent,DISCOUNT_DAYS_3 DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1009: q_discount AS (
1010: (SELECT Percent,DaysDue FROM q_discount1) UNION (SELECT Percent,DaysDue FROM q_discount2) UNION

Line 1007: q_discount2 AS (SELECT DISCOUNT_PERCENT_2 Percent,DISCOUNT_DAYS_2 DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),

1003: ( (isMod = 'Y') AND (poh.draft_id = DRAFTID AND poh.change_status IS NOT NULL)) )
1004: ),
1005: q_netdays AS (SELECT Sum(DUE_DAYS) NetDays FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1006: q_discount1 AS (SELECT DISCOUNT_PERCENT Percent,DISCOUNT_DAYS DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1007: q_discount2 AS (SELECT DISCOUNT_PERCENT_2 Percent,DISCOUNT_DAYS_2 DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1008: q_discount3 AS (SELECT DISCOUNT_PERCENT_3 Percent,DISCOUNT_DAYS_3 DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1009: q_discount AS (
1010: (SELECT Percent,DaysDue FROM q_discount1) UNION (SELECT Percent,DaysDue FROM q_discount2) UNION
1011: (SELECT Percent,DaysDue FROM q_discount3)

Line 1008: q_discount3 AS (SELECT DISCOUNT_PERCENT_3 Percent,DISCOUNT_DAYS_3 DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),

1004: ),
1005: q_netdays AS (SELECT Sum(DUE_DAYS) NetDays FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1006: q_discount1 AS (SELECT DISCOUNT_PERCENT Percent,DISCOUNT_DAYS DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1007: q_discount2 AS (SELECT DISCOUNT_PERCENT_2 Percent,DISCOUNT_DAYS_2 DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1008: q_discount3 AS (SELECT DISCOUNT_PERCENT_3 Percent,DISCOUNT_DAYS_3 DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
1009: q_discount AS (
1010: (SELECT Percent,DaysDue FROM q_discount1) UNION (SELECT Percent,DaysDue FROM q_discount2) UNION
1011: (SELECT Percent,DaysDue FROM q_discount3)
1012: ) SELECT Percent,DaysDue,NetDays FROM q_discount,q_netdays;

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: