DBA Data[Home] [Help]

APPS.JA_JAIN23D_XMLP_PKG dependencies on JAI_CMN_MATCH_RECEIPTS

Line 608: JAI_CMN_MATCH_RECEIPTS

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)

Line 622: JAI_CMN_MATCH_RECEIPTS

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