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 JAI_CMN_INVENTORY_ORGS

Line 294: JAI_CMN_INVENTORY_ORGS D,

290: D.EXCISE_DUTY_COMM,
291: D.EXCISE_DUTY_CIRCLE,
292: D.EC_CODE
293: FROM
294: JAI_CMN_INVENTORY_ORGS D,
295: HR_ALL_ORGANIZATION_UNITS B,
296: HR_LOCATIONS C
297: WHERE D.ORGANIZATION_ID = CP_ORGANIZATION_ID
298: AND D.LOCATION_ID = CP_LOCATION_ID

Line 325: JAI_CMN_INVENTORY_ORGS

321: CURSOR C_DIVISION_NO_FOR_ISO IS
322: SELECT
323: EXCISE_DUTY_DIVISION
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

Line 335: JAI_CMN_INVENTORY_ORGS JU

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
339: AND RCVSH.RECEIPT_SOURCE_CODE = CP_RCPT_SRC_CODE

Line 341: V_DIVISION_NO JAI_CMN_INVENTORY_ORGS.EXCISE_DUTY_DIVISION%TYPE;

337: AND RCVT.TRANSACTION_TYPE = CP_TRANSACTION_TYPE
338: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
339: AND RCVSH.RECEIPT_SOURCE_CODE = CP_RCPT_SRC_CODE
340: AND RCVSH.ORGANIZATION_ID = JU.ORGANIZATION_ID;
341: V_DIVISION_NO JAI_CMN_INVENTORY_ORGS.EXCISE_DUTY_DIVISION%TYPE;
342: BEGIN
343: IF VENDOR_ID < 0 THEN
344: OPEN C_DIVISION_NO_FOR_ISO;
345: FETCH C_DIVISION_NO_FOR_ISO

Line 367: JAI_CMN_INVENTORY_ORGS

363: CURSOR C_RANGE_NO_FOR_ISO IS
364: SELECT
365: EXCISE_DUTY_RANGE
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

Line 377: JAI_CMN_INVENTORY_ORGS JU

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
381: AND RCVSH.RECEIPT_SOURCE_CODE = CP_RCPT_SRC_CODE

Line 383: V_RANGE_NO JAI_CMN_INVENTORY_ORGS.EXCISE_DUTY_RANGE%TYPE;

379: AND RCVT.TRANSACTION_TYPE = CP_TRANSACTION_TYPE
380: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
381: AND RCVSH.RECEIPT_SOURCE_CODE = CP_RCPT_SRC_CODE
382: AND RCVSH.ORGANIZATION_ID = JU.ORGANIZATION_ID;
383: V_RANGE_NO JAI_CMN_INVENTORY_ORGS.EXCISE_DUTY_RANGE%TYPE;
384: BEGIN
385: IF VENDOR_ID < 0 THEN
386: OPEN C_RANGE_NO_FOR_ISO;
387: FETCH C_RANGE_NO_FOR_ISO

Line 419: JAI_CMN_INVENTORY_ORGS

415: CURSOR C_FETCH_EC_CODE_FOR_ISO IS
416: SELECT
417: EC_CODE
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

Line 429: JAI_CMN_INVENTORY_ORGS JU

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
433: AND RCVSH.RECEIPT_SOURCE_CODE = CP_RCPT_SRC_CODE