APPS.GML_PO_SYNCH dependencies on OP_FRGT_MTH

Line 1501: v_frtbill_mthd OP_FRGT_MTH.FRTBILL_MTHD%TYPE;

1497: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;
1498: v_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;
1499: v_ship_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
1500: v_pay_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
1501: v_frtbill_mthd OP_FRGT_MTH.FRTBILL_MTHD%TYPE;
1502: v_terms_code OP_TERM_MST.TERMS_CODE%TYPE;
1503: v_new_trans_id IC_TRAN_PND.TRANS_ID%TYPE;
1504: v_co_code SY_ORGN_MST.CO_CODE%TYPE;
1505: v_old_order_qty1 PO_ORDR_DTL.ORDER_QTY1%TYPE;

Line 1621: CURSOR frtbill_mthd_cur(c_of_frtbill_mthd OP_FRGT_MTH.OF_FRTBILL_MTHD%TYPE) IS

1617: AND line_id = v_line_id;
1618:
1619:
1620: /* T. Ricci 11/10/98 added frtbill_mthd_cur so OPM value will be used*/
1621: CURSOR frtbill_mthd_cur(c_of_frtbill_mthd OP_FRGT_MTH.OF_FRTBILL_MTHD%TYPE) IS
1622: SELECT frtbill_mthd
1623: FROM op_frgt_mth
1624: WHERE of_frtbill_mthd = c_of_frtbill_mthd;
1625:

Line 1623: FROM op_frgt_mth

1619:
1620: /* T. Ricci 11/10/98 added frtbill_mthd_cur so OPM value will be used*/
1621: CURSOR frtbill_mthd_cur(c_of_frtbill_mthd OP_FRGT_MTH.OF_FRTBILL_MTHD%TYPE) IS
1622: SELECT frtbill_mthd
1623: FROM op_frgt_mth
1624: WHERE of_frtbill_mthd = c_of_frtbill_mthd;
1625:
1626: complete_msg VARCHAR2(2000);
1627: