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.CTO_WORKFLOW_API_PK dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 1625: FROM po_requisitions_interface_alL

1621: -- Po_req_interface table has index on item_id column
1622:
1623: cursor INT_REQ is
1624: SELECT interface_source_line_id
1625: FROM po_requisitions_interface_alL
1626: WHERE interface_source_line_id = l_split_from_line_id
1627: AND process_flag is NULL
1628: and item_id = l_inventory_item_id
1629: FOR UPDATE of interface_source_line_id NOWAIT;

Line 1837: UPDATE PO_REQUISITIONS_INTERFACE_ALL

1833: BEGIN
1834: FOR c1 IN INT_REQ
1835: LOOP
1836:
1837: UPDATE PO_REQUISITIONS_INTERFACE_ALL
1838: SET interface_source_line_id = p_order_line_id
1839: WHERE CURRENT OF INT_REQ;
1840:
1841: END LOOP;

Line 1857: FROM po_requisitions_interface_all

1853: -- Po_req_interface table has index on item_id column
1854:
1855: SELECT Nvl(Sum(quantity),0)
1856: INTO l_po_req_qty
1857: FROM po_requisitions_interface_all
1858: WHERE interface_source_line_id = p_order_line_id
1859: and item_id = l_inventory_item_id
1860: AND process_flag is null;
1861: