APPS.OPIMPXWI dependencies on OPI_IDS_PUSH_DATE_LOG

Line 438: FROM opi_ids_push_date_log

434: -- to be used as default from date if none passed by the calling program.
435:
436: CURSOR c_txn_date is
437: SELECT max(last_push_inv_txn_date) l_date
438: FROM opi_ids_push_date_log
439: GROUP BY organization_id
440: UNION
441: SELECT max(last_push_wip_txn_date) l_date
442: FROM opi_ids_push_date_log

Line 442: FROM opi_ids_push_date_log

438: FROM opi_ids_push_date_log
439: GROUP BY organization_id
440: UNION
441: SELECT max(last_push_wip_txn_date) l_date
442: FROM opi_ids_push_date_log
443: GROUP BY organization_id
444: ORDER BY 1;
445:
446: -- cursor to get all the periods spanned by this push

Line 476: . write to opi_ids_push_date_log

472: . get process dates
473: . purge previous push log data for closed periods
474: . calculate inventory balances
475: . calculate wip balances
476: . write to opi_ids_push_date_log
477: Process for each org is a commit cycle. If an error occurs
478: only data for that currently processed org is rolled back.
479: ---------------------------------------------------------*/
480:

Line 519: from opi_ids_push_date_log

515: EDW_LOG.PUT_LINE('l_to_date'||to_char(l_to_date,'DD-MON-YYYY hh24:mi:ss'));
516:
517: select sum(1)
518: into select_cursor
519: from opi_ids_push_date_log
520: where rownum < 2;
521:
522: if (p_org_code IS NOT NULL) then
523: BEGIN

Line 1139: insert into opi_ids_push_date_log

1135: l_errbuf);
1136: goto next_org;
1137: end if;
1138:
1139: insert into opi_ids_push_date_log
1140: (organization_id,
1141: last_push_date,
1142: last_push_inv_txn_id,
1143: last_push_inv_txn_date,

Line 1826: from opi_ids_push_date_log

1822:
1823: select max(last_push_inv_txn_date),max(last_push_wip_txn_date)
1824: into l_last_push_inv_date,
1825: l_last_push_wip_date
1826: from opi_ids_push_date_log
1827: where organization_id = i_org_id;
1828:
1829: --l_last_push_date := min(l_last_push_inv_date,l_last_push_wip_date);
1830: