APPS.OE_CANCEL dependencies on SO_PICKING_LINES

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 755: from so_picking_lines pl,

751: IF ( V_S2 = 4 or V_S2 = 5) then
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

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'

Line 1256: FROM SO_PICKING_LINES

1252: where line_id = V_LINE_ID
1253: or service_parent_line_id = V_LINE_ID)
1254: AND NOT EXISTS
1255: (SELECT 'BACKORDERED PICKING LINES'
1256: FROM SO_PICKING_LINES
1257: WHERE ORDER_LINE_ID = SO_LINES.LINE_ID
1258: AND PICKING_HEADER_ID = 0
1259: AND ORIGINAL_REQUESTED_QUANTITY > NVL(CANCELLED_QUANTITY,0));
1260:

Line 1307: FROM SO_PICKING_LINES L,

1303: -- we fail the whole 'Clean empty classes' process and issue an error message.
1304:
1305: SELECT COUNT(*)
1306: INTO DUMMY
1307: FROM SO_PICKING_LINES L,
1308: SO_PICKING_HEADERS H
1309: WHERE L.ORDER_LINE_ID = V_LINE_ID
1310: AND L.PICKING_HEADER_ID = H.PICKING_HEADER_ID
1311: AND H.STATUS_CODE IN ('OPEN' ,'PENDING', 'IN PROGRESS');

Line 1370: FROM SO_PICKING_LINES

1366: -- BACKORDERED PICKING LINES EXIST
1367:
1368: SELECT COUNT(*)
1369: INTO DUMMY
1370: FROM SO_PICKING_LINES
1371: WHERE PICKING_HEADER_ID = 0
1372: AND ORIGINAL_REQUESTED_QUANTITY > NVL(CANCELLED_QUANTITY,0)
1373: AND ORDER_LINE_ID = V_LINE_ID;
1374: