APPS.GMF_MIGRATION dependencies on PO_VEND_MST

Line 537: l_vendor_site_id po_vend_mst.of_vendor_site_id%TYPE;

533: /************************
534: * Local Variables *
535: ************************/
536:
537: l_vendor_site_id po_vend_mst.of_vendor_site_id%TYPE;
538:
539: /****************
540: * Cursors *
541: ****************/

Line 549: FROM po_vend_mst

545: p_vendor_id IN NUMBER
546: )
547: IS
548: SELECT of_vendor_site_id
549: FROM po_vend_mst
550: WHERE vendor_id = p_vendor_id;
551:
552: BEGIN
553: OPEN cur_vendor_id(p_vendor_id);

Line 606: l_vendor_no po_vend_mst.vendor_no%TYPE;

602: IS
603: /************************
604: * Local Variables *
605: ************************/
606: l_vendor_no po_vend_mst.vendor_no%TYPE;
607: /****************
608: * Cursors *
609: ****************/
610: CURSOR cur_vendor_no

Line 616: FROM po_vend_mst

612: p_vendor_id IN NUMBER
613: )
614: IS
615: SELECT vendor_no
616: FROM po_vend_mst
617: WHERE vendor_id = p_vendor_id;
618: BEGIN
619: OPEN cur_vendor_no(p_vendor_id);
620: FETCH cur_vendor_no INTO l_vendor_no;

Line 6489: l_vendor_site_id PO_VEND_MST.of_vendor_site_id%TYPE;

6485:
6486: l_inventory_item_id MTL_SYSTEM_ITEMS_B.inventory_item_id%TYPE;
6487: l_item MTL_ITEM_FLEXFIELDS.item_number%TYPE;
6488: l_customer_no OP_CUST_MST.cust_no%TYPE;
6489: l_vendor_site_id PO_VEND_MST.of_vendor_site_id%TYPE;
6490: l_taxauth_code TX_TAXA_MST.taxauth_code%TYPE;
6491: l_Charge_code OP_CHRG_MST.Charge_code%TYPE;
6492: l_routing_no GMD_ROUTINGS_B.routing_no%TYPE;
6493: l_routing_vers GMD_ROUTINGS_B.routing_vers%TYPE;

Line 14422: FROM po_vend_mst v

14418: UPDATE gl_acct_map gam
14419: SET gam.vendor_id
14420: = (
14421: SELECT v.of_vendor_site_id
14422: FROM po_vend_mst v
14423: WHERE v.vendor_id = gam.vendor_id
14424: ),
14425: gam.migrated_ind = 1
14426: WHERE gam.vendor_id IS NOT NULL