[Home] [Help]
492: ,VENDOR_SITE_ID IN NUMBER
493: ,RECEIPT_ID IN VARCHAR2
494: ,VEND_DTLS IN VARCHAR2) RETURN CHAR IS
495: LV_RCV_TRANSACTION CONSTANT RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE DEFAULT 'RECEIVE';
496: LCV_INT_ORD CONSTANT RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE DEFAULT 'INTERNAL ORDER';
497: CURSOR INT_ORDER_CUR(P_RECEIPT_ID IN VARCHAR2) IS
498: SELECT
499: SUBSTR(HRU.NAME
500: ,1
513: ,10)
514: FROM
515: HR_LOCATIONS HRL,
516: RCV_TRANSACTIONS RCVT,
517: RCV_SHIPMENT_HEADERS RCVSH,
518: JAI_OM_WSH_LINES_ALL JSPL,
519: HR_ALL_ORGANIZATION_UNITS HRU
520: WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
521: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION
574: ,VENDOR_SITE_ID IN NUMBER
575: ,RECEIPT_ID IN VARCHAR2
576: ,RANGE1 IN VARCHAR2) RETURN CHAR IS
577: LV_RCV_TRANSACTION CONSTANT RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE DEFAULT 'RECEIVE';
578: LV_INT_ORD CONSTANT RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE DEFAULT 'INTERNAL ORDER';
579: CURSOR C_RANGE_NO_FOR_ISO IS
580: SELECT
581: EXCISE_DUTY_RANGE
582: FROM
588: DISTINCT
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
618: ,VENDOR_SITE_ID IN NUMBER
619: ,RECEIPT_ID IN VARCHAR2
620: ,DIVISION1 IN VARCHAR2) RETURN CHAR IS
621: LV_RCV_TRANSACTION CONSTANT RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE DEFAULT 'RECEIVE';
622: LV_INT_ORD CONSTANT RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE DEFAULT 'INTERNAL ORDER';
623: CURSOR C_DIVISION_NO_FOR_ISO IS
624: SELECT
625: EXCISE_DUTY_DIVISION
626: FROM
632: DISTINCT
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