1925: FROM mrp_ap_apps_instances;
1926:
1927: CURSOR error_message(c_errro_code number) IS
1928: select meaning
1929: from mfg_lookups
1930: where lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
1931: and lookup_code = c_errro_code;
1932:
1933: CURSOR get_item_segments(c_item_id number,c_organization_id number) IS
4691: and lookup_code = l_type;
4692:
4693: CURSOR get_item_type_meaning(l_item_type number) IS
4694: select meaning
4695: from mfg_lookups
4696: where lookup_type
4697: like 'MTL_RELATIONSHIP_TYPES'
4698: and lookup_code = l_item_type;
4699:
4838: and lookup_code = l_type;
4839:
4840: CURSOR get_item_type_meaning(l_item_type number) IS
4841: select meaning
4842: from mfg_lookups
4843: where lookup_type
4844: like 'MTL_RELATIONSHIP_TYPES'
4845: and lookup_code = l_item_type;
4846:
5028: and lookup_code = l_type;
5029:
5030: CURSOR get_item_type_meaning(l_item_type number) IS
5031: select meaning
5032: from mfg_lookups
5033: where lookup_type
5034: like 'MTL_RELATIONSHIP_TYPES'
5035: and lookup_code = l_item_type;
5036: