DBA Data[Home] [Help]

APPS.GML_PO_INTERFACE dependencies on SY_UOMS_MST

Line 87: v_order_um1 SY_UOMS_MST.UM_CODE%TYPE;

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:
89:
90: /* Definitions for variables that are derived from columns of
91: po_lines_all table*/

Line 281: FROM sy_uoms_mst

277: /* Cursor to fetch OPM uom code corr. to 25 char APPS unit of measure **/
278: CURSOR uom_code_cur
279: IS
280: SELECT um_code
281: FROM sy_uoms_mst
282: WHERE unit_of_measure = v_unit_meas_lookup_code;
283:
284: /* Uday Phadtare B1410454 Select the orgn code for the release */
285: CURSOR opm_rel_orgn_cur