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

Line 891: INSERT INTO po_requisitions_interface_all

887:
888: END IF;
889:
890:
891: INSERT INTO po_requisitions_interface_all
892: (interface_source_code,
893: destination_organization_id,
894: deliver_to_location_id,
895: deliver_to_requestor_id,

Line 1664: FROM po_requisitions_interface_all

1660: -- Lock the Interface record
1661:
1662: SELECT process_flag
1663: INTO l_process_flag
1664: FROM po_requisitions_interface_all
1665: WHERE interface_source_line_id = l_drop_ship_id
1666: AND interface_source_code = l_source_code;
1667:
1668: IF l_debug_level > 0 THEN

Line 1686: UPDATE po_requisitions_interface_all

1682:
1683: -- Update the Interface Record
1684: -- Analyzed for SQL performance ID 14882834, No changes required
1685: -- as we do not have any more where condition criteria
1686: UPDATE po_requisitions_interface_all
1687: SET quantity = nvl(l_ds_quantity,quantity),
1688: uom_code = nvl(l_ds_ordered_quantity_uom,
1689: uom_code),
1690: secondary_quantity = nvl(l_ds_ordered_quantity2,

Line 1704: OE_DEBUG_PUB.Add('After Updating PO_Requisitions_Interface_All..', 2);

1700: WHERE interface_source_line_id = l_drop_ship_id
1701: AND interface_source_code = l_source_code;
1702:
1703: IF l_debug_level > 0 THEN
1704: OE_DEBUG_PUB.Add('After Updating PO_Requisitions_Interface_All..', 2);
1705: END IF;
1706:
1707: ELSIF l_process_flag = 'ERROR' THEN
1708: FND_MESSAGE.SET_NAME('ONT','ONT_DS_LINE_IN_ERROR');

Line 1750: FROM po_requisitions_interface_all

1746:
1747: BEGIN
1748: SELECT process_flag
1749: INTO l_process_flag
1750: FROM po_requisitions_interface_all
1751: WHERE interface_source_line_id = l_drop_ship_id
1752: AND interface_source_code = l_source_code ;
1753: EXCEPTION
1754: WHEN NO_DATA_FOUND THEN

Line 1786: DELETE FROM po_requisitions_interface_all

1782:
1783: IF l_process_flag is NULL THEN
1784: -- Analysed for SQL Performance ID 14882874, No changes required
1785: -- as we do not have any more where condition criteria
1786: DELETE FROM po_requisitions_interface_all
1787: WHERE interface_source_line_id = l_drop_ship_id
1788: AND interface_source_code = l_source_code;
1789:
1790: IF l_debug_level > 0 THEN