APPS.JA_JAINMCEN_XMLP_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 258: CURSOR INT_ORDER_CUR(CP_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE,CP_RECEIPT_SOURCE_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS

254: FUNCTION CF_EC_CODEFORMULA(VENDOR_ID IN NUMBER
255: ,VENDOR_SITE_ID IN NUMBER
256: ,RECEIPT_ID IN VARCHAR2
257: ,EC_CODE IN VARCHAR2) RETURN CHAR IS
258: CURSOR INT_ORDER_CUR(CP_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE,CP_RECEIPT_SOURCE_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS
259: SELECT
260: DISTINCT
261: JU.EC_CODE
262: FROM

Line 264: RCV_SHIPMENT_HEADERS RCVSH,

260: DISTINCT
261: JU.EC_CODE
262: FROM
263: RCV_TRANSACTIONS RCVT,
264: RCV_SHIPMENT_HEADERS RCVSH,
265: JAI_CMN_INVENTORY_ORGS JU
266: WHERE RCVT.TRANSACTION_ID = CP_RECEIPT_ID
267: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION_TYPE
268: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID

Line 305: CURSOR INT_ORDER_CUR(P_RECEIPT_ID IN VARCHAR2,CP_RECEIPT_SOURCE_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS

301:
302: FUNCTION CF_VENDOR_NAMEFORMULA(VENDOR_ID IN NUMBER
303: ,VENDOR_SITE_ID IN NUMBER
304: ,RECEIPT_ID IN VARCHAR2) RETURN CHAR IS
305: CURSOR INT_ORDER_CUR(P_RECEIPT_ID IN VARCHAR2,CP_RECEIPT_SOURCE_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS
306: SELECT
307: HRU.NAME
308: FROM
309: RCV_TRANSACTIONS RCVT,

Line 310: RCV_SHIPMENT_HEADERS RCVSH,

306: SELECT
307: HRU.NAME
308: FROM
309: RCV_TRANSACTIONS RCVT,
310: RCV_SHIPMENT_HEADERS RCVSH,
311: HR_ORGANIZATION_UNITS HRU
312: WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
313: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION_TYPE
314: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID

Line 363: CURSOR FOR_INT_SALES_ORDER(P_RECEIPT_ID IN VARCHAR2,CP_RECEIPT_SOURCE_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS

359: FUNCTION CF_VENDOR_TYPEFORMULA(VENDOR_ID IN NUMBER
360: ,VENDOR_SITE_ID IN NUMBER
361: ,RECEIPT_ID IN VARCHAR2
362: ,VENDOR_TYPE IN VARCHAR2) RETURN CHAR IS
363: CURSOR FOR_INT_SALES_ORDER(P_RECEIPT_ID IN VARCHAR2,CP_RECEIPT_SOURCE_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS
364: SELECT
365: DECODE('Y'
366: ,JHRU.MANUFACTURING
367: ,'Manufacturing'

Line 373: RCV_SHIPMENT_HEADERS RCVSH

369: ,'Dealer')
370: FROM
371: JAI_CMN_INVENTORY_ORGS JHRU,
372: RCV_TRANSACTIONS RCVT,
373: RCV_SHIPMENT_HEADERS RCVSH
374: WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
375: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION_TYPE
376: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
377: AND RCVSH.RECEIPT_SOURCE_CODE = CP_RECEIPT_SOURCE_CODE