[Home] [Help]
604: CURSOR C_MATCHED_QTY(P_REGISTER_ID IN NUMBER) IS
605: SELECT
606: SUM(QUANTITY_APPLIED)
607: FROM
608: JAI_CMN_MATCH_RECEIPTS
609: WHERE RECEIPT_ID = P_REGISTER_ID;
610: CURSOR C_SHIPPED_QTY_ISO(P_REGISTER_ID IN NUMBER) IS
611: SELECT
612: NVL(SUM(QTY_TO_ADJUST)
618: SELECT
619: NVL(SUM(QUANTITY_APPLIED)
620: ,0)
621: FROM
622: JAI_CMN_MATCH_RECEIPTS
623: WHERE RECEIPT_ID IN (
624: SELECT
625: REGISTER_ID
626: FROM