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_FORMAT_DETAILS

Line 113: pa_invoice_format_details b

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',
117: 'EMPLOYEE LAST NAME','EXPENDITURE CATEGORY',

Line 2396: pa_invoice_format_details b

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
2400: order by b.start_position;

Line 2408: pa_invoice_format_details c

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
2412: c.invoice_format_id = X_INV_FORMAT_ID;

Line 2421: pa_invoice_format_details d

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
2425: c.invoice_group_column_id = d.invoice_group_column_id and