DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_HORIZONTAL_PLAN dependencies on MFG_LOOKUPS

Line 944: l_shipping_control mfg_lookups.meaning%Type;

940: FUNCTION get_order_type_label (p_supplier_site_id NUMBER)
941: RETURN VARCHAR2 is
942:
943: l_supplier_site_label VARCHAR2(240);
944: l_shipping_control mfg_lookups.meaning%Type;
945:
946: CURSOR SUPPLIER_SITE_LABEL_C(p_supplier_site_id NUMBER) IS
947: select meaning,tp_site_code
948: from msc_trading_partner_sites,mfg_lookups

Line 948: from msc_trading_partner_sites,mfg_lookups

944: l_shipping_control mfg_lookups.meaning%Type;
945:
946: CURSOR SUPPLIER_SITE_LABEL_C(p_supplier_site_id NUMBER) IS
947: select meaning,tp_site_code
948: from msc_trading_partner_sites,mfg_lookups
949: where partner_site_id=p_supplier_site_id
950: and lookup_type = 'MSC_ORDER_DATE_TYPE'
951: and lookup_code = decode(shipping_control,'BUYER',1,2);
952: