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.GMS_BILLING dependencies on PA_INVOICE_GROUP_COLUMNS

Line 112: from pa_invoice_group_columns a,

108: --Commented columns containing 'Job' for Bug# 5003907
109: Begin
110: select 1 into l_dummy from dual where exists (
111: select 1
112: from pa_invoice_group_columns a,
113: pa_invoice_format_details b
114: where a.invoice_group_column_id = b.invoice_group_column_id
115: and b.invoice_format_id in(l_labor_format_id,X_Non_Labor_format_id)
116: and a.column_code not in ('EMPLOYEE FIRST NAME','EMPLOYEE FULL NAME',

Line 2395: pa_invoice_group_columns a,

2391: a.column_code COL_CODE,
2392: a.select_text SELECT_TEXT,
2393: a.group_by_text GROUP_TEXT
2394: from
2395: pa_invoice_group_columns a,
2396: pa_invoice_format_details b
2397: where
2398: a.invoice_group_column_id = b.invoice_group_column_id and
2399: b.invoice_format_id = X_INV_FORMAT_ID

Line 2407: pa_invoice_group_columns b,

2403: select /*+INDEX(a PA_INVOICE_GROUP_TABLES_N1)*/
2404: distinct a.text TABLE_TEXT
2405: from
2406: pa_invoice_group_tables a,
2407: pa_invoice_group_columns b,
2408: pa_invoice_format_details c
2409: where
2410: b.invoice_group_column_id = c.invoice_group_column_id and
2411: a.invoice_group_column_id = c.invoice_group_column_id and

Line 2420: pa_invoice_group_columns c,

2416: distinct b.text WHERE_TEXT
2417: from
2418: pa_inv_grp_col_whr_clauses a,
2419: pa_inv_grp_whr_clauses b,
2420: pa_invoice_group_columns c,
2421: pa_invoice_format_details d
2422: where
2423: b.invoice_group_where_clause_id = a.invoice_group_where_clause_id and
2424: a.invoice_group_column_id = c.invoice_group_column_id and