DBA Data[Home] [Help]

APPS.JA_JAIN23D_XMLP_PKG dependencies on RCV_TRANSACTIONS

Line 78: RCV_TRANSACTIONS RCV,

74: RCV.SHIPMENT_LINE_ID,
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

Line 82: CURSOR C_DELIVER_DTLS(P_SHIPMENT_LINE_ID IN NUMBER,CP_TRANSACTION_TYPE IN RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE) IS

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
84: CUSTOMER_ID,
85: CUSTOMER_SITE_ID
86: FROM

Line 87: RCV_TRANSACTIONS

83: SELECT
84: CUSTOMER_ID,
85: CUSTOMER_SITE_ID
86: FROM
87: RCV_TRANSACTIONS
88: WHERE SHIPMENT_LINE_ID = P_SHIPMENT_LINE_ID
89: AND TRANSACTION_TYPE = CP_TRANSACTION_TYPE;
90: CURSOR C_RMA_CUST_ADDRESS(P_CUSTOMER_ID IN NUMBER,P_CUSTOMER_SITE_ID IN NUMBER) IS
91: SELECT