DBA Data[Home] [Help]

APPS.OE_CANCEL dependencies on SO_PICKING_HEADERS

Line 1308: SO_PICKING_HEADERS H

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');
1312: