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.FII_AP_INV_ACTIVITY dependencies on BIS_QUERY_ATTRIBUTES

Line 12: inv_act_anal_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

8:
9: PROCEDURE get_inv_activity (
10: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
11: inv_act_anal_sql OUT NOCOPY VARCHAR2,
12: inv_act_anal_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
13: IS
14: sqlstmt varchar2(14000);
15: l_viewby_dim VARCHAR2(240); -- what is the viewby
16: l_as_of_date DATE;

Line 24: inv_act_rec BIS_QUERY_ATTRIBUTES;

20: l_viewby_id VARCHAR2(240); -- org_id or supplier_id
21: l_record_type_id NUMBER; --
22: l_gid NUMBER; -- 0,4 or 8
23: l_viewby_string VARCHAR2(240);
24: inv_act_rec BIS_QUERY_ATTRIBUTES;
25: l_period_type VARCHAR2(240);
26: l_invoice_number VARCHAR2(240);
27: l_column_name VARCHAR2(240);
28: l_table_name VARCHAR2(240);

Line 296: inv_type_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

292:
293: PROCEDURE get_inv_type (
294: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
295: inv_type_sql OUT NOCOPY VARCHAR2,
296: inv_type_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
297: IS
298: sqlstmt varchar2(14000);
299: l_num NUMBER;
300: l_viewby_dim VARCHAR2(240); -- what is the viewby

Line 309: inv_type_rec BIS_QUERY_ATTRIBUTES;

305: l_viewby_id VARCHAR2(240); -- org_id or supplier_id
306: l_record_type_id NUMBER; --
307: l_gid NUMBER; -- 0,4 or 8
308: l_viewby_string VARCHAR2(240);
309: inv_type_rec BIS_QUERY_ATTRIBUTES;
310: l_param_join VARCHAR2(240);
311: l_param_join_ou VARCHAR2(240);
312: l_curr_info VARCHAR2(240);
313: l_curr_suffix VARCHAR2(240);

Line 534: elec_inv_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

530:
531: PROCEDURE get_electronic_inv (
532: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
533: elec_inv_sql OUT NOCOPY VARCHAR2,
534: elec_inv_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
535: IS
536: sqlstmt varchar2(14000);
537: l_num NUMBER;
538: l_viewby_dim VARCHAR2(240); -- what is the viewby

Line 547: elec_inv_rec BIS_QUERY_ATTRIBUTES;

543: l_viewby_id VARCHAR2(240); -- org_id or supplier_id
544: l_record_type_id NUMBER; --
545: l_gid NUMBER; -- 0,4 or 8
546: l_viewby_string VARCHAR2(240);
547: elec_inv_rec BIS_QUERY_ATTRIBUTES;
548: l_param_join VARCHAR2(240);
549: l_param_join_ou VARCHAR2(240);
550: l_curr_info VARCHAR2(240);
551: l_curr_suffix VARCHAR2(240);

Line 820: get_hold_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

816:
817: PROCEDURE get_hold_activity (
818: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
819: get_hold_sql OUT NOCOPY VARCHAR2,
820: get_hold_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
821: IS
822: sqlstmt varchar2(14000);
823: l_num NUMBER;
824: l_viewby_dim VARCHAR2(240); -- what is the viewby

Line 833: get_hold_rec BIS_QUERY_ATTRIBUTES;

829: l_viewby_id VARCHAR2(240); -- org_id or supplier_id
830: l_record_type_id NUMBER; --
831: l_gid NUMBER; -- 0,4 or 8
832: l_viewby_string VARCHAR2(240);
833: get_hold_rec BIS_QUERY_ATTRIBUTES;
834: l_param_join VARCHAR2(240);
835: l_param_join_ou VARCHAR2(240);
836: l_curr_info VARCHAR2(240);
837: l_curr_suffix VARCHAR2(240);

Line 1109: p_bind_output_table OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,

1105: PROCEDURE Local_Bind_Variable
1106: (p_sqlstmt IN Varchar2,
1107: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1108: p_sql_output OUT NOCOPY Varchar2,
1109: p_bind_output_table OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
1110: p_record_type_id IN Number Default Null,
1111: p_view_by IN Varchar2 Default Null,
1112: p_gid IN Number Default Null,
1113: p_period_start IN Date Default null,

Line 1118: l_bind_rec BIS_QUERY_ATTRIBUTES;

1114: p_report_start IN Date Default null,
1115: p_cur_effective_num IN Number Default Null,
1116: p_period_id IN Number Default Null
1117: ) IS
1118: l_bind_rec BIS_QUERY_ATTRIBUTES;
1119:
1120: BEGIN
1121: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();
1122: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

Line 1121: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();

1117: ) IS
1118: l_bind_rec BIS_QUERY_ATTRIBUTES;
1119:
1120: BEGIN
1121: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();
1122: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1123: p_sql_output := p_sqlstmt;
1124: p_bind_output_table.EXTEND;
1125: l_bind_rec.attribute_name := ':VIEW_BY';

Line 1272: electronic_inv_trend_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1268:
1269: PROCEDURE get_electronic_inv_trend (
1270: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1271: electronic_inv_trend_sql OUT NOCOPY VARCHAR2,
1272: electronic_inv_trend_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1273: IS
1274: l_viewby_dim VARCHAR2(240); -- what is the viewby
1275: l_as_of_date DATE;
1276: l_organization VARCHAR2(240);

Line 1283: electronic_inv_trend_rec BIS_QUERY_ATTRIBUTES;

1279: l_viewby_id VARCHAR2(240); -- org_id or supplier_id
1280: l_record_type_id NUMBER; --
1281: l_gid NUMBER; -- 0,4 or 8
1282: l_viewby_string VARCHAR2(240);
1283: electronic_inv_trend_rec BIS_QUERY_ATTRIBUTES;
1284: l_param_join VARCHAR2(240);
1285: l_cur_period NUMBER;
1286: l_id_column VARCHAR2(100);
1287: sqlstmt VARCHAR2(14000);