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 856: INSERT INTO po_requisitions_interface_all

852:
853: END IF;
854:
855:
856: INSERT INTO po_requisitions_interface_all
857: (interface_source_code,
858: destination_organization_id,
859: deliver_to_location_id,
860: deliver_to_requestor_id,

Line 1629: FROM po_requisitions_interface_all

1625: -- Lock the Interface record
1626:
1627: SELECT process_flag
1628: INTO l_process_flag
1629: FROM po_requisitions_interface_all
1630: WHERE interface_source_line_id = l_drop_ship_id
1631: AND interface_source_code = l_source_code;
1632:
1633: IF l_debug_level > 0 THEN

Line 1651: UPDATE po_requisitions_interface_all

1647:
1648: -- Update the Interface Record
1649: -- Analyzed for SQL performance ID 14882834, No changes required
1650: -- as we do not have any more where condition criteria
1651: UPDATE po_requisitions_interface_all
1652: SET quantity = nvl(l_ds_quantity,quantity),
1653: uom_code = nvl(l_ds_ordered_quantity_uom,
1654: uom_code),
1655: secondary_quantity = nvl(l_ds_ordered_quantity2,

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

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
1669: OE_DEBUG_PUB.Add('After Updating PO_Requisitions_Interface_All..', 2);
1670: END IF;
1671:
1672: ELSIF l_process_flag = 'ERROR' THEN
1673: FND_MESSAGE.SET_NAME('ONT','ONT_DS_LINE_IN_ERROR');

Line 1715: FROM po_requisitions_interface_all

1711:
1712: BEGIN
1713: SELECT process_flag
1714: INTO l_process_flag
1715: FROM po_requisitions_interface_all
1716: WHERE interface_source_line_id = l_drop_ship_id
1717: AND interface_source_code = l_source_code ;
1718: EXCEPTION
1719: WHEN NO_DATA_FOUND THEN

Line 1751: DELETE FROM po_requisitions_interface_all

1747:
1748: IF l_process_flag is NULL THEN
1749: -- Analysed for SQL Performance ID 14882874, No changes required
1750: -- as we do not have any more where condition criteria
1751: DELETE FROM po_requisitions_interface_all
1752: WHERE interface_source_line_id = l_drop_ship_id
1753: AND interface_source_code = l_source_code;
1754:
1755: IF l_debug_level > 0 THEN