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.CST_MGD_INFL_ADJUSTMENT_RPT dependencies on ORG_ACCT_PERIODS

Line 95: ORG_ACCT_PERIODS

91: SELECT
92: acct_period_id
93: , schedule_close_date
94: FROM
95: ORG_ACCT_PERIODS
96: WHERE trunc(period_start_date) < c_period_start_date
97: AND organization_id = c_organization_id
98: ORDER BY
99: period_start_date DESC;

Line 216: ORG_ACCT_PERIODS oap

212: acct_period_id
213: INTO
214: x_rpt_from_acct_per_id
215: FROM
216: ORG_ACCT_PERIODS oap
217: WHERE oap.organization_id = p_org_id
218: AND oap.period_start_date <= p_rpt_from_date
219: AND oap.schedule_close_date >= p_rpt_from_date
220: AND oap.open_flag = 'N'

Line 229: ORG_ACCT_PERIODS oap

225: acct_period_id
226: INTO
227: x_rpt_to_acct_per_id
228: FROM
229: ORG_ACCT_PERIODS oap
230: WHERE oap.organization_id = p_org_id
231: AND oap.period_start_date <= p_rpt_to_date
232: AND oap.schedule_close_date >= p_rpt_to_date
233: AND oap.open_flag = 'N'

Line 864: , ORG_ACCT_PERIODS PER

860: , PER.Period_Start_Date
861: FROM
862: CST_MGD_INFL_ADJUSTED_COSTS INFL
863: , MTL_SYSTEM_ITEMS_B_KFV MSI
864: , ORG_ACCT_PERIODS PER
865: WHERE INFL.Organization_ID = c_org_id
866: AND MSI.Organization_ID = c_org_id
867: AND PER.Organization_ID = c_org_id
868: AND INFL.Inventory_Item_ID = MSI.Inventory_Item_ID

Line 896: , ORG_ACCT_PERIODS PER

892: , PER.Period_Start_Date
893: FROM
894: CST_MGD_INFL_ADJUSTED_COSTS INFL
895: , MTL_SYSTEM_ITEMS_B MSI
896: , ORG_ACCT_PERIODS PER
897: WHERE INFL.Organization_ID = c_org_id
898: AND MSI.Organization_ID = c_org_id
899: AND PER.Organization_ID = c_org_id
900: AND INFL.Inventory_Item_ID = MSI.Inventory_Item_ID