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_JAIN23C1_XMLP_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 583: JAI_CMN_INVENTORY_ORGS

579: CURSOR C_RANGE_NO_FOR_ISO IS
580: SELECT
581: EXCISE_DUTY_RANGE
582: FROM
583: JAI_CMN_INVENTORY_ORGS
584: WHERE ORGANIZATION_ID = ABS(VENDOR_ID)
585: AND LOCATION_ID = ABS(VENDOR_SITE_ID);
586: CURSOR INT_ORDER_CUR(P_RECEIPT_ID IN VARCHAR2) IS
587: SELECT

Line 593: JAI_CMN_INVENTORY_ORGS JU

589: JU.EXCISE_DUTY_RANGE
590: FROM
591: RCV_TRANSACTIONS RCVT,
592: RCV_SHIPMENT_HEADERS RCVSH,
593: JAI_CMN_INVENTORY_ORGS JU
594: WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
595: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION
596: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
597: AND RCVSH.RECEIPT_SOURCE_CODE = LV_INT_ORD

Line 599: V_RANGE_NO JAI_CMN_INVENTORY_ORGS.EXCISE_DUTY_RANGE%TYPE;

595: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION
596: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
597: AND RCVSH.RECEIPT_SOURCE_CODE = LV_INT_ORD
598: AND RCVSH.ORGANIZATION_ID = JU.ORGANIZATION_ID;
599: V_RANGE_NO JAI_CMN_INVENTORY_ORGS.EXCISE_DUTY_RANGE%TYPE;
600: BEGIN
601: IF VENDOR_ID < 0 THEN
602: OPEN C_RANGE_NO_FOR_ISO;
603: FETCH C_RANGE_NO_FOR_ISO

Line 627: JAI_CMN_INVENTORY_ORGS

623: CURSOR C_DIVISION_NO_FOR_ISO IS
624: SELECT
625: EXCISE_DUTY_DIVISION
626: FROM
627: JAI_CMN_INVENTORY_ORGS
628: WHERE ORGANIZATION_ID = ABS(VENDOR_ID)
629: AND LOCATION_ID = ABS(VENDOR_SITE_ID);
630: CURSOR INT_ORDER_CUR(P_RECEIPT_ID IN VARCHAR2) IS
631: SELECT

Line 637: JAI_CMN_INVENTORY_ORGS JU

633: JU.EXCISE_DUTY_DIVISION
634: FROM
635: RCV_TRANSACTIONS RCVT,
636: RCV_SHIPMENT_HEADERS RCVSH,
637: JAI_CMN_INVENTORY_ORGS JU
638: WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
639: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION
640: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
641: AND RCVSH.RECEIPT_SOURCE_CODE = LV_INT_ORD

Line 643: V_DIVISION_NO JAI_CMN_INVENTORY_ORGS.EXCISE_DUTY_DIVISION%TYPE;

639: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION
640: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
641: AND RCVSH.RECEIPT_SOURCE_CODE = LV_INT_ORD
642: AND RCVSH.ORGANIZATION_ID = JU.ORGANIZATION_ID;
643: V_DIVISION_NO JAI_CMN_INVENTORY_ORGS.EXCISE_DUTY_DIVISION%TYPE;
644: BEGIN
645: IF VENDOR_ID < 0 THEN
646: OPEN C_DIVISION_NO_FOR_ISO;
647: FETCH C_DIVISION_NO_FOR_ISO