Search Results get_past_due_agng_tbl_sql




Overview
Explore in AI Chat

Overview

ISC_DEPOT_BACKLOG_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the API classification "OTHER." It belongs to the Enterprise Territory/Channel Management and depot-related reporting components of Oracle EBS, and its principal role is to supply dynamically constructed SQL statements and column metadata to the Oracle Business Intelligence (BI) Publisher / PMV reporting framework. Each procedure in the package returns a custom SQL query string through an OUT parameter of type VARCHAR2 together with a query attribute collection of type BIS_QUERY_ATTRIBUTES_TBL, allowing the reporting engine to render depot backlog, past-due aging, and promise-date analyses without embedding that logic statically in the report definition. The package is a reporting-support utility rather than a transactional API; it does not create, update, or delete business data.

Key Procedures and Functions

The package exposes six documented procedures, all sharing the same conceptual contract: they accept a parameter collection of type BIS_PMV_PAGE_PARAMETER_TBL and return a custom SQL statement plus its output attribute definitions. None of the six are functions, and the metadata documents no additional private helpers.

  • GET_BACKLOG_TBL_SQL — Produces the SQL for the depot backlog table-level (summary) report, aggregating backlog quantities or values at the reporting group level.
  • GET_BACKLOG_TRD_SQL — Produces the SQL for the depot backlog trend view, supporting comparison of backlog figures across reporting periods.
  • GET_BACKLOG_DTL_TBL_SQL — Produces the SQL for the depot backlog detail report, returning the individual line-level records that underlie the backlog summary.
  • GET_PAST_DUE_AGNG_TBL_SQL — Produces the SQL for the past-due aging summary, typically bucket-based aging of overdue depot items.
  • GET_PAST_DUE_DTL_TBL_SQL — Produces the SQL for the past-due detail report, listing the individual overdue records behind the aging summary.
  • GET_DAYS_UNTIL_PROM_TBL_SQL — Produces the SQL for the days-until-promise analysis, showing scheduled or promised dates relative to the current date.

Tables Accessed

The documented table reference for this package is PLITBLM (accessed through an APPS synonym). The dynamic SQL generated by the procedures may also reference additional depot and backlog base tables at runtime, but PLITBLM is the only table recorded in the ETRM metadata. Because the procedures return SQL text rather than executing queries directly, the actual table access occurs when the calling BI Publisher or PMV engine parses and runs the generated statement.

Usage Notes

ISC_DEPOT_BACKLOG_PKG is not referenced by any other documented package, as indicated by the "Referenced by 0 other packages" metadata. It is therefore invoked directly by the reporting layer rather than through a package dependency chain. Typical invocation scenarios include Oracle BI Publisher report definitions and PMV-based dashboard pages that require depot backlog and past-due aging content, where the report engine calls the appropriate procedure, receives the generated SQL and attribute collection, and executes the query on the caller's behalf. Customizations that need to alter depot backlog reporting logic should generally be implemented by extending or wrapping these procedures rather than modifying the seeded package, and any changes must be validated against the BIS_QUERY_ATTRIBUTES_TBL contract to ensure correct column mapping in the consuming report. Because the package only builds SQL, it performs no DML and requires no commit or rollback handling by the caller.