eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_JAIN23P2_XMLP_PKG dependencies on RCV_TRANSACTIONS

Line 328: CURSOR INT_ORDER_CUR(P_RECEIPT_ID IN VARCHAR2,CP_TRANSACTION_TYPE IN RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,CP_RCPT_SRC_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS

324: FROM
325: JAI_CMN_INVENTORY_ORGS
326: WHERE ORGANIZATION_ID = ABS(VENDOR_ID)
327: AND LOCATION_ID = ABS(VENDOR_SITE_ID);
328: CURSOR INT_ORDER_CUR(P_RECEIPT_ID IN VARCHAR2,CP_TRANSACTION_TYPE IN RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,CP_RCPT_SRC_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS
329: SELECT
330: DISTINCT
331: JU.EXCISE_DUTY_DIVISION
332: FROM

Line 333: RCV_TRANSACTIONS RCVT,

329: SELECT
330: DISTINCT
331: JU.EXCISE_DUTY_DIVISION
332: FROM
333: RCV_TRANSACTIONS RCVT,
334: RCV_SHIPMENT_HEADERS RCVSH,
335: JAI_CMN_INVENTORY_ORGS JU
336: WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
337: AND RCVT.TRANSACTION_TYPE = CP_TRANSACTION_TYPE

Line 370: CURSOR INT_ORDER_CUR(P_RECEIPT_ID IN VARCHAR2,CP_TRANSACTION_TYPE IN RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,CP_RCPT_SRC_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS

366: FROM
367: JAI_CMN_INVENTORY_ORGS
368: WHERE ORGANIZATION_ID = ABS(VENDOR_ID)
369: AND LOCATION_ID = ABS(VENDOR_SITE_ID);
370: CURSOR INT_ORDER_CUR(P_RECEIPT_ID IN VARCHAR2,CP_TRANSACTION_TYPE IN RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,CP_RCPT_SRC_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS
371: SELECT
372: DISTINCT
373: JU.EXCISE_DUTY_RANGE
374: FROM

Line 375: RCV_TRANSACTIONS RCVT,

371: SELECT
372: DISTINCT
373: JU.EXCISE_DUTY_RANGE
374: FROM
375: RCV_TRANSACTIONS RCVT,
376: RCV_SHIPMENT_HEADERS RCVSH,
377: JAI_CMN_INVENTORY_ORGS JU
378: WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
379: AND RCVT.TRANSACTION_TYPE = CP_TRANSACTION_TYPE

Line 422: CURSOR INT_ORDER_CUR(P_RECEIPT_ID IN VARCHAR2,CP_TRANSACTION_TYPE IN RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,CP_RCPT_SRC_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS

418: FROM
419: JAI_CMN_INVENTORY_ORGS
420: WHERE ORGANIZATION_ID = ABS(VENDOR_ID)
421: AND LOCATION_ID = ABS(VENDOR_SITE_ID);
422: CURSOR INT_ORDER_CUR(P_RECEIPT_ID IN VARCHAR2,CP_TRANSACTION_TYPE IN RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,CP_RCPT_SRC_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS
423: SELECT
424: DISTINCT
425: JU.EC_CODE
426: FROM

Line 427: RCV_TRANSACTIONS RCVT,

423: SELECT
424: DISTINCT
425: JU.EC_CODE
426: FROM
427: RCV_TRANSACTIONS RCVT,
428: RCV_SHIPMENT_HEADERS RCVSH,
429: JAI_CMN_INVENTORY_ORGS JU
430: WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
431: AND RCVT.TRANSACTION_TYPE = CP_TRANSACTION_TYPE

Line 551: JAI_RCV_TRANSACTIONS

547: SELECT
548: TRANSACTION_TYPE,
549: PARENT_TRANSACTION_TYPE
550: FROM
551: JAI_RCV_TRANSACTIONS
552: WHERE TRANSACTION_ID = CP_TRANSACTION_ID;
553: R_RCV_TRX_TYPE C_RCV_TRX_TYPE%ROWTYPE;
554: BEGIN
555: IF TRANSACTION_ID = 18 THEN

Line 702: RCV_TRANSACTIONS RTRAN

698: SELECT
699: RCV.RECEIPT_NUM
700: FROM
701: RCV_SHIPMENT_HEADERS RCV,
702: RCV_TRANSACTIONS RTRAN
703: WHERE rtran.transaction_id (+) = RECEIPT_ID
704: AND rcv.shipment_header_id (+) = RTRAN.SHIPMENT_HEADER_ID;
705: V_RECEIPT_NUM RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE;
706: LV_REMARKS JAI_CMN_RG_23AC_II_TRXS.REMARKS%TYPE;