APPS.JA_JAINVAR_XMLP_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 525: JAI_OM_WSH_LINES_ALL

521: CURSOR GET_SELLING_PRICE_CUR(V_PICKING_LINE_ID IN NUMBER) IS
522: SELECT
523: SELLING_PRICE
524: FROM
525: JAI_OM_WSH_LINES_ALL
526: WHERE PICKING_LINE_ID = V_PICKING_LINE_ID;
527: BEGIN
528: IF NVL(AUTO_INVOICE_FLAG
529: ,'N') = 'Y' THEN

Line 653: JAI_OM_WSH_LINES_ALL

649: CURSOR GET_ASSESSABLE_VALUE_CUR(V_PICKING_LINE_ID IN NUMBER) IS
650: SELECT
651: ASSESSABLE_VALUE
652: FROM
653: JAI_OM_WSH_LINES_ALL
654: WHERE PICKING_LINE_ID = V_PICKING_LINE_ID;
655: CURSOR TRANSACTION_CURR_CUR IS
656: SELECT
657: SET_OF_BOOKS_ID,

Line 827: JAI_OM_WSH_LINES_ALL

823: CURSOR GET_INVENTORY_ITEM_ID(V_PICKING_LINE_ID IN NUMBER) IS
824: SELECT
825: INVENTORY_ITEM_ID
826: FROM
827: JAI_OM_WSH_LINES_ALL
828: WHERE PICKING_LINE_ID = V_PICKING_LINE_ID;
829: BEGIN
830: IF NVL(AUTO_INVOICE_FLAG
831: ,'N') = 'Y' THEN