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_SHIPMENT_HEADERS

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 334: RCV_SHIPMENT_HEADERS RCVSH,

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
338: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID

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 376: RCV_SHIPMENT_HEADERS RCVSH,

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
380: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID

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 428: RCV_SHIPMENT_HEADERS RCVSH,

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
432: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID

Line 701: RCV_SHIPMENT_HEADERS RCV,

697: CURSOR C_GET_RECEIPT_NUM IS
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;

Line 705: V_RECEIPT_NUM RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE;

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;
707: BEGIN
708: V_RECEIPT_NUM := ' ';
709: LV_REMARKS := '';