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.GL_ARCH_PRG_FROM_PRD_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19


	SELECT
	      PS.closing_status,
	      PS.period_name,
	      PS.effective_period_num
        FROM
	      GL_PERIOD_STATUSES PS
        WHERE
	      PS.application_id          =  x_appl_id
        AND   PS.ledger_id               =  x_ledger_id
        AND   PS.closing_status          <> 'N'
        AND   PS.effective_period_num    >
              (SELECT
                     NVL(MAX(AH.last_archived_eff_period_num), 0)
               FROM
	             GL_ARCHIVE_HISTORY AH
               WHERE
	             AH.ledger_id        =  x_ledger_id
               AND   AH.data_type        =  x_data_type
               AND   AH.actual_flag      =  x_actual_flag)
        ORDER BY PS.effective_period_num ASC;

Line: 86


	SELECT
	      PS.closing_status,
	      PS.period_name,
	      PS.effective_period_num
        FROM
	      GL_PERIOD_STATUSES PS
        WHERE
	      PS.application_id          =  x_appl_id
        AND   PS.ledger_id               =  x_ledger_id
        AND   PS.closing_status          <> 'N'
        AND   PS.effective_period_num    >
              (SELECT
                     NVL(MAX(AH.last_purged_eff_period_num), 0)
               FROM
	             GL_ARCHIVE_HISTORY AH
               WHERE
	             AH.ledger_id        =  x_ledger_id
               AND   AH.actual_flag      =  x_actual_flag
               AND   AH.data_type        =  x_data_type )
        AND   PS.effective_period_num <=
              (SELECT
                     NVL(MAX(AH.last_archived_eff_period_num), -1)
               FROM
	             GL_ARCHIVE_HISTORY AH
               WHERE
	             AH.ledger_id        =  x_ledger_id
               AND   AH.data_type        =  x_data_type
               AND   AH.actual_flag      =  x_actual_flag)
        ORDER BY PS.effective_period_num ASC;

Line: 161


	SELECT
	      PS.closing_status,
	      PS.period_name,
	      PS.effective_period_num
        FROM
	      GL_PERIOD_STATUSES PS
        WHERE
	      PS.application_id          =  x_appl_id
        AND   PS.ledger_id               =  x_ledger_id
        AND   PS.closing_status          <> 'N'
        AND   PS.effective_period_num    >
              (SELECT
                     NVL(MAX(AH.last_purged_eff_period_num), 0)
               FROM
	             GL_ARCHIVE_HISTORY AH
               WHERE
	             AH.ledger_id        =  x_ledger_id
               AND   AH.data_type        =  x_data_type
               AND   AH.actual_flag      =  x_actual_flag)
        ORDER BY PS.effective_period_num ASC;

Line: 228


	SELECT
	      BPR.start_period_name,
	      ( BPR.period_year * 10000 + BPR.start_period_num )
        FROM
	      GL_BUDGET_PERIOD_RANGES BPR
        WHERE
	      BPR.budget_version_id      =  x_budget_version_id
        AND   BPR.open_flag              =  'O'
        AND   ( BPR.period_year * 10000 + BPR.start_period_num ) >
              (SELECT
                     NVL(MAX(AH.last_archived_eff_period_num), 0)
               FROM
	             GL_ARCHIVE_HISTORY AH
               WHERE
	             AH.ledger_id          =  x_ledger_id
               AND   AH.data_type          =  x_data_type
               AND   AH.actual_flag        =  x_actual_flag
               AND   AH.budget_version_id  =  x_budget_version_id )
        ORDER BY ( BPR.period_year * 10000 + BPR.start_period_num ) ASC;

Line: 291


	SELECT
	      BPR.start_period_name,
	      ( BPR.period_year * 10000 + BPR.start_period_num )
        FROM
	      GL_BUDGET_PERIOD_RANGES BPR
        WHERE
	      BPR.budget_version_id      =  x_budget_version_id
        AND   BPR.open_flag              =  'O'
        AND   ( BPR.period_year * 10000 + BPR.start_period_num ) >
              (SELECT
                     NVL(MAX(AH.last_purged_eff_period_num), 0)
               FROM
	             GL_ARCHIVE_HISTORY AH
               WHERE
	             AH.ledger_id          =  x_ledger_id
               AND   AH.data_type          =  x_data_type
               AND   AH.actual_flag        =  x_actual_flag
               AND   AH.budget_version_id  =  x_budget_version_id )
        AND   ( BPR.period_year * 10000 + BPR.start_period_num ) <=
              (SELECT
		     NVL(MAX(AH.last_archived_eff_period_num), 0)
               FROM
		    GL_ARCHIVE_HISTORY AH
               WHERE
		     AH.ledger_id          = x_ledger_id
               AND   AH.data_type          = x_data_type
	       AND   AH.actual_flag        = x_actual_flag
	       AND   AH.budget_version_id  = x_budget_version_id )
        ORDER BY ( BPR.period_year * 10000 + BPR.start_period_num ) ASC;

