APPS.JA_JAINMCEN_XMLP_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 97: JAI_CMN_INVENTORY_ORGS

93: EXCISE_DUTY_RANGE,
94: EXCISE_DUTY_DIVISION,
95: EXCISE_DUTY_CIRCLE
96: FROM
97: JAI_CMN_INVENTORY_ORGS
98: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
99: AND LOCATION_ID = P_LOCATION_ID) LOOP
100: P_EC_CODE := EC_REC.EC_CODE;
101: P_COLLECT := EC_REC.EXCISE_DUTY_COMM;

Line 265: JAI_CMN_INVENTORY_ORGS JU

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
269: AND RCVSH.RECEIPT_SOURCE_CODE = CP_RECEIPT_SOURCE_CODE

Line 275: JAI_CMN_INVENTORY_ORGS JHRU

271: CURSOR C_FETCH_ECCODE_FOR_ISO IS
272: SELECT
273: JHRU.EC_CODE
274: FROM
275: JAI_CMN_INVENTORY_ORGS JHRU
276: WHERE ORGANIZATION_ID = ABS(VENDOR_ID)
277: AND LOCATION_ID = ABS(VENDOR_SITE_ID);
278: V_EC_CODE JAI_CMN_INVENTORY_ORGS.EC_CODE%TYPE;
279: BEGIN

Line 278: V_EC_CODE JAI_CMN_INVENTORY_ORGS.EC_CODE%TYPE;

274: FROM
275: JAI_CMN_INVENTORY_ORGS JHRU
276: WHERE ORGANIZATION_ID = ABS(VENDOR_ID)
277: AND LOCATION_ID = ABS(VENDOR_SITE_ID);
278: V_EC_CODE JAI_CMN_INVENTORY_ORGS.EC_CODE%TYPE;
279: BEGIN
280: IF VENDOR_ID IS NULL THEN
281: OPEN INT_ORDER_CUR(CP_RECEIPT_ID => RECEIPT_ID,CP_RECEIPT_SOURCE_CODE => 'INTERNAL ORDER');
282: FETCH INT_ORDER_CUR

Line 321: JAI_CMN_INVENTORY_ORGS JHRU,

317: CURSOR C_VENDOR_NAME_FOR_ISO IS
318: SELECT
319: HRU.NAME
320: FROM
321: JAI_CMN_INVENTORY_ORGS JHRU,
322: HR_ALL_ORGANIZATION_UNITS HRU
323: WHERE JHRU.ORGANIZATION_ID = ABS(VENDOR_ID)
324: AND JHRU.LOCATION_ID = ABS(VENDOR_SITE_ID)
325: AND HRU.ORGANIZATION_ID = JHRU.ORGANIZATION_ID;

Line 371: JAI_CMN_INVENTORY_ORGS JHRU,

367: ,'Manufacturing'
368: ,JHRU.TRADING
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

Line 387: JAI_CMN_INVENTORY_ORGS JHRU

383: ,'Manufacturing'
384: ,JHRU.TRADING
385: ,'Dealer')
386: FROM
387: JAI_CMN_INVENTORY_ORGS JHRU
388: WHERE ORGANIZATION_ID = ABS(VENDOR_ID)
389: AND LOCATION_ID = ABS(VENDOR_SITE_ID);
390: V_VENDOR_TYPE VARCHAR2(80);
391: BEGIN