[Home] [Help]
145:
146: --******************FETCHING FORM ID FROM SEQUENCE************
147: CURSOR c_form_id IS
148: SELECT JAI_PO_OSP_HDRS_S.NEXTVAL
149: FROM dual;
150:
151: --******************FETCHING LINE ID FROM SEQUENCE************
152: CURSOR c_line_id IS
153: SELECT JAI_PO_OSP_LINES_S.NEXTVAL
150:
151: --******************FETCHING LINE ID FROM SEQUENCE************
152: CURSOR c_line_id IS
153: SELECT JAI_PO_OSP_LINES_S.NEXTVAL
154: FROM dual;
155: --*****************OSP RETURN DAYS****************************
156: CURSOR c_osp_days(cp_org_id NUMBER) IS
157: SELECT osp_return_days, osp_excise_percent
158: FROM JAI_CMN_INVENTORY_ORGS
500: AND wip_supply_type <> 6
501: UNION
502: select c_po_dist.quantity_ordered , 1 , rec_po_line_cur.item_id , 1 ,
503: 'P' item_type, 'PO Entry' comments
504: from dual
505: where ( ln_routing_ctr > 0 or ln_routing_seq_id is NULL OR ln_ja_ctr = 0) /*Bug 4609260*/
506: union
507: select 1 , dtl.quantity , dtl.item_id , 1 , 'M' item_type,'Manual Entry' comments
508: from JAI_PO_OSP_ITM_DTLS dtl
1408: /*------------------------------------------------------------------------------------------
1409: CHANGE HISTORY: FILENAME: ja_in_update_57F4.sql
1410: S.No Date Author and Details
1411: ------------------------------------------------------------------------------------------
1412: 1 01-JUN-2001 Satya Added DUAL UOM functionality
1413:
1414: 2 29-OCT-2002 Nagaraj.s for Bug2643016
1415: As Functionally required, an Update statement is written to update the CR_REG_ENTRY_DATE of
1416: the ja_in_57f4_table. This will definitely have implications on Approve 57f4 receipt screen on