DBA Data[Home] [Help]

APPS.GML_SYNCH_BPOS dependencies on OP_FOBC_MST

Line 289: CURSOR fob_code_cur (p_of_fob_code OP_FOBC_MST.OF_FOB_CODE%TYPE) IS

285: WHERE of_vendor_site_id = p_of_vendor_site_id;
286:
287: /* Cursor to select fob_code */
288:
289: CURSOR fob_code_cur (p_of_fob_code OP_FOBC_MST.OF_FOB_CODE%TYPE) IS
290: SELECT fob_code
291: FROM op_fobc_mst
292: WHERE of_fob_code = p_of_fob_code;
293:

Line 291: FROM op_fobc_mst

287: /* Cursor to select fob_code */
288:
289: CURSOR fob_code_cur (p_of_fob_code OP_FOBC_MST.OF_FOB_CODE%TYPE) IS
290: SELECT fob_code
291: FROM op_fobc_mst
292: WHERE of_fob_code = p_of_fob_code;
293:
294: /* Cursor to select terms_code */
295:

Line 352: v_fob_code OP_FOBC_MST.FOB_CODE%TYPE;

348:
349: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;
350: v_ship_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
351: v_pay_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
352: v_fob_code OP_FOBC_MST.FOB_CODE%TYPE;
353: v_terms_code OP_TERM_MST.TERMS_CODE%TYPE;
354:
355: v_exchange_rate GL_XCHG_RTE.EXCHANGE_RATE%TYPE;
356: v_mul_div_sign GL_XCHG_RTE.MUL_DIV_SIGN%TYPE;