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.POA_PORTAL_POPULATE_C dependencies on FII_TIME_WH_API

Line 23: cycq_start := FII_TIME_WH_API.ent_cycq_start;

19: BEGIN
20: truncate_tables(1, success);
21: --dbms_output.put_line('Tables were truncated = ' || success);
22:
23: cycq_start := FII_TIME_WH_API.ent_cycq_start;
24: cycq_end := fii_time_wh_api.today;
25:
26: lycq_start := FII_TIME_WH_API.ent_lycq_start;
27: lycq_end := FII_TIME_WH_API.ent_lycq_today1;

Line 24: cycq_end := fii_time_wh_api.today;

20: truncate_tables(1, success);
21: --dbms_output.put_line('Tables were truncated = ' || success);
22:
23: cycq_start := FII_TIME_WH_API.ent_cycq_start;
24: cycq_end := fii_time_wh_api.today;
25:
26: lycq_start := FII_TIME_WH_API.ent_lycq_start;
27: lycq_end := FII_TIME_WH_API.ent_lycq_today1;
28:

Line 26: lycq_start := FII_TIME_WH_API.ent_lycq_start;

22:
23: cycq_start := FII_TIME_WH_API.ent_cycq_start;
24: cycq_end := fii_time_wh_api.today;
25:
26: lycq_start := FII_TIME_WH_API.ent_lycq_start;
27: lycq_end := FII_TIME_WH_API.ent_lycq_today1;
28:
29: insert_rows_pd(cycq_start, cycq_end, 'C', l_number1, success);
30: --dbms_output.put_line(

Line 27: lycq_end := FII_TIME_WH_API.ent_lycq_today1;

23: cycq_start := FII_TIME_WH_API.ent_cycq_start;
24: cycq_end := fii_time_wh_api.today;
25:
26: lycq_start := FII_TIME_WH_API.ent_lycq_start;
27: lycq_end := FII_TIME_WH_API.ent_lycq_today1;
28:
29: insert_rows_pd(cycq_start, cycq_end, 'C', l_number1, success);
30: --dbms_output.put_line(
31: -- 'PD: ' || cycq_start || ' to ' || cycq_end || ': Rows= ' || l_number1 || ':' || success);

Line 150: and time.CDAY_CALENDAR_DATE between FII_TIME_WH_API.ent_cycq_start

146: and rcv.Supplier_Site_FK_Key = tp.TPLO_TPARTNER_LOC_PK_KEY
147: and rcv.TXN_CREAT_FK_KEY = time.CDAY_CAL_DAY_PK_KEY
148: and rcv.txn_type_fk_key = lku.lucd_lookup_code_pk_key
149: and lku.LUCD_LOOKUP_CODE = 'RECEIVE'
150: and time.CDAY_CALENDAR_DATE between FII_TIME_WH_API.ent_cycq_start
151: and FII_TIME_WH_API.today
152: GROUP BY org.Oper_Operating_Unit_PK_Key, org.OPER_NAME,
153: tp.TPRT_Trade_Partner_PK_Key, tp.TPRT_NAME
154: UNION ALL

Line 151: and FII_TIME_WH_API.today

147: and rcv.TXN_CREAT_FK_KEY = time.CDAY_CAL_DAY_PK_KEY
148: and rcv.txn_type_fk_key = lku.lucd_lookup_code_pk_key
149: and lku.LUCD_LOOKUP_CODE = 'RECEIVE'
150: and time.CDAY_CALENDAR_DATE between FII_TIME_WH_API.ent_cycq_start
151: and FII_TIME_WH_API.today
152: GROUP BY org.Oper_Operating_Unit_PK_Key, org.OPER_NAME,
153: tp.TPRT_Trade_Partner_PK_Key, tp.TPRT_NAME
154: UNION ALL
155: SELECT count(sp.num_late_receipt),

Line 157: avg(FII_TIME_WH_API.today-time.CDAY_CALENDAR_DATE),

153: tp.TPRT_Trade_Partner_PK_Key, tp.TPRT_NAME
154: UNION ALL
155: SELECT count(sp.num_late_receipt),
156: 0,
157: avg(FII_TIME_WH_API.today-time.CDAY_CALENDAR_DATE),
158: max(FII_TIME_WH_API.today-time.CDAY_CALENDAR_DATE),
159: sum((sp.Qty_Ordered_B-sp.Qty_Received_B)*sp.Price_G),
160: tp.tprt_trade_partner_pk_key,
161: tp.tprt_name,

Line 158: max(FII_TIME_WH_API.today-time.CDAY_CALENDAR_DATE),

154: UNION ALL
155: SELECT count(sp.num_late_receipt),
156: 0,
157: avg(FII_TIME_WH_API.today-time.CDAY_CALENDAR_DATE),
158: max(FII_TIME_WH_API.today-time.CDAY_CALENDAR_DATE),
159: sum((sp.Qty_Ordered_B-sp.Qty_Received_B)*sp.Price_G),
160: tp.tprt_trade_partner_pk_key,
161: tp.tprt_name,
162: org.oper_operating_unit_pk_key,

Line 172: and time.CDAY_CALENDAR_DATE < FII_TIME_WH_API.today

168: WHERE ((sp.Qty_Ordered_B-sp.Qty_Received_B) > 0)
169: and sp.SHIP_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY
170: and sp.Supplier_Site_FK_Key = tp.TPLO_TPARTNER_LOC_PK_KEY
171: and sp.Promised_Date_FK_Key = time.CDAY_CAL_DAY_PK_KEY
172: and time.CDAY_CALENDAR_DATE < FII_TIME_WH_API.today
173: GROUP BY org.Oper_Operating_Unit_PK_Key, org.OPER_NAME,
174: tp.TPRT_Trade_Partner_PK_Key, tp.TPRT_NAME;
175:
176: p_count := sql%rowcount;

Line 199: cycq_start := FII_TIME_WH_API.ent_cycq_start;

195: BEGIN
196: truncate_tables(2, success);
197: --dbms_output.put_line('Tables were truncated = ' || success);
198:
199: cycq_start := FII_TIME_WH_API.ent_cycq_start;
200: cycq_end := fii_time_wh_api.today;
201:
202: insert_rows_cross(cycq_start, cycq_end, l_number, success);
203: --dbms_output.put_line(

Line 200: cycq_end := fii_time_wh_api.today;

196: truncate_tables(2, success);
197: --dbms_output.put_line('Tables were truncated = ' || success);
198:
199: cycq_start := FII_TIME_WH_API.ent_cycq_start;
200: cycq_end := fii_time_wh_api.today;
201:
202: insert_rows_cross(cycq_start, cycq_end, l_number, success);
203: --dbms_output.put_line(
204: -- 'CR: ' || cycq_start || ' to ' || cycq_end || ': Rows= ' || l_number || ':' || success);

Line 332: round(avg(fii_time_wh_api.today-payment_due_date)) open_pay_age,

328: 0,
329: 0,
330: 0,
331: count(sch_payment_id) open_payments,
332: round(avg(fii_time_wh_api.today-payment_due_date)) open_pay_age,
333: 0,
334: 0
335: from fii_ap_trans_backlog_summary
336: group by operating_unit_pk_key,

Line 440: avg(fii_time_wh_api.today-time2.CDAY_CALENDAR_DATE),

436: tp.tprt_name,
437: 0, 0, 0,
438: sum(pod.amt_purchased_g),
439: count(*),
440: avg(fii_time_wh_api.today-time2.CDAY_CALENDAR_DATE),
441: 0, 0, 0, 0,
442: p_quarter,
443: item.IORG_Purchaseable_Flag
444: from poa_edw_po_dist_f pod,

Line 458: and time2.CDAY_CALENDAR_DATE < fii_time_wh_api.today

454: and time1.CDAY_CALENDAR_DATE between p_start and p_end
455: and pod.PO_ACCEPT_DATE_FK_KEY = 0
456: and pod.ACCPT_DUE_DATE_FK_KEY <> 0
457: and pod.ACCPT_DUE_DATE_FK_KEY = time2.CDAY_CAL_DAY_PK_KEY
458: and time2.CDAY_CALENDAR_DATE < fii_time_wh_api.today
459: group by org.Oper_Operating_Unit_PK_Key, org.OPER_NAME,
460: org.Orga_Organization_PK_Key, org.Orga_Name,
461: item.Ci11_Category_PK_Key, item.CI11_NAME,
462: tp.TPRT_Trade_Partner_PK_Key, tp.TPRT_NAME,

Line 1218: and time.CDAY_CALENDAR_DATE between FII_TIME_WH_API.ent_cycq_start

1214: edw_time_m time
1215: WHERE sp.SHIP_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY
1216: and sp.DATE_DIM_FK_KEY = time.CDAY_CAL_DAY_PK_KEY
1217: and sp.NUM_RECEIPT_LINES <> 0
1218: and time.CDAY_CALENDAR_DATE between FII_TIME_WH_API.ent_cycq_start
1219: and FII_TIME_WH_API.today
1220: GROUP BY org.Oper_Operating_Unit_PK_Key, org.OPER_NAME,
1221: org.Orga_Organization_PK_Key, org.Orga_Name
1222: UNION ALL

Line 1219: and FII_TIME_WH_API.today

1215: WHERE sp.SHIP_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY
1216: and sp.DATE_DIM_FK_KEY = time.CDAY_CAL_DAY_PK_KEY
1217: and sp.NUM_RECEIPT_LINES <> 0
1218: and time.CDAY_CALENDAR_DATE between FII_TIME_WH_API.ent_cycq_start
1219: and FII_TIME_WH_API.today
1220: GROUP BY org.Oper_Operating_Unit_PK_Key, org.OPER_NAME,
1221: org.Orga_Organization_PK_Key, org.Orga_Name
1222: UNION ALL
1223: SELECT org.oper_operating_unit_pk_key,

Line 1241: and time.CDAY_CALENDAR_DATE between FII_TIME_WH_API.ent_cycq_start

1237: edw_time_m time
1238: WHERE rcv.RCV_Del_To_Org_FK_Key = org.ORGA_ORGANIZATION_PK_KEY
1239: and rcv.TXn_Type_FK_Key = lookup.lucd_lookup_Code_PK_Key
1240: and rcv.TXN_Creat_FK_Key = time.CDAY_CAL_DAY_PK_KEY
1241: and time.CDAY_CALENDAR_DATE between FII_TIME_WH_API.ent_cycq_start
1242: and FII_TIME_WH_API.today
1243: GROUP BY org.Oper_Operating_Unit_PK_Key, org.OPER_NAME,
1244: org.Orga_Organization_PK_Key, org.Orga_Name;
1245:

Line 1242: and FII_TIME_WH_API.today

1238: WHERE rcv.RCV_Del_To_Org_FK_Key = org.ORGA_ORGANIZATION_PK_KEY
1239: and rcv.TXn_Type_FK_Key = lookup.lucd_lookup_Code_PK_Key
1240: and rcv.TXN_Creat_FK_Key = time.CDAY_CAL_DAY_PK_KEY
1241: and time.CDAY_CALENDAR_DATE between FII_TIME_WH_API.ent_cycq_start
1242: and FII_TIME_WH_API.today
1243: GROUP BY org.Oper_Operating_Unit_PK_Key, org.OPER_NAME,
1244: org.Orga_Organization_PK_Key, org.Orga_Name;
1245:
1246: p_count := sql%rowcount;