[Home] [Help]
19: # 07-JUL-98 Tony Ricci changes for GEMMS 5.0 nullable columns
20: # 11/10/98 T.Ricci added shipper_code_cur to retreive correct
21: # shipper_code 4 char value from op_ship_mst
22: # 11/11/98 T.Ricci added fob_code_cur to retreive correct
23: # fob_code 4 char value from op_fobc_mst
24: # 12/24/98 added defaults for who columns in cpg_oragems_mapping
25: # 05/13/99 T.Ricci removed checking of inventory_item_flag and
26: # replaced with call to check_opm_item
27: #
80: v_last_update_login PO_HEADERS_ALL.LAST_UPDATE_LOGIN%TYPE;
81: v_opm_rel_exchg_rate PO_HEADERS_ALL.RATE%TYPE; /* Bug 1427876 */
82:
83: v_shipper_code OP_SHIP_MST.SHIPPER_CODE%TYPE;
84: v_fob_code OP_FOBC_MST.FOB_CODE%TYPE;
85: /** MC BUG# 1554088 **/
86: /** new variable to hold order um1. **/
87: v_order_um1 SY_UOMS_MST.UM_CODE%TYPE;
88:
265: FROM op_ship_mst
266: WHERE of_shipper_code = v_ship_via_lookup_code;
267:
268: /* T.Ricci 11/11/98 added fob_code_cur to retreive correct fob_code
269: 4 char value from op_fobc_mst*/
270: CURSOR fob_code_cur
271: IS
272: SELECT fob_code
273: FROM op_fobc_mst
269: 4 char value from op_fobc_mst*/
270: CURSOR fob_code_cur
271: IS
272: SELECT fob_code
273: FROM op_fobc_mst
274: WHERE of_fob_code = v_fob_lookup_code;
275:
276: /** MC BUG# 1554088 **/
277: /* Cursor to fetch OPM uom code corr. to 25 char APPS unit of measure **/
387: INTO v_shipper_code;
388: CLOSE shipper_code_cur;
389:
390: /* T.Ricci 11/11/98 added fob_code_cur to retreive correct fob_code
391: 4 char value from op_fobc_mst*/
392: OPEN fob_code_cur;
393: FETCH fob_code_cur
394: INTO v_fob_code;
395: CLOSE fob_code_cur;