Line: 363


	SELECT
	      BPR.start_period_name,
	      ( BPR.period_year * 10000 + BPR.start_period_num )
        FROM
	      GL_BUDGET_PERIOD_RANGES BPR
        WHERE
	      BPR.budget_version_id      =  x_budget_version_id
        AND   BPR.open_flag              =  'O'
        AND   ( BPR.period_year * 10000 + BPR.start_period_num ) >
              (SELECT
                     NVL(MAX(AH.last_purged_eff_period_num), 0)
               FROM
	             GL_ARCHIVE_HISTORY AH
               WHERE
	             AH.ledger_id          =  x_ledger_id
               AND   AH.data_type          =  x_data_type
               AND   AH.actual_flag        =  x_actual_flag
               AND   AH.budget_version_id  =  x_budget_version_id )
        ORDER BY ( BPR.period_year * 10000 + BPR.start_period_num ) ASC;

Line: 425


	SELECT
	      PS.period_name,
	      PS.closing_status,
	      PS.effective_period_num
        FROM
	      GL_PERIOD_STATUSES PS,
	      GL_TRANSLATION_TRACKING TT
        WHERE
	      PS.application_id                    =  x_appl_id
        AND   PS.ledger_id                         =  x_ledger_id
	AND   TT.ledger_id                         =  x_ledger_id
	AND   TT.target_currency                   =  x_currency
	AND   TT.actual_flag                       =  x_actual_flag
	AND   NVL(TT.target_budget_version_id,-1)  =  NVL(x_budget_version_id,-1)
	AND   PS.effective_period_num              >=
	      (TT.earliest_ever_period_year * 10000 + TT.earliest_ever_period_num)
        AND   PS.effective_period_num              <
	      (TT.earliest_never_period_year * 10000 + TT.earliest_never_period_num)
        ORDER BY PS.effective_period_num DESC;

Line: 488


	SELECT
	      PS.period_name,
	      PS.closing_status,
	      PS.effective_period_num
        FROM
	      GL_PERIOD_STATUSES PS,
	      GL_TRANSLATION_TRACKING TT
        WHERE
	      PS.application_id                    =  x_appl_id
        AND   PS.ledger_id                         =  x_ledger_id
	AND   TT.ledger_id                         =  x_ledger_id
	AND   TT.target_currency                   =  x_currency
	AND   TT.average_translation_flag          =  'N'
	AND   TT.actual_flag                       =  x_actual_flag
	AND   NVL(TT.target_budget_version_id,-1)  =  NVL(x_budget_version_id,-1)
	AND   PS.effective_period_num              >=
	      (TT.earliest_ever_period_year * 10000 + TT.earliest_ever_period_num)
        AND   PS.effective_period_num              <
	      (TT.earliest_never_period_year * 10000 + TT.earliest_never_period_num)
        ORDER BY PS.effective_period_num DESC;

Line: 552


	SELECT
	      PS.period_name,
	      PS.closing_status,
	      PS.effective_period_num
        FROM
	      GL_PERIOD_STATUSES PS,
	      GL_TRANSLATION_TRACKING TT
        WHERE
	      PS.application_id                    =  x_appl_id
        AND   PS.ledger_id                         =  x_ledger_id
	AND   TT.ledger_id                         =  x_ledger_id
	AND   TT.target_currency                   =  x_currency
	AND   TT.average_translation_flag          =  'Y'
	AND   TT.actual_flag                       =  x_actual_flag
	AND   NVL(TT.target_budget_version_id,-1)  =  NVL(x_budget_version_id,-1)
	AND   PS.effective_period_num              >=
	      (TT.earliest_ever_period_year * 10000 + TT.earliest_ever_period_num)
        AND   PS.effective_period_num              <
	      (TT.earliest_never_period_year * 10000 + TT.earliest_never_period_num)
        ORDER BY PS.effective_period_num DESC;