APPS.JA_JAINVAR_XMLP_PKG dependencies on SO_PICKING_LINES_ALL

Line 25: SO_PICKING_LINES_ALL

21: CURSOR GET_ITEM_ID_CUR(V_PICKING_LINE_ID IN NUMBER) IS
22: SELECT
23: INVENTORY_ITEM_ID
24: FROM
25: SO_PICKING_LINES_ALL
26: WHERE PICKING_LINE_ID = V_PICKING_LINE_ID;
27: CURSOR FOLIO_NUM1(V_INVENTORY_ITEM_ID IN NUMBER) IS
28: SELECT
29: TO_CHAR(A.INVENTORY_ITEM_ID) || '/' || TO_CHAR(A.SLNO)

Line 440: SO_PICKING_LINES_ALL

436: CURSOR GET_ITEM_ID_CUR(V_PICKING_LINE_ID IN NUMBER) IS
437: SELECT
438: INVENTORY_ITEM_ID
439: FROM
440: SO_PICKING_LINES_ALL
441: WHERE PICKING_LINE_ID = V_PICKING_LINE_ID;
442: BEGIN
443: IF NVL(AUTO_INVOICE_FLAG
444: ,'N') = 'Y' THEN