APPS.JA_JAIN23D_XMLP_PKG dependencies on JAI_CMN_RG_23D_TRXS

Line 43: JAI_CMN_RG_23D_TRXS A,

39: SUBSTR(B.VENDOR_NAME || ' ' || C.ADDRESS_LINE1 || ' ' || ADDRESS_LINE2 || ' ' || ADDRESS_LINE3 || ' ' || D.EXCISE_DUTY_RANGE || ' ' || D.EXCISE_DUTY_DIVISION || ' ' || D.EXCISE_DUTY_COMM
40: ,1
41: ,255)
42: FROM
43: JAI_CMN_RG_23D_TRXS A,
44: PO_VENDORS B,
45: PO_VENDOR_SITES_ALL C,
46: JAI_CMN_VENDOR_SITES D
47: WHERE A.VENDOR_ID = B.VENDOR_ID

Line 79: JAI_CMN_RG_23D_TRXS D

75: RCV.CUSTOMER_ID,
76: RCV.CUSTOMER_SITE_ID
77: FROM
78: RCV_TRANSACTIONS RCV,
79: JAI_CMN_RG_23D_TRXS D
80: WHERE RCV.TRANSACTION_ID = D.RECEIPT_REF
81: AND D.REGISTER_ID = P_REGISTER_ID;
82: CURSOR C_DELIVER_DTLS(P_SHIPMENT_LINE_ID IN NUMBER,CP_TRANSACTION_TYPE IN RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE) IS
83: SELECT

Line 123: JAI_CMN_RG_23D_TRXS

119: ,0),
120: NVL(VENDOR_SITE_ID
121: ,0)
122: FROM
123: JAI_CMN_RG_23D_TRXS
124: WHERE REGISTER_ID = P_REGISTER_ID;
125: V_SHIPMENT_LINE_ID NUMBER;
126: V_CUST_ID NUMBER;
127: V_CUST_SITE_ID NUMBER;

Line 226: JAI_CMN_RG_23D_TRXS A,

222: SUBSTR(B.VENDOR_NAME || ' ' || C.ADDRESS_LINE1 || ' ' || ADDRESS_LINE2 || ' ' || ADDRESS_LINE3 || ' ' || D.EXCISE_DUTY_RANGE || ' ' || D.EXCISE_DUTY_DIVISION || ' ' || D.EXCISE_DUTY_COMM
223: ,1
224: ,255)
225: FROM
226: JAI_CMN_RG_23D_TRXS A,
227: PO_VENDORS B,
228: PO_VENDOR_SITES_ALL C,
229: JAI_CMN_VENDOR_SITES D
230: WHERE A.VENDOR_ID = B.VENDOR_ID

Line 266: JAI_CMN_RG_23D_TRXS

262: ,0),
263: NVL(VENDOR_SITE_ID
264: ,0)
265: FROM
266: JAI_CMN_RG_23D_TRXS
267: WHERE REGISTER_ID = P_REGISTER_ID;
268: V_CUSTOMER_ID NUMBER;
269: V_ADDRESS_ID NUMBER;
270: V_VENDOR_ID NUMBER;

Line 503: JAI_CMN_RG_23D_TRXS A,

499: ,1
500: ,255),
501: D.VENDOR_TYPE
502: FROM
503: JAI_CMN_RG_23D_TRXS A,
504: PO_VENDORS B,
505: PO_VENDOR_SITES_ALL C,
506: JAI_CMN_VENDOR_SITES D
507: WHERE A.VENDOR_ID = B.VENDOR_ID

Line 526: JAI_CMN_RG_23D_TRXS

522: ,0),
523: NVL(VENDOR_SITE_ID
524: ,0)
525: FROM
526: JAI_CMN_RG_23D_TRXS
527: WHERE REGISTER_ID = P_REGISTER_ID;
528: V_SUPPLIER_TYPE VARCHAR2(100) := 'NONE';
529: V_ENTERED_INTO_LOOP VARCHAR2(5) := 'NO';
530: CURSOR C_ORG_SUPPLIER_TYPE(P_VENDOR_ID IN NUMBER,P_VENDOR_SITE_ID IN NUMBER) IS

Line 602: JAI_CMN_RG_23D_TRXS

598: CURSOR C_SHIPPED_QTY(P_REGISTER_ID IN NUMBER) IS
599: SELECT
600: QTY_TO_ADJUST
601: FROM
602: JAI_CMN_RG_23D_TRXS
603: WHERE REGISTER_ID = P_REGISTER_ID;
604: CURSOR C_MATCHED_QTY(P_REGISTER_ID IN NUMBER) IS
605: SELECT
606: SUM(QUANTITY_APPLIED)

Line 615: JAI_CMN_RG_23D_TRXS

611: SELECT
612: NVL(SUM(QTY_TO_ADJUST)
613: ,0)
614: FROM
615: JAI_CMN_RG_23D_TRXS
616: WHERE REGISTER_ID = P_REGISTER_ID;
617: CURSOR C_MATCHED_QTY_ISO(P_REGISTER_ID IN NUMBER,CP_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.TRANSACTION_TYPE%TYPE) IS
618: SELECT
619: NVL(SUM(QUANTITY_APPLIED)

Line 617: CURSOR C_MATCHED_QTY_ISO(P_REGISTER_ID IN NUMBER,CP_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.TRANSACTION_TYPE%TYPE) IS

613: ,0)
614: FROM
615: JAI_CMN_RG_23D_TRXS
616: WHERE REGISTER_ID = P_REGISTER_ID;
617: CURSOR C_MATCHED_QTY_ISO(P_REGISTER_ID IN NUMBER,CP_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.TRANSACTION_TYPE%TYPE) IS
618: SELECT
619: NVL(SUM(QUANTITY_APPLIED)
620: ,0)
621: FROM

Line 627: JAI_CMN_RG_23D_TRXS A

623: WHERE RECEIPT_ID IN (
624: SELECT
625: REGISTER_ID
626: FROM
627: JAI_CMN_RG_23D_TRXS A
628: WHERE ( A.ORGANIZATION_ID , A.LOCATION_ID , A.INVENTORY_ITEM_ID , A.COMM_INVOICE_NO , A.FIN_YEAR ) IN (
629: SELECT
630: ORGANIZATION_ID,
631: LOCATION_ID,

Line 636: JAI_CMN_RG_23D_TRXS

632: INVENTORY_ITEM_ID,
633: COMM_INVOICE_NO,
634: FIN_YEAR
635: FROM
636: JAI_CMN_RG_23D_TRXS
637: WHERE REGISTER_ID = P_REGISTER_ID )
638: AND TRANSACTION_TYPE = CP_TRANSACTION_TYPE );
639: V_SHIPPED_QTY NUMBER;
640: V_MATCHED_QTY NUMBER;