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_CANCEL dependencies on SO_PICKING_LINE_DETAILS

Line 661: from so_picking_lines pl, so_picking_line_details pld

657: IF (V_S2 = 4 or V_S2 = 5) then
658:
659: select nvl(sum(pld.requested_quantity),0)
660: into PD_QTY
661: from so_picking_lines pl, so_picking_line_details pld
662: where pl.picking_line_id = pld.picking_line_id
663: and pl.picking_header_id = 0
664: and pl.order_line_id = V_LOOP_LINE_ID
665: and nvl(pld.released_flag,'N') = 'N'

Line 756: so_picking_line_details pld

752:
753: select nvl(sum(pld.requested_quantity),0)
754: into PD_QTY
755: from so_picking_lines pl,
756: so_picking_line_details pld
757: where pl.picking_line_id = pld.picking_line_id
758: and pl.picking_header_id = 0
759: and pl.order_line_id = V_LOOP_LINE_ID
760: and pl.inventory_item_id = TEMP_ITEM_ID

Line 840: FROM SO_PICKING_LINE_DETAILS PLD, SO_PICKING_LINES PL

836: IF (V_S2 = 4 or V_S2 = 5) then
837:
838: SELECT NVL(SUM(PLD.REQUESTED_QUANTITY),0)
839: INTO PD_QTY
840: FROM SO_PICKING_LINE_DETAILS PLD, SO_PICKING_LINES PL
841: WHERE PL.ORDER_LINE_ID = V_ATO_LOOP_LINE_ID
842: AND PL.PICKING_HEADER_ID = 0
843: AND PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID
844: AND PLD.RELEASED_FLAG = 'N'