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.JAI_CMN_RG_OPM_PKG dependencies on JAI_OPM_OSP_HDRS

Line 36: JAI_OPM_OSP_HDRS b

32: a.organization_id,
33: a.inventory_item_id
34: From
35: JAI_OPM_OSP_DTLS a,
36: JAI_OPM_OSP_HDRS b
37: Where a.osp_header_id = p_ospheader
38: and a.issue_recpt_flag = p_mode
39: and b.osp_header_id = a.osp_header_id
40: and a.trans_date <= b.extended_due_date

Line 66: From JAI_OPM_OSP_HDRS

62: AND inventory_item_id = cpn_inv_itm_id ;-- item_id = p_item_id;
63:
64: Cursor C_tran_date IS
65: Select transaction_date
66: From JAI_OPM_OSP_HDRS
67: Where osp_header_id = p_ospheader;
68:
69: CURSOR fin_year_cur (cpn_organization_id jai_cmn_fin_years.organization_id%type)
70: IS

Line 604: from JAI_OPM_OSP_HDRS

600: AND inventory_item_id = p_inventory_item_id ;--item_id = p_item_id;
601:
602: cursor C_po_id is
603: select po_id
604: from JAI_OPM_OSP_HDRS
605: where osp_header_id = p_ospheader;
606:
607: cursor C_vendor is
608: select vendor_id, vendor_site_id

Line 619: from JAI_OPM_OSP_HDRS

615: where vendor_id = l_shipvend_id;
616:
617: cursor C_Excise_Payable IS
618: select payable_excise
619: from JAI_OPM_OSP_HDRS
620: where osp_header_id = p_ospheader ;
621:
622: cursor fin_year_cur IS
623: select max(a.fin_year)