APPS.GML_PO_SYNCH dependencies on PO_VEND_MST

Line 1499: v_ship_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;

1495: v_item_um2 IC_ITEM_MST.ITEM_UM2%TYPE;
1496: v_item_um1 IC_ITEM_MST.ITEM_UM%TYPE; /* PPB */
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;

Line 1500: v_pay_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;

1496: v_item_um1 IC_ITEM_MST.ITEM_UM%TYPE; /* PPB */
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;

Line 1569: CURSOR vendor_cur(v_of_shipvend_site_id PO_VEND_MST.OF_VENDOR_SITE_ID%TYPE,

1565: AND po_line_id = v_po_line_id
1566: AND po_line_location_id = v_source_shipment_id;
1567:
1568: /* BUG#:1231038 match vendor_id with co_code */
1569: CURSOR vendor_cur(v_of_shipvend_site_id PO_VEND_MST.OF_VENDOR_SITE_ID%TYPE,
1570: v_co_code PO_VEND_MST.CO_CODE%TYPE)
1571: IS
1572: SELECT vendor_id
1573: FROM po_vend_mst

Line 1570: v_co_code PO_VEND_MST.CO_CODE%TYPE)

1566: AND po_line_location_id = v_source_shipment_id;
1567:
1568: /* BUG#:1231038 match vendor_id with co_code */
1569: CURSOR vendor_cur(v_of_shipvend_site_id PO_VEND_MST.OF_VENDOR_SITE_ID%TYPE,
1570: v_co_code PO_VEND_MST.CO_CODE%TYPE)
1571: IS
1572: SELECT vendor_id
1573: FROM po_vend_mst
1574: WHERE of_vendor_site_id = v_of_shipvend_site_id

Line 1573: FROM po_vend_mst

1569: CURSOR vendor_cur(v_of_shipvend_site_id PO_VEND_MST.OF_VENDOR_SITE_ID%TYPE,
1570: v_co_code PO_VEND_MST.CO_CODE%TYPE)
1571: IS
1572: SELECT vendor_id
1573: FROM po_vend_mst
1574: WHERE of_vendor_site_id = v_of_shipvend_site_id
1575: AND co_code = v_co_code;
1576:
1577: CURSOR terms_code_cur(v_of_terms_code OP_TERM_MST.OF_TERMS_CODE%TYPE) IS