APPS.GML_SYNCH_BPOS dependencies on PO_VEND_MST

Line 281: CURSOR vendor_cur (p_of_vendor_site_id PO_VEND_MST.OF_VENDOR_SITE_ID%TYPE)

277: err_msg VARCHAR2(100);
278:
279: /* Cursor to select shipvend_id and payvend_id */
280:
281: CURSOR vendor_cur (p_of_vendor_site_id PO_VEND_MST.OF_VENDOR_SITE_ID%TYPE)
282: IS
283: SELECT vendor_id
284: FROM po_vend_mst
285: WHERE of_vendor_site_id = p_of_vendor_site_id;

Line 284: FROM po_vend_mst

280:
281: CURSOR vendor_cur (p_of_vendor_site_id PO_VEND_MST.OF_VENDOR_SITE_ID%TYPE)
282: IS
283: SELECT vendor_id
284: FROM po_vend_mst
285: WHERE of_vendor_site_id = p_of_vendor_site_id;
286:
287: /* Cursor to select fob_code */
288:

Line 350: v_ship_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;

346: v_item_um2 IC_ITEM_MST.ITEM_UM%TYPE;
347: v_item_dualum_ind IC_ITEM_MST.DUALUM_IND%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:

Line 351: v_pay_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;

347: v_item_dualum_ind IC_ITEM_MST.DUALUM_IND%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;