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 1604: FROM po_requisitions_interface_alL

1600: -- Po_req_interface table has index on item_id column
1601:
1602: cursor INT_REQ is
1603: SELECT interface_source_line_id
1604: FROM po_requisitions_interface_alL
1605: WHERE interface_source_line_id = l_split_from_line_id
1606: AND process_flag is NULL
1607: and item_id = l_inventory_item_id
1608: FOR UPDATE of interface_source_line_id NOWAIT;

Line 1810: UPDATE PO_REQUISITIONS_INTERFACE_ALL

1806: BEGIN
1807: FOR c1 IN INT_REQ
1808: LOOP
1809:
1810: UPDATE PO_REQUISITIONS_INTERFACE_ALL
1811: SET interface_source_line_id = p_order_line_id
1812: WHERE CURRENT OF INT_REQ;
1813:
1814: END LOOP;

Line 1830: FROM po_requisitions_interface_all

1826: -- Po_req_interface table has index on item_id column
1827:
1828: SELECT Nvl(Sum(quantity),0)
1829: INTO l_po_req_qty
1830: FROM po_requisitions_interface_all
1831: WHERE interface_source_line_id = p_order_line_id
1832: and item_id = l_inventory_item_id
1833: AND process_flag is null;
1834